TMS Re-fire Fails With "Value for AECAT was too long for row with surrogate key..."

(Doc ID 2380805.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 and later
Information in this document applies to any platform.

Symptoms

DMW 2.4.7.3.1 but may occur in other versions, too.

After initiating the TMS re-fire, there is a failure in the triggered log.

Suddenly,  the job is not getting kicked off while sometimes it is getting kicked off. Sometimes the communication is not occurring between TMS and DMW. The workaround is to Force Rederive but sometimes they are not seeing the rederive kickoff.

Re-trigging the TMS jobs looks like it is working but it does not actually pass the derived terms through.

ERRORS
--------------

TMS Post-Processing Started: Target table: MY_TABLE (12345)
TMS Post-Process is executed in rederivation mode. All records will be reclassified.
TMS Post-Process is executed in non-production testmode.
TMS classifications will be attempted but results are not stored in TMS.
Discrepancies will be created and closed but updates are not supported.
Value for AECAT was too long for row with surrogate key of 74558410~29463~25435~29508~22408~531733303637020~1
The value from TMS was "C".
Value for AECAT was too long for row with surrogate key of 74558410~29463~25435~29508~22408~531733333657020~1
The value from TMS was "C".
...
TMS Post-Processing counts for target table: MY_TABLE (12345)
Deleted terms processed: 43
Inserted terms processed: 0
...

The table 'MY_TABLE_38CD0D5' has no data change.Hence end-dating the currency tracking record for this table for the current job
Execution Status : Complete :: Job Status: Success :: 03-02-2018 16:25:23
Finished post-processing. Elapsed time 00:00:02 :: 03-02-2018 16:25:23


Per Job log 100170117.log
Submit DEFERRED job. Job ID=100170117
Log for the job: PLSQL_UTIL_PROG_EXE
Parameters:
 UI_OPER: ......................DME_FWDCHAIN_EXECUTION
 JOB_PARAM1: ...................59585165~59585258~
 JOB_PARAM2: ...................24~23~
 JOB_PARAM3: ...................INFORM#100168901
 JOB_PARAM4: ...................No.
 JOB_PARAM5: ...................Full.

Execution Status : Initializing :: Job Status: Pending :: 02-28-2018 19:22:49
....

WARNING *** WARNING *** WARNING
One or More Transformation Master Program Jobs completed with Warnings.
WARNING *** WARNING *** WARNING

Execution Status : SETWARNING :: Job Status: Warnings :: 02-28-2018 19:28:06
:: Error Description: One or More Transformation Master Program Jobs completed with Warnings.
Execution Status : SETFAILURE :: Job Status: Failure :: 02-28-2018 19:28:06

Error Code: -20003:: Error Description: ORA-20003:
One or More Jobs completed with errors.at | Line number: 1315 | Unit: DME_EXE_FORWARDCHAIN

ORA-06512: at "APPS.DME_EXE_FORWARDCHAIN", line 1296

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_WCE6_21021_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_EXE_FORWARDCHAIN", line 1343
ORA-20003:
One or More Jobs completed with errors.
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 12509
ORA-06512: at "CDR_WCE6_21021_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Starting post-processing :: 02-28-2018 19:28:06

Execution Status : SETFAILURE :: Job Status: Failure :: 02-28-2018 19:28:06

Finished post-processing. Elapsed time 00:00:00 :: 02-28-2018 19:28:06

 

Cause

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