ORA-29876 DRG-50857 Oracle Index Errors in Portal after upgrade the database to 11.2.0.4.0 (Doc ID 1627444.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version 10.1.4.0 to 11.1.1.7.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.

Symptoms

After upgrading database to 11.2.0.4, and installing the mandatory patches identified in Note:1608029.1 Oracle Text release 11.2.0.4.0 mandatory Patches. Get the following error:

internal error (WWC-00006)
An unexpected error occurred: User-Defined Exception. (WWV-00402)
Unexpected error - User-Defined Exception (WWC-35000)
Unexpected error - ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexDelete
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column for primary key
DRG-50857: oracle error in drsiubind
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "CTXSYS.DRIACC", line 182
ORA-06512: at "CTXSYS.DRIACC", line 835
ORA-06512: at "CTXSYS.DRVXMD", line 746
ORA-06512: at line 1
(WWC-35000)

The error appears doing any of the following actions:

 

Similar error also during import/export actions

 

Fail with error:
[13-MAR-14 04:27:32][Error: (WWU-74256)] context = (Fatal Error)WWUTL_API_IMPORT_PAGEGROUP.MergeTableForInsert user = OFM1_PORTAL An unknown fatal error has occurred during the import of transport set. See the debug logs for details.


Context: (Fatal Error)WWUTL_API_IMPORT_PAGEGROUP.MergeTableForInsert wwnls_api.add_string: wwnls_api.add_string: wwnls_api.add_string: wwnls_api.add_string: wwnls_api.add_string: wwnls_api.add_string:
Context: WWUTL_API_IMPORT_PAGEGROUP.MergeTableForInsert 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 primary key DRG-50857: oracle error in drsiubind ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "CTXSYS.DRIACC", line 182 ORA-06512: at "CTXSYS.DRIACC", line 835 ORA-06512: at "CTXSYS.DRVXMD", line 746 ORA-06512: at line 1

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