Unable To Extract The Customers From BRM Using ODI For Loading Into ECE Cache
(Doc ID 2097903.1)
Last updated on AUGUST 13, 2018
Applies to:Oracle Communications BRM - Elastic Charging Engine - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11.2.0]
Information in this document applies to any platform.
On : ECE 126.96.36.199.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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document