My Oracle Support Banner

PLSQL Job Fails with 'ERROR: Cleanup processing DobjRef:<OBJ_ID>::10:' (Doc ID 2883221.1)

Last updated on JULY 14, 2022

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.9.1 and later
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Hub (LSH) 2.4.9.1 version,

When attempting to submit a PL/SQL job,
the following error occurs:

ERROR
-----------------------
Error Code: -20200:: Error Description: ORA-20200: *** ERROR: Cleanup processing DobjRef:<OBJ_ID>::10:
Job's post processin failed with error(s)ORA-20200: *** ERROR: Cleanup processing DobjRef:<OBJ_ID>



STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Recover LSH database from an outage.
2. Restart the LSH tech stack.
3. Submit for execution a PL/SQL job for a study in Production lifecycle, where one of the tables data was corrupted.

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


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