Could not retrieve schema for database error

Hi,

I am connecting from JChem for Excel to an Oracle database, but when I connect I get the error message:

Exception: ChemAxon.JChemExcel.Base.Exceptions.AccumulatedException

Message: An item with the same key has already been added.

StackTrace: at ChemAxon.JChemExcel.Data.Oracle.AbstractOracleSchemaProvider.FillSchema()

at ChemAxon.JChemExcel.Base.Search.DatabaseSchemaModel.FillSchema(ConnectionInfoDatabasePair cidp)

at ChemAxon.JChemExcel.Search.DatabaseTree.DatabaseTreePresenter.FillSchema(ConnectionInfoDatabasePair cidp)

I can then search the database in any one table, but cannot make any releational searches - the other tables have foreign key releationships, but I cannot link to them because the schema wasn't retrieved - it the problem with my database or JChem for Excel?

Thanks

Bob

 

 

 

Hi Bob,

we will investagate. This error comes, if a schema item with the same name is retrieved again. Normally this should not happen.

We will make a new patch release of 5.3.3 soon, there I will make this error message more informative. Please do not download 5.3.3 yet, since it contains an error. I will inform you when the patched version is available.

Best regards,

Tamas.

 

 

 

 

Thanks Tamas