Cannot create an image based on molstring

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.

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

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

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

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