Create index problem

User a0ee4512d1

12-10-2005 20:13:18

Hi,





I am totally new to jchem data cartridge for oracle.





We have oracle 9i running on redhat linux. Today, I performed the setup according to www.chemaxon.com's document. When I tried to create index using the documented syntax, I got errors like:











create index jc_idx on hts.molecules(smiles) indextype is jchem.jc_idxtype


*


ERROR at line 1:


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine


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


java.lang.RuntimeException: The following exception has been thrown by the


servlet:


Exception: null


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 17





Any help will be greatly appreciated.





Thanks,





Yuhong Wang





wangyuh _at_ mail.nih.gov

ChemAxon aa7c50abf8

14-10-2005 15:08:33

You probably got a NULL or empty SMILES. Please, upgrade to JChem 3.1.1.





Peter