error creating domain index / no error table

Hi,

We do have a problem creating the domain index

Our environment:

Java version: 1.6.0_27
Java VM version: 20.2-b06
JChem version: 5.12.4
JChem Index version: 5120000
JDBC driver version: 11.1.0.7.0-Production

The colleague that experienced the problem wrote:
I was able to create an index with a few structures in my table. However, some of the structures prevent the index creation and more importantly do not log any errors in my error table. Index creation command is just running and nothing happens. The longest the command ran unsuccessfully without termination was ~4+ hours..

The statements he executed:
exec jchem_core_pkg.use_password(.......');

CREATE INDEX indexname ON tablename(molcolumnname)

INDEXTYPE IS JCHEM.JC_IDXTYPE

PARAMETERS('structureType=anyStructures,duplicateFiltering=n,haltOnError=nf,errorTableName=jc_xxx_error_table')
NOPARALLEL; --ran from schema and this is where the error occurs

 

Thanks for your support.

Hi Edith,

If this is just a couple structures, can you provide them to us (via e-mail eventually addressed to pkovacs at chemaxon dot com)?

Peter

Thanks

I created a field  for the structure ID : Stru_ID and when a structure is inserted, it is also incremented by 2?

In the script of sequence for stru_id , I put only increment by 1.

That's very strange...

 

 

hiba

Hi Hiba,

 

In cartridge we execute row insertion in two steps (insert and update). Do you fire your trigger on both actions, or just on insert? Can you share your trigger with us? In case it would contain some confidential data, you might want to send us via e-mail to jcb-support at chemaxon.com

 

Norbert