User 77bcbbb206
19-04-2005 19:55:10
Can anyone shed some light on the following trace for me? I have a client schema executing a jc_insert on a JCHEM schema on the same database instance with the web server on a different computer. I'm assuming it's some permissions issue, but I can't figure out what. I have attached the whole trace and have appended the last part to this post. Thanks in advance.
=====================
PARSING IN CURSOR #13 len=77 dep=1 uid=116 oct=3 lid=116 tim=1551892709271 hv=2281486051 ad='fe7feaa0'
select cd_id, cd_smiles from JCHEM_CARTRIDGE.RMS_STRUCTURE where cd_hash = :1
END OF STMT
PARSE #13:c=0,e=1290,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1551892709256
EXEC #13:c=0,e=1288,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1551892710814
FETCH #13:c=0,e=78,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1551892711336
java.lang.Exception: The following exception has been thrown by the servlet:
Exception: null
at chemaxon.jchem.cartridge.JFunctions.checkForException(JFunctions.java:2341)
at chemaxon.jchem.cartridge.JFunctions.sendAndRecBytes(JFunctions.java:2099)
at chemaxon.jchem.cartridge.JFunctions.sendBatchForSearch(JFunctions.java:1793)
at chemaxon.jchem.cartridge.JFunctions.insertSingleMol(JFunctions.java:3076)
at chemaxon.jchem.cartridge.JFunctions.insertMol(JFunctions.java:3019)
EXEC #1:c=1170000,e=1624826,p=1,cr=606,cu=0,mis=0,r=0,dep=0,og=4,tim=1551892738532
ERROR #1:err=29532 tim=158913816
STAT #8 id=1 cnt=5 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '
STAT #8 id=2 cnt=5 pid=1 pos=1 obj=36 op='INDEX UNIQUE SCAN OBJ#(36) '
STAT #10 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '
STAT #10 id=2 cnt=0 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN OBJ#(37) '
=====================
PARSING IN CURSOR #13 len=77 dep=1 uid=116 oct=3 lid=116 tim=1551892709271 hv=2281486051 ad='fe7feaa0'
select cd_id, cd_smiles from JCHEM_CARTRIDGE.RMS_STRUCTURE where cd_hash = :1
END OF STMT
PARSE #13:c=0,e=1290,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1551892709256
EXEC #13:c=0,e=1288,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1551892710814
FETCH #13:c=0,e=78,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1551892711336
java.lang.Exception: The following exception has been thrown by the servlet:
Exception: null
at chemaxon.jchem.cartridge.JFunctions.checkForException(JFunctions.java:2341)
at chemaxon.jchem.cartridge.JFunctions.sendAndRecBytes(JFunctions.java:2099)
at chemaxon.jchem.cartridge.JFunctions.sendBatchForSearch(JFunctions.java:1793)
at chemaxon.jchem.cartridge.JFunctions.insertSingleMol(JFunctions.java:3076)
at chemaxon.jchem.cartridge.JFunctions.insertMol(JFunctions.java:3019)
EXEC #1:c=1170000,e=1624826,p=1,cr=606,cu=0,mis=0,r=0,dep=0,og=4,tim=1551892738532
ERROR #1:err=29532 tim=158913816
STAT #8 id=1 cnt=5 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '
STAT #8 id=2 cnt=5 pid=1 pos=1 obj=36 op='INDEX UNIQUE SCAN OBJ#(36) '
STAT #10 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '
STAT #10 id=2 cnt=0 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN OBJ#(37) '