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 to [Release 11.2.0]
Information in this document applies to any platform.


On : ECE 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?


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