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!
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!