molecule search problems

I have a table with sample_id and smiles_iso. The smiles_iso is indexed using the cartridge 5.1.

When I tried to do the following query from different user, I got the following errors. 

The platform is redhat 64 bit linux.

Thanks very much in advance.

Yuhong Wang

 

select count(sample_id) from registry.ncgc_sample where jchem.jc_compare(smiles_iso,'Oc1ccccc1O',null)=1
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.ExceptionInInitializerError
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 48
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 344
ORA-06512: at line 1

Hi Yuhong Wang,

As a bug manifesting the same symptom has been fixed in JChem 5.1.2, upgrading from 5.1 to a recent JChem version is definitely recommended.

If the problem persists after upgrading, you may want to re-check the relevant part of the documentation: http://www.chemaxon.com/jchem/doc/admin/cartridge.html#users, in particular the subsections JChem Cartridge "super user" configured in JChem Server and/or JChem Server uses initiators' identities depending on your requirements.

Let me know if this doesn't help.

Peter