Error when searching for fragments using jc_compare

Hi,





One of our systems is creating a dynamic query to search for fragments. This is the SQL which is produced:

Code:

select v.Parent_ID from eoaiacd.version v                     where jc_compare(v.ISOSMILES, '*',                                 'sep=~ t:s ~ctFilter:(match(''Brc2[c][c,n][c][c][c]2''))&&!match(''Brc1ccccc1'')') = 1

and this is the error message returned when this sql is run:

Code:

ORA-29902: error in executing ODCIIndexStart() routine ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: The following exception has been thrown by the servlet: Exception: null ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0 ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 324 ORA-06512: at line 1

The query takes about 1 minute before returning this error message.


Any help appreciated.





Thanks


Paul

Hi Paul,





Could you send the Java stack trace from the log file?





Thanks,


Szabolcs