ORA-29540 error when searching in JChem Cartridge

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:

 

SELECT *

  FROM sps_chiral.molecules

WHERE jc_compare

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

           'c1ccccc1',

           '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

Moved to appropriate forum topic.

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).

Thanks,

Filip

Dong,
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.

Thx,
FZ