"Error in creating xml for table_name::ORA-01489": result of string concatenation is too long (Doc ID 3045697.1)

Last updated on SEPTEMBER 10, 2024

Applies to:

Symptoms

Calculation Preference template migrated through off-line mode. Template visible in the summary page, but when opened all the expressions showing blank for all variables.

Please find the below screenshot

When the customer converts Calculation Preference, two VFA templates now contain expression entries.
There is no information about those templates on the backend.

Verified the issue in the offline migration.log file as noted below.

LOG FILE
-----------------------
Filename = offline migration.log
See the following error:

25-07-24 03:53:02,368 GMT AM [WEB] [REVELEUS] Export-->Setting fetchsize:::100
25-07-24 03:53:02,369 GMT AM [WEB] [REVELEUS] Export-->StartDate:::FSI_CSM_CALC_TEMPLATE_DETAILS:::1721879582369
25-07-24 03:53:02,369 GMT AM [WEB] [REVELEUS] Export-->Number of placeholder present:::1
25-07-24 03:53:02,380 GMT AM [WEB] [REVELEUS] Error in creating xml for table_name::ORA-01489: result of string concatenation is too long

java.sql.SQLException: ORA-01489: result of string concatenation is too long

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]

Changes

No Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.