Unable To Extract The Customers From BRM Using ODI For Loading Into ECE Cache (Doc ID 2097903.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Communications BRM - Elastic Charging Engine - Version 11.2.0.4.0 to 11.2.0.5.0 [Release 11.2.0]
Information in this document applies to any platform.

Goal

On : ECE 11.2.0.4.0 version, ODI Transformation

Issue :

Unable to extract the customer from BRM using ODI (Oracle Data Integrator) for loading into ECE cache.

Some concerns to be addressed in this context are as below ;

1) How to solve “java.sql.SQLException: statement is not in batch mode” when extracting the customer?

Command used :
         extract.sh -extraction_type=customer -customer_type=ALL -extraction_dir=/Exports/15122015

The console log shows:



2) What is the criteria for this extraction.


It looks like the extracted xml is having only 10848 customer. ( grep '' *.xml | wc -l) whereas the PIN Schema is having 20089 in ACCOUNT_T table (where status=10100).
User used the following options while extracting, for both options the count is 10848:

            -extraction_type=customer -customer_type=non-shared
            -customer_type=ALL. For both options getting only the count 10848.

 
3) How to remove the unwanted conditions from the stored-procedure generation code in ODI?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms