Unable To Extract The Customers From BRM Using ODI For Loading Into ECE Cache
Last updated on JULY 12, 2017
Applies to:Oracle Communications BRM - Elastic Charging Engine - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11.2.0]
Information in this document applies to any platform.
On : ECE 22.214.171.124.0 version, ODI Transformation
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:
-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