error on jc_idx_property in JChem Cartridge installation

User 104a68add6

14-10-2005 15:35:34

I've installed the JChem Cartridge (JChem v3.1.1, Linux 7.3 & 8.0, Oracle 9i) on my development and production systems, and everything seems to be working fine. Structure searches, cartridge queries, the test.sh that comes with your installation...all of these return the desired results.





However, during each install.sh run, I got an error message at the very end. I see no erroneous behavior in the systems, but I want to make sure the installations are really OK.





The message is:





delete from jc_idx_property where prop_name like 'jchem.service.endPoint.url.%'


*


ERROR at line 1:


ORA-00942: table or view does not exist





Before the installation, the jc_idx_property table existed, and after the installation it still exists. It looks like that command is trying to clean up the table and put the correct entry in for the connection information (I cannot see the stored procedure that is executing the delete command - I think it is java stored procedure?). ...here is a listing of the table (sorry about the formatting):





PROP_NAME PROP_VALUE


---------------------------------- -----------------------------------------


jchem.service.endPoint.url.1 http://cti-disc-prod1:8081/jchemstreams/


JCHEM.JC_STRUCTURE_IDX.JChemProperties JCHEM.JChemProperties


JCHEM.JC_STRUCTURE_IDX.debuglevel 0





What did I miss during my installations?





Many thanks!

ChemAxon aa7c50abf8

17-10-2005 07:26:31

You can ignore this error message.





Peter