problem with jchem table after oracle import

ChemAxon 60ee1f1328

24-11-2006 11:59:07

ERROR at line 1:


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


java.lang.NumberFormatException: null


ORA-06512: at "CSPACE.JCHEM_TABLE_PKG", line 30


ORA-06512: at "CSPACE.JC_INSERT", line 8


ORA-06512: at line 4





Hi Peter,





I have migrated a jchem table and now it appears that I cannot complete jc_insert with error above, I guess it is not generating a cd_id...jchemproperties data was migrated also but directly after oracle level import I have not yet regenerated the table...trigger and sequence are in place...any suggestions? Cartridge is configured with correct password...





Daniel.

ChemAxon 60ee1f1328

24-11-2006 12:04:31

jchem3.2, oracle 10.2.0 on both w2003 and linux...

ChemAxon 60ee1f1328

24-11-2006 12:11:23

I guess I will try your new 3.2.1 fix then!!!


Can you confirm that I will need to regenerate the table after this upgrade?





Cheers,


Daniel.

ChemAxon aa7c50abf8

24-11-2006 12:15:50

Yes, please, regenerate.





Cheers,


Peter

ChemAxon 60ee1f1328

25-11-2006 09:19:25

declare


v_cd_id CD_ID_ARRAY := NULL;


begin


v_cd_id := Jc_Insert ('C','moleculesv3a','JCHEMPROPERTIES','false','false','');


commit;


end;


/





declare


*


ERROR at line 1:


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


oracle.jdbc.driver.OracleSQLException: ORA-02289: sequence does not exist


ORA-06512: at "CSPACE.JCHEM_TABLE_PKG", line 30


ORA-06512: at "CSPACE.JC_INSERT", line 8


ORA-06512: at line 4





The sequence associated with the table above definitely does exist and the associated trigger compiles OK - could this be a similar issue to the previous one for sequence rather than table? Please confirm, if so I need another patch asap please.





Thanks,





Daniel.

ChemAxon aa7c50abf8

25-11-2006 09:46:05

Please, could you post the corresponding Java stack trace from the Oracle session trace to be found in the "udump" directory?





Thanks


P.

ChemAxon 60ee1f1328

25-11-2006 10:02:13

thank you Peter...

ChemAxon aa7c50abf8

25-11-2006 10:31:14

The sequence which is not found called <index-table-name>_usq, where <index-table-name> is the name of the structure table itself in the case of JChem structure tables.





Does such a sequence exists?





This sequence is used when inserting into the update-log table which is called <index-table-name>_ul. Does this table exist?





P.

ChemAxon 60ee1f1328

25-11-2006 10:39:27

Thanks Peter - that seems to have done the trick - I did not port this sequence over!





Cheers + nice weekend,


Daniel.