Hello again,
I'd like to resurrect this thread if possible. I am getting the error described above again and have tracked down the errors but am not getting any clues as to why 3 structures can't be indexed :
17-Nov-2009 12:19:54 chemaxon.jchem.cartridge.servlets.indexing.structhandlers.CalculateInsertHandler handleException
SEVERE: Problem indexing structure with ROWID AABYVmAAEAAD5p2AAF: 0
17-Nov-2009 12:20:01 chemaxon.jchem.cartridge.servlets.indexing.structhandlers.CalculateInsertHandler handleException
SEVERE: Problem indexing structure with ROWID AABYVmAAEAAD6WBAAB: 0
17-Nov-2009 12:20:01 chemaxon.jchem.cartridge.servlets.indexing.structhandlers.CalculateInsertHandler handleException
SEVERE: Problem indexing structure with ROWID AABYVmAAEAAD6WBAAC: 0
Just a fairly generic "Problem indexing structure" message.
Is there a way I can 'pre-check' to see if a structure can indexed before issuing the create index statement. Even though I have set haltOnError=n the create index still fails and is left in an unusable state requiring intervention to get it working again.
Many thanks,
Steve H
JCHEM.JCHEM_CORE_PKG.GETENVIRONMENT()
---------------------------------------------------------------------
Oracle environment:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_13
Java VM version: 11.3-b02
JChem version: 5.2.0
JChem Index version: 5020005
JDBC driver version: 11.1.0.7.0-Production