JChem Cartridge search fails on read-only database

ChemAxon aa7c50abf8

13-04-2006 20:25:57

Quote:

We are migrating our database server, so we made the old Oracle server read-only and expected people to still be able to do structure searching, but it turned out not to be the case

SQL> SELECT cpd_sid FROM cpd WHERE jc_compare(jc_smiles, query,'t:s queryType:1')=1;

SELECT cpd_sid FROM cpd WHERE jc_compare(jc_smiles, query,'t:s queryType:l')=1

*

ERROR at line 1:

ORA-29902: error in executing ODCIIndexStart() routine

ORA-16000: database open for read-only access

ORA-06512: at "JCHEM_CARTRIDGE.JCHEM_CORE_PKG", line 264

ORA-06512: at "JCHEM_CARTRIDGE.JC_IDXTYPE_IM", line 304

ORA-06512: at line 1

JChem Cartridge currently uses a sequence to generate unique internal identifiers to distingish between domain index scans of the same SQL statement. (Such an identifier is generated for each domain index scan even if it is the only one needed for a given SQL statement.) The error occurs as the sequence is being accessed (and incremented).