jcman and exception

Hi,





I start to upgrade jchem from 3.1.2 (pre2) to 3.1.4 using jcman to upgrade database tables. This is exception thrown out (see the error message). How can I fix this?





For additional information: I can still ignore the message and upgrade the structure table. But once the upgrade is done, I try to search the table with a perfect search, a similar error message appears again. So I concluded that there is must something I have to add into database.





Ben Li





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


java.sql.SQLException: ORA-00942: table or view does not exist


at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)


at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)


at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)


at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)


at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:


831)


at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav


a:2496)


at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme


nt.java:2840)


at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:


623)


at chemaxon.jchem.db.TableInfo.containsHashColumn(TableInfo.java:1157)


at chemaxon.jchem.db.Updater.getTablesWithNoHashColumn(Updater.java:110)


at chemaxon.jchem.gui.Connector.addHashCodeColumnIfNeeded(Connector.java


:183)


at chemaxon.jchem.gui.Connector.go(Connector.java:95)


at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:561)


at chemaxon.jchem.JChemManager.init(JChemManager.java:89)


at chemaxon.jchem.JChemManager.main(JChemManager.java:106)


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

I found the answer.





It was because I have another old_structure table in oracle, but the table has been dropped through SQL without proper modification in JChemProperties table.





Good to know anyway.





Ben Li

Hi,





I think that you have inconsistent data in the property table (because some jchem tables were deleted by hand - this is something you should never do).


This error may also prevent the creation of some log tables, which are needed during the search.





Please read the following topic about the same problem, and let me know if it helps:





http://www.chemaxon.com/forum/ftopic943.html





Best regards,





Szilard

Yes, that was exaclty the thing I suspected.





I'm glad your problem has been solved.





Kind regards,





Szilard