JChem [3.2.5] ORA-29902

User 8688ffe688

03-05-2007 17:43:50

Running Redhat linux and Oracle 10.2.0.1 64bit. We upgraded from 3.2.4 to 3.2.5 with no errors. Recreated JChem index, made some jc_evaluate calls and successful but any structure searching operators fail with the message below:





select id from structure where jc_contains(smiles,'C1=CC=CC=C1')=1


*


ERROR at line 1:


ORA-29902: error in executing ODCIIndexStart() routine


ORA-29532: Java call terminated by uncaught Java exception:


oracle.jdbc.driver.OracleSQLException: ORA-00903: invalid table name


ORA-06512: at "CHEMDB.JCHEM_CORE_PKG", line 36


ORA-06512: at "CHEMDB.JC_IDXTYPE_IM", line 146


ORA-06512: at line 1

ChemAxon aa7c50abf8

03-05-2007 20:08:14

Please, could you post the corresponding Java stack trace from the Oracle session trace in the "udump" directory?





Which database character set do you use?





Thanks


Peter

User 8688ffe688

04-05-2007 00:50:47

We found our mistake.