error during CREATE INDEX JC_IDX ON SUB_STRUCTURE

User 247a2c5018

01-10-2013 13:19:23

Hello,


 


I have this following error :


 


SQL> CREATE INDEX JC_IDX ON SUB_STRUCTURE ("CD_STRUCTURE") INDEXTYPE IS JC_IDXTYPE;


CREATE INDEX JC_IDX ON SUB_STRUCTURE ("CD_STRUCTURE") INDEXTYPE IS JC_IDXTYPE


*


ERREUR a la ligne 1 :


ORA-29855: erreur d'execution de la routine ODCIINDEXCREATE


ORA-29532: appel Java arrete par une exception Java non interceptee :


java.lang.RuntimeException: Table 'SYSADMIN.SUB_STRUCTURE' contains newer data


version that this program version can handle. Please use a later version of


JChem.


ORA-06512: a "SYSADMIN.JCHEM_CORE_PKG", ligne 105


ORA-06512: a "SYSADMIN.JC_IDXTYPE_IM", ligne 20



thanks


ChemAxon aa7c50abf8

01-10-2013 13:23:06

Hello,


Your JChem Base table has been upgraded to a JChem version newer than your JChem Cartridge version. You have to upgrade your JChem Cartridge version to that newer version.


Peter

User 247a2c5018

01-10-2013 13:55:56

yes Thanks


Jchem Manager release : 6.1


Jchem cartridge : 6.0.1

User 247a2c5018

01-10-2013 14:01:25

after running  ./config-util.sh config-index-user for CNFUSION user, i have this error : 


 


select count(*) from SYSADMIN.SUB_STRUCTURE where SYSADMIN.jc_compare(CD_STRUCTURE, 'CN1CC[C@@]23[C@H]4OC5=C2C(C[C@@H]1[C@@H]3C=C[C@@H]4O)=CC=C5O', 't:s') = 1;


select count(*) from SYSADMIN.SUB_STRUCTURE where SYSADMIN.jc_compare(CD_STRUCTURE, 'CN1CC[C@@]23[C@H]4OC5=C2C(C[C@@H]1[C@@H]3C=C[C@@H]4O)=CC=C5O', 't:s') = 1


*


ERREUR a la ligne 1 :


ORA-29902: erreur d'execution de la routine ODCIIndexStart()


ORA-29532: appel Java arrete par une exception Java non interceptee :


java.rmi.ServerException: RemoteException occurred in server thread; nested


exception is:


java.rmi.RemoteException: java.lang.RuntimeException: No valid license for


JChem Cartridge


ORA-06512: a "SYSADMIN.JCHEM_CLOB_PKG", ligne 81


ORA-06512: a "SYSADMIN.JC_IDXTYPE_IM", ligne 310



ChemAxon aa7c50abf8

01-10-2013 14:07:04

Did you follow this: http://www.chemaxon.com/jchem/doc/admin/cartridge.html#regkey ?


Peter

User 247a2c5018

01-10-2013 14:41:11

Ok thanks

User 1b56d1eb85

21-10-2013 10:29:42

I'm also having an error, until I followed this http://www.chemaxon.com/jchem/doc/admin/cartridge.html#regkey