1. Home
  2. Support
Article - CS149138

ORA-29877 error when editing text fields in Integrity Lifecycle Manager / Windchill RV&S

Modified: 21-Sep-2021   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 10.3 to 12.5

Description

  • ORA-29877 error when editing text fields in Integrity Lifecycle Manager / Windchill RV&S
  • Trying to edit a text field causes error when saving:
    • MKS131372: An unhandled database exception has occurred.  Please contact your administrator.
        The error supplied by the database is:
          ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
        ORA-20000: Oracle Text error:
        DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
        ORA-20000: Oracle Text error:
        DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
        ORA-20000: Oracle Text error:
        DRG-10602: failed to queue DML change to column VALUE for primary key AAANf5AAGAABdNgAAC
        DRG-50857: oracle error in drekqkd(execute k_stmt)
        ORA-00942: table or view does not exist
  • Or 
    • MKS131372: An unhandled database exception has occurred.  Please contact your administrator.
        The error supplied by the database is:
          ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
        ORA-20000:
        DRG-50857:
        ORA-20000:
        DRG-50857:
        ORA-20000: Oracle Text error:initialization failed
        ORA-06512: at "CTXSYS.DRUE", line 160
        ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 979
This is a printer-friendly version of Article 149138 and may be out of date. For the latest version click CS149138