Knowledge Management / Service Request Index Syncrhonization: Error ORA-00054: resource busy and acquire with NOWAIT (Doc ID 1066748.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Knowledge Management - Version 11.5.10.2 and later
Oracle Teleservice - Version 11.5.10.2 and later
Information in this document applies to any platform.
CS_SR_SYNC_TEXT_INDEX

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms