Service Request: ODCIINDEXINSERT or ODCIINDEXCREATE Error ORA-29875 When Saving Service Request (Doc ID 465997.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Teleservice - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 06-Dec-2013***
CSXSRISR.fmb


Symptoms

(R) Customer Support
(N) Service Requests -> Create Service Requests

When trying to save the Service Request there is an error:

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-10602: failed to queue DML change to column for in Package CS_ServiceRequest_PVT Procedure
Create_ServiceRequest

According to Note 373363.1 - Error "ORA-29875: Failed In The Execution Of The Odciindexinsert
Routine", tried to apply Patch 5005469, but the patch failed.

Also, concurrent program 'Service Request: Synchronize Text Index' failed in error:

Sync_Text_Index: CS_INCIDENTS_ALL_TL_N1 :
Execution failed due to unexpected error.
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drixmd.PurgeKGL
ORA-20000: Oracle Text error:
DRG-13201: KOREAN_LEXER is desupported
ORA-30576: ConText Option dictionary loading error
DRG-50610: internal error: kglpurge []

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