problem with jchem table after oracle import

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.

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

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.

Yes, please, regenerate.





Cheers,


Peter

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.

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





Thanks


P.

thank you Peter...

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.

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





Cheers + nice weekend,


Daniel.