ORA-29540 error when searching in JChem Cartridge

User 55ffa2f197

11-07-2013 19:56:38

Hi Peter,

In the same schema (sps_chiral) we also had troubel to run following susbstructure search, as IJC and and got the same error doing search in IJC. But OK when running the search as sps_chiral in sqlplus. Does all this point to the same granting/permission issue as you pointed out:

SQL and error:



  FROM sps_chiral.molecules

WHERE jc_compare

          (TO_CLOB (sps_chiral.molecules."MOLECULE"),


           'sep=, earlyResults:10,usrOpId:507a9575-e0c2-4714-b422-5983eac85a4c'

          ) = 1



In IJC it gives an error

[1]: (Error): ORA-29902: error in executing ODCIIndexStart() routine ORA-29540: class chemaxon/jchem/cartridge/JFunctions does not exist ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 85 ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 360

ChemAxon aa7c50abf8

12-07-2013 08:43:10

Moved to appropriate forum topic.

ChemAxon 2bdd02d1e5

12-07-2013 09:40:44

Hi Dong,

It's hard to say what is wrong, could you please provide more complete IJC log file (you may want to send it by email, use my or usual IJC mail address).



ChemAxon 2bdd02d1e5

12-07-2013 11:02:02

please ensure that the SQL statement which is run from sqlplus is the same as the one produced by IJC. Also it has to be run with the same DB user. We would suspect that running it under different user with different permission could cause this error (just guessing for now). We will diagnose more from the log.