My Oracle Support Banner

InForm_Submit:SD, Query and DMW FLAG Programs are Skipped due to Loadset Data Adapter Failure (Doc ID 2704645.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

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

Symptoms

 

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.8.5 version,

ISSUE REPORTED
------------------- 

All InForm scheduled and manual data loads are failing with the following error found in the logfile:

***************FAILED JOB RECOVERY DETECTION**************
Checking whether rollback operation is required.
Identify whether previous job is failed for this executable instance.
Found last successful job needed for rollback operation:31666105
Identified failed job-id: 31699070 with refresh timestamp: 04-Aug-2020 02:18:25 PM for table id:<Table_ID>
Started rollback operation for this table using failed job :: 08-14-2020 19:03:24
Caught exception while performing rollback operation for this table ORA-00001: unique constraint (CDR_W###_########.T##########_1__UK) violated
Checking notification type.
Notification type:
Job status:$JOBSTATUSES$FAILURE
Execution Status : SETFAILURE :: Job Status: Failure :: Last Status Change Ts: 08-14-2020 19:03:24

Error Code: -20200:: Error Description: ORA-20200: *** ERROR: Rollback operation failed for this table with error(s) ORA-00001: unique constraint (CDR_W###_########.T##########_1__UK) violated::10:
Job's pre-processing failed with error(s)ORA-20200: *** ERROR: Rollback operation failed for this table with error(s) ORA-00001: unique constraint CDR_W###_########.T##########_SK_UK) violated

:
:
:
Setting DMW Processing Flag off in the InForm trial Database.
Initializing remote location<Remote_Location> for setDMWProcessingFlag procedure at 14-AUG-2020 19:03:24
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin "CDR_W###_#########.<Program_Name>" ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: InForm_Submit:SD, Query and DMW FLAG programs are skipped due to Loadset Data adapter failure - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2736
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 14988
ORA-06512: at "CDR_W###_#########.<Program_Name>", line 4

 

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.