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 laterInformation 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 |