My Oracle Support Banner

Custom Index Re-Creating Every Time When Performing Migration from Source to Target and Failing with ERROR: ORA-00054 (Doc ID 2698786.1)

Last updated on AUGUST 11, 2020

Applies to:

Siebel CRM - Version 18.12 and later
Information in this document applies to any platform.

Symptoms

On : 18.12 version, System Admin

Schema Error for Siebel Migration

Migration process - Async


During migration process, when there is schema changes, majority of times, it fails while updating index CX_VSINTE1. This is index on custom table which is heavily used in our integration. We confirmed that DB team does not make any modifications to index after the migration is done.
Also there is no changes to the index for which the error is thrown.

Please let us know why migration process fails on index even though we have neither modified the index in Siebel tools nor on Database side.


ERROR
-----------------------

“alter index CX_VSINTE1 noparallel logging
2020-05-16 02:24:34 [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

2020-05-16 02:24:34
2020-05-16 02:24:34 S1000: [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
2020-05-16 02:24:34
2020-05-16 02:24:34 Dropping index with the same column signature and retrying...
2020-05-16 02:24:34 alter index CX_VSINTE1 noparallel logging
2020-05-16 02:24:34
2020-05-16 02:24:34 ;
2020-05-16 02:24:34 SQL Statement:
drop index CX_VSINTE1
2020-05-16 02:24:34 [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

2020-05-16 02:24:34
2020-05-16 02:24:34 S1000: [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
2020-05-16 02:24:34
2020-05-16 02:24:34 drop index CX_VSINTE1
2020-05-16 02:24:34
2020-05-16 02:24:34 ;
2020-05-16 02:24:34 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2020-05-16 02:24:34 writeExecDDL error (pOperCallback UTLDbDdlOperIndDrop).
2020-05-16 02:24:34 Error in MainFunction (UTLDbDdlDbMerge).”

Changes

 

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
References


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