User bb0bf41f20
16-02-2012 15:31:40
Hi there,
We are experiencing a problem using JChem 5.5.1 for highlighting superstructure and similarity searches. This problem is not seen when using JChem 5.2.6.
Here is what we are trying to run:
update REQUEST_STRUCTURES_4204 t
set vdb_image = (select jcf.molconvertb(b, 'jpeg:w120,setcolors')
from table(jcf.hitColorAndAlign(t.db_name, t.structure_table, 'structure',
'
Marvin 02161213422D
21 23 0 0 0 0 999 V2000
0.0000 -1.6500 0.0000 O 0 0 0 0 0 0 0 0 0 0 0 0
0.7145 -1.2375 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
0.7145 -0.4125 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
1.4289 0.0000 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
1.4289 0.8250 0.0000 O 0 0 0 0 0 0 0 0 0 0 0 0
2.1434 -0.4125 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
2.8579 0.0000 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
3.5724 -0.4125 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
4.2868 0.0000 0.0000 O 0 0 0 0 0 0 0 0 0 0 0 0
3.5724 -1.2375 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
2.8579 -1.6500 0.0000 O 0 3 0 0 0 0 0 0 0 0 0 0
2.1434 -1.2375 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
1.4289 -1.6500 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
4.2868 -1.6500 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
5.0013 -1.2375 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
5.7158 -1.6500 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
5.7158 -2.4750 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
6.4302 -2.8875 0.0000 O 0 0 0 0 0 0 0 0 0 0 0 0
5.0013 -2.8875 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
5.0013 -3.7125 0.0000 O 0 0 0 0 0 0 0 0 0 0 0 0
4.2868 -2.4750 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
1 2 1 0 0 0 0
2 3 4 0 0 0 0
3 4 4 0 0 0 0
4 5 1 0 0 0 0
4 6 4 0 0 0 0
6 7 4 0 0 0 0
7 8 4 0 0 0 0
8 9 1 0 0 0 0
8 10 4 0 0 0 0
10 11 4 0 0 0 0
11 12 4 0 0 0 0
6 12 4 0 0 0 0
12 13 4 0 0 0 0
2 13 4 0 0 0 0
10 14 1 0 0 0 0
14 15 4 0 0 0 0
15 16 4 0 0 0 0
16 17 4 0 0 0 0
17 18 1 0 0 0 0
17 19 4 0 0 0 0
19 20 1 0 0 0 0
19 21 4 0 0 0 0
14 21 4 0 0 0 0
M CHG 1 11 1
M END
',
ora_rowid,
't:u', 'alignmentMode:off coloring:y hitColor:cyan'))),
vdb_highlighted = 1
where vdb_highlighted = 0
raises :
ORA-29532: Java call terminated by uncaught Java exception: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException
Running the SQL in SQL Developer gives a bit more info :
SQL Error: ORA-29532: Java call terminated by uncaught Java exception: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
chemaxon.jchem.cartridge.rmi.StructureFormatException: Cannot recognize format (?)
Unrecognized file contents:
Marvin 02161213562D
21 23 0 0 0 0 999 V2000
0.0000 -1.6500 0.0000 O 0 0 0 0 0 0 0 0 0 0 0 0
0.7145 -1.2375 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 0
0.7145 -0.4125 0.0000 C ...
...
ORA-06512: at "JCHEM.JCHEM_CLOB_PKG", line 63
ORA-06512: at "JCHEM.JCF", line 387
Any information on this issue would be appreciated
Thanks