User 2082812c83
15-01-2007 19:30:39
Hi,
I am trying to upgrade some JChem Base structure tables in a PostgreSQL 8.1 database from JChem Base version 3.1.1 to version JChem Base version 3.2.3. When I run jcman it correctly detects the tables that need to be regenerated but when I elect to proceed with regeneration I get the following exception:
C:\jchem3.2.3\bin>.\jcman
java.sql.SQLException: The table public.test_structure doesn't exist or size of fingerprint is not properly set in property table "JChemProperties".
at chemaxon.jchem.db.FingerprintHandler.getNumberOfBits(FingerprintHandler.java:47)
at chemaxon.jchem.db.UpdateHandler.initFields(UpdateHandler.java:523)
at chemaxon.jchem.db.UpdateHandler.<init>(UpdateHandler.java:448)
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:66)
java.sql.SQLException: The table public.test_structure doesn't exist or size of fingerprint is not properly set in property table "JChemProperties".
at chemaxon.jchem.db.FingerprintHandler.getNumberOfBits(FingerprintHandler.java:47)
at chemaxon.jchem.db.UpdateHandler.initFields(UpdateHandler.java:523)
at chemaxon.jchem.db.UpdateHandler.<init>(UpdateHandler.java:448)
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:66)
java.lang.NullPointerException
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:93)
java.lang.NullPointerException
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:93)
I have double checked that:
1. The user I am using to log into the database through jcman owns all of the structure tables, structure_ul tables jchemproperties table and corresponding sequences.
2. That when I manually log into the datbabase as that same user I can access the tables and sequences in question.
Any idea what is causing this exception and how I can work around it?
Thanks,
James
I am trying to upgrade some JChem Base structure tables in a PostgreSQL 8.1 database from JChem Base version 3.1.1 to version JChem Base version 3.2.3. When I run jcman it correctly detects the tables that need to be regenerated but when I elect to proceed with regeneration I get the following exception:
C:\jchem3.2.3\bin>.\jcman
java.sql.SQLException: The table public.test_structure doesn't exist or size of fingerprint is not properly set in property table "JChemProperties".
at chemaxon.jchem.db.FingerprintHandler.getNumberOfBits(FingerprintHandler.java:47)
at chemaxon.jchem.db.UpdateHandler.initFields(UpdateHandler.java:523)
at chemaxon.jchem.db.UpdateHandler.<init>(UpdateHandler.java:448)
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:66)
java.sql.SQLException: The table public.test_structure doesn't exist or size of fingerprint is not properly set in property table "JChemProperties".
at chemaxon.jchem.db.FingerprintHandler.getNumberOfBits(FingerprintHandler.java:47)
at chemaxon.jchem.db.UpdateHandler.initFields(UpdateHandler.java:523)
at chemaxon.jchem.db.UpdateHandler.<init>(UpdateHandler.java:448)
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:66)
java.lang.NullPointerException
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:93)
java.lang.NullPointerException
at chemaxon.jchem.db.Regenerator$RegenThread.run(Regenerator.java:93)
I have double checked that:
1. The user I am using to log into the database through jcman owns all of the structure tables, structure_ul tables jchemproperties table and corresponding sequences.
2. That when I manually log into the datbabase as that same user I can access the tables and sequences in question.
Any idea what is causing this exception and how I can work around it?
Thanks,
James