Error searching foreign fingerprint

Hi

Searching on a foreign fingerprint in jchem cartridge gives an error

select count(*)
from foreign_fp
where jc_tanimoto(fp,'0000001100000110000111000000000000000000000000000100000000000000000000010000000000000000000000000010100000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000010000000000000000000000000000000000100000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000') >= 0.8;

ORA-29902: error in executing ODCIIndexStart() routine
ORA-29532: Java call terminated by uncaught Java exception: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
    java.rmi.RemoteException
ORA-06512: at "JCHEM.JCHEM_CLOB_PKG", line 99
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 246
ORA-06512: at line 1
29902. 00000 -  "error in executing ODCIIndexStart() routine"
*Cause:    The execution of ODCIIndexStart routine caused an error.
*Action:   Examine the error messages produced by the indextype code and
           take appropriate action.

 

This does not occur for all instances of the query string (e.g. if I use a string taken directly from the database).

This is cartridge version 5.4.1.2

Thanks

Stephen

Hi Stephen,

I couldn't reproduce the problem with a simple test case (involving a table populated with randomly generated fingerprints and the query fingerprint in your problem report).

Can you consistently reproduce the problem with this particular query fingerprint?

Would it be possible to provide either the Java error stack traces from the JChem Cartridge server's log files or better yet, the logfiles themselves? It would be extremely helpful. (You could send the logfiles to pkovacs at chemaxon dot com.)

Thanks

Peter

 

The log files show StackOverflowError occurring in chemaxon.util.FloatIntQuickSort. This is a known problem and will be fixed in JChem version 5.6.0.0.

Thanks and sorry for the inconvenience.

Peter