User 05d9866f9b
30-05-2013 15:45:41
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.