Problems importing with structural keys

Hi! Hopefully this is not a silly question - I've searched through the forum and haven't been able to find an answer to this, so maybe I'm just doing something weird...

I have no problems importing a .smi file into a table as long as I don't use structural keys. However, once I create a table with structural keys, every time I try to import I get the same error:

 

chemaxon.jchem.db.TransferExecption: ERROR: field "CD_FP20" is not present in table "public.mol2".

Caused by:

ERROR: field "CD_FP20" is no present in table "public.mol2".

 

I've tried adding in extra rows during creation in an attempt to avoid this, but it still errors at one past the end of the row list. I'm running the most recent JChemBase on a PostgreSQL database.

Hi,

This seems to be a bug, thank you for reporting it.

We will investigate this and let you know when the fix is available.

 

Best regards,

Szilard

Hi,

we have found the bug and fixed it.  Cause of the problem was a wrong value in the property table.

You can fix it if you change the vaule of the 'table.<tablename>.fingerprint.numberOfStrucFPCols' key to 1. The exisring number is the number of the keys. From the next version of JChem the specified property will be created correctly.

Sorry fo this inconvenience.

Regards, Edvard