My Oracle Support Banner

Issue In TBAML Batch (Doc ID 2864887.1)

Last updated on APRIL 28, 2022

Applies to:

Oracle Financial Services Trade-Based Anti Money Laundering Enterprise Edition - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

While executing TBAML Batch, it's failing at task 5 with ORA-01489: result of string concatenation is too long.

In fccdm_FCCMINFO_1647431435802_20211129_1Task5.log

[Wed Mar 16 17:25:20 PKT 2022]~[DEBUG]~[SYSADMN] [NA] Meta connection fetched
successfully for Infodom: FCCMINFO

Query to get Runskey>>select N_RUN_SKEY from FCC_BATCH_RUN where V_BATCH_RUN_ID = ?
setString(1, FCCMINFO_1647431435802_20211129_1)
2022/03/16 17:25:20:::runskey::1380 2022/03/16
17:25:20:::filters::"$RUNSKEY"="1380"[]"$MISDATE"="to_date(^20211129^,^yyyyMMdd^)"
2022/03/16 17:25:20:::sql:::{call PKG_FCC_DM.FccDMSameDBSepSchemaDI(?, ?,?,?)}2022/03/16
17:25:20:::sourceName::OFSAAFCCMJSdataMovementCode::TBAML_EVENT_DETAILS::runskey::1380::filters::"$RUNSKEY"="1380"[]"$MISDATE"="to_date(^20211129^,^yyyyMMdd^)"
java.sql.SQLException: ORA-20104: Create Temp Table failed
ORA-06512: at "OFSAAFCCMJS.PKG_FCC_DM", line 377
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
205)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at com.ofs.aai.fcc.datamovement.dao.DataMigrationExternalDAO.moveDataFromSeparteSourceSamefDB(DataMigrationExternalDAO.java:144)
at com.ofs.aai.fcc.datamovement.service.DataMovementService.moveDataFromSeparteSourceSameDB(DataMovementService.java:125)
at com.ofs.aai.fcc.datamovement.client.DMClient.main(DMClient.java:115)
Caused by: Error : 20104, Position : 0, Sql = BEGIN
PKG_FCC_DM.FccDMSameDBSepSchemaDI(:1 , :2 , :3 ,:4 ); END;, OriginalSql =
{call PKG_FCC_DM.FccDMSameDBSepSchemaDI(?, ?, ?,?)}, Error Msg = ORA-20104:
Create Temp Table failed
ORA-06512: at "OFSAAFCCMJS.PKG_FCC_DM", line 377
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

... 19 more

2022/03/16 17:25:20:::result:::1

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
Cause
Solution
References


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