Large File Load Failed with the Error "Rollback operation failed for this table with error(s) ORA-01407: cannot update" (Doc ID 3068492.1)

Last updated on JANUARY 22, 2025

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.4.0.1, users try to upload a large text file in DMW (approximately 23M records). The large load fails with the following error messages:

ERROR
---------
Started Rollback operation for this job.
Identified failed job-id: <JOB_ID> with refresh timestamp: 09-Dec-2024 01:05:31 PM for table id:<TABLE_ID>
Started rollback operation for this table using failed job :: 12-09-2024 15:07:36
Caught exception while performing rollback operation for this table ORA-01407: cannot update ("<CDR_SCHEMA_NAME>"."<TABLE_NAME>"."<COLUMN_NAME>") to NULL
Execution Status : SETFAILURE :: Job Status: Failure :: 12-09-2024 15:13:58

Error Code: -20200:: Error Description: ORA-20200: *** ERROR: Rollback operation failed for this table with error(s) ORA-01407: cannot update ("<CDR_SCHEMA_NAME>"."<TABLE_NAME>"."<COLUMN_NAME>") to NULL::11:
Job's post processing failed with error(s)ORA-20200: *** ERROR: Rollback operation failed for this table with error(s) ORA-01407: cannot update ("<CDR_SCHEMA_NAME>"."<TABLE_NAME>"."<COLUMN_NAME>") to NULL

Changes

For the Database user profile <DB_USER_PROFILE>, the IDLE_TIME was configured as 2 hours (120 minutes)

Cause

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