Knowledge Management / Service Request Index Syncrhonization: Error ORA-00054: resource busy and acquire with NOWAIT

Last updated on MARCH 06, 2018

Applies to:

Symptoms

When attempting to run a Concurrent Request for Index Synchronization (i.e. Knowledge Management Solution, Service Request), the following error occurs:

Error:

Sync_Set_Index: Execution failed due to unexpected error. ORA-00054: resource busy and acquire with NOWAIT specified
-or-
Drop_Index: Execution failed due to unexpected error. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Steps:

(R) System Administrator
(N) Requests > Run

- Run the concurrent request 'Knowledge Management: Solution Index Synchronization'
  or
- Run the concurrent request 'Service Request: Synchronize Text Index Program'

Business Impact:

- The users can not publish any new entries to the Knowledge Base.
- The users cannot search Service Requests by Summary
- The users might not be able to create Service Requests, encountering the followin errors:

ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods,ODCIIndexInsert
ORA-20000: Oracle Text error:
DRG-10607: index meta data is not ready yet for queuin in Package CS_ServiceRequest_PVT Procedure Create_ServiceRequest

Changes

 New installation or Upgrade.

Cause