1 Reply Latest reply on Nov 26, 2013 6:31 PM by Debbie Curtis-Magley

    We are facing Oracle text index sync issue (i.e., ORA-7445, ORA-29903)  while we are searching a contract in contract tab in 9r1

    Ravikanth Atmakuri Newbie

      Please give me advise here. Oracle DBA team indicated that Oracle Text seems to be configured correctly on our database and all objects owned by CTXSYS are valid. This is because the problems seem to be pointing to the BLOB tab indexes and CTXSYS objects. See below for more error text. Exception: ORA-29903: error in executing ODCIIndexFetch() routine ORA-20000: Oracle Text error: DRG-50857: oracle error in dretbase ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "CTXSYS.DRIXMD", line 1234 ORA-01013: user requested cancel of current operation ORA-06512: at "CTXSYS.DRVXMD", line 190 ORA-06512: at line 1 Please help me how to dig further in Ariba side.

       

      Ariba Version : 9r1

      Oracle Database Version : 11.2.0.3

       

      Message was edited by: Ravikanth Atmakuri