My Oracle Support Banner

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

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Teleservice - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


(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

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 []


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
 Community Discussions

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