My Oracle Support Banner

LSH 2.5 Upgrade Patch 28529507- ORA-20010: Error in cdr25compidx.sql Index create script at :DME_DISC_WORKTABLIST (Doc ID 2661165.1)

Last updated on APRIL 30, 2020

Applies to:

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

Symptoms

Upgrade to LSH 2.5


ISSUE
=======
During the application of the Patch 28529507, hit the following error "ORA-20010: Error in cdr25compidx.sql Index create script at :DME_DISC_WORKTABLIST".


DETAILS OF THE ERROR
================


1. Per adpatch.log:

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Apr 17 2020 16:23:29
APPL_TOP is set to <Path>
Done reading jobs from FND_INSTALL_PROCESSES table ...
...
Completed: file dmw247dropindex.sql on worker 2 for product cdr username CDR.
  FAILED: file cdr25predropidx.sql on worker 1 for product cdr username CDR.
 Deferred: file cdr25predropidx.sql on worker 1 for product cdr username CDR. (Deferment number 1 for this job)
...
 Deferred: file cdr25predropidx.sql on worker 1 for product cdr username CDR. (Deferment number 2 for this job)
 Assigned: file cdr25predropidx.sql on worker 1 for product cdr username CDR.
  FAILED: file cdr25predropidx.sql on worker 1 for product cdr username CDR.

ATTENTION: All workers either have failed or are waiting:
  FAILED: file cdr25predropidx.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

2. Per adwork001.log:

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Apr 17 2020 16:23:29

Time when worker failed: Fri Apr 17 2020 16:23:38
Time when worker started job: Fri Apr 17 2020 16:23:38

Start time for file is: Fri Apr 17 2020 16:23:38

sqlplus -s APPS/***** <Path>/cdr25predropidx.sql &un_fnd &un_apps
Connected.
DECLARE
*
ERROR at line 1:
ORA-20010: Error in cdr25compidx.sql Index create script at :DME_DISC_WORKTABLIST. Error: ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-06512: at line 3168

Time when worker failed: Fri Apr 17 2020 16:23:38



Changes

 Patch application to upgrade to LSH 2.5

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
Changes
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.