Cannot create an image based on molstring

User 9563be2caf

17-10-2013 23:02:07

Hi,


I cannot create an image from molstring using trigger. It was working OK until a few days ago and stopped.


I am using the following command in Oracle trigger:


select jc_molconvertb(:new.molstring, 'png:w500') into :new.compound_image from dual;


I have tried jcf.molconvertb but no luck. Please advise.


Thank you.

ChemAxon 61b4fee994

18-10-2013 06:05:34

Hi,


Can you send us the error message you receive? And can you send us a short example code which doesn't work for you?


And we also need result of the select jchem_core_pkg.getenvironment() from dual; call.


Thank you,


Tamas

User 9563be2caf

18-10-2013 14:26:41

Hi Tamas,


Here is the result from the environment:


"Oracle environment:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production


JChem owner: JCHEM


JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_27
Java VM version: 20.2-b06
JChem version: 6.0.0
JChem Index version: 6000000
JDBC driver version: 11.1.0.7.0-Production
"


The code that I pasted before from the trigger(select jc_molconvertb(:new.molstring, 'png:w500') into :new.compound_image from dual;) is the code that does not work. The rest of the code works and is not relevant to JChem but setting id's for the data record. I am not getting any errors (on a screen at least) but the blob content for the image is null. Molstring data is in place and valid.


 Is there a log file for JChem cartridge?


Plaese advise. Thank you.


Iosif

ChemAxon 61b4fee994

21-10-2013 08:36:41

Hi,


My first guess is that your trigger can be invalid. It may be possible that your trigger is not valid for some reason. If the problem is with the jc_compareb function, it shows that some grants are missing from the db. In that case, I suggest running the following command as system or the JChem owner:


call <jchem_owner>.privman_pkg.grants_on_jcobjs(<jchem_owner>, <jchem_user>);


And than don't forget to revalidate the trigger.


Let me know, if it doesn't help.


Regards,


Tamas

User 9563be2caf

23-10-2013 15:38:05

Hi Tamas,


The issue was related to JChem server itself. Had to restart it and it fixed the issue. I do not know what happened with JChem cartridge server. No errors or other messages. Will keep monitoring it.


Thank you for your help.


Regards,


Iosif