Data Management : EPMAgent Extracts are failing if Data Type having as CLOB or BLOB
(Doc ID 2693363.1)
Last updated on SEPTEMBER 15, 2022
Applies to:
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A to N/A [Release 11.1]Information in this document applies to any platform.
Symptoms
On : NA version, Data Integration using EPMAgent
When attempting to extract data using EPMAgent from SQL Server , Data Load are failing with JavaNullPoint errors.
Observed that , EPMAgent query to extract the data from SQL Server and SQL Query having LISTAGG function and it transforms values from a group of rows into a list of values that are delimited by a configurable separator.
LISTAGG is typically used to denormalize rows into a string of comma-separated values (CSV).
When Extracting data from SQL Query , the return type of LISTAGGis either VARCHAR or CLOB . Using the LISTAGG function in the SQL Query and list of values more than one , they Extract gets failed.
Means whenever LISTAGG converts data to CLOB then EPMAgent Extracts getting failed.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |