problems with update/jcevaluate

Dear ChemAxon,

 

I am using jchem cartridge on CentOS6.7 64bit with oracle11gr2.

EVERYTIME I restart the jcartridge server, when I try to update a table with calculated value AT FIRST, I get an error.

 

SQL>

update compound_record r

set   cd_logp         = (select jc_evaluate( cd_structure, 'logp()' ) logp from compound c where r.corp_id = c.corp_id)

  3  where corp_id = 10;

update compound_record r

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kdddgb:clsviol_kcbgcur_9], [0],

[4194971], [1], [4294967250], [2], [], [], [], [], [], []

ORA-06512: at "JCHEM.JCHEM_DEFRIGHT_PKG", line 6

ORA-06512: at "JCHEM.EXEC_FUNCB", line 16

ORA-06512: at "JCHEM.EVALUATE_FUNCB", line 7

SQL>

update compound_record r

set   cd_logp         = (select jc_evaluate( cd_structure, 'logp()' ) logp from compound c where r.corp_id = c.corp_id)

  3  where corp_id = 10;

update compound_record r

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kdddgb:clsviol_kcbgcur_9], [0],

[4194971], [1], [4294967250], [2], [], [], [], [], [], []

ORA-06512: at "JCHEM.JCHEM_DEFRIGHT_PKG", line 6

ORA-06512: at "JCHEM.EXEC_FUNCB", line 16

ORA-06512: at "JCHEM.EVALUATE_FUNCB", line 7

 

and so on...

 

 

 

But, AFTER I select/calculate the property, it works fine.

 

SQL> select jc_evaluate( cd_structure, 'logp()' ) logp from compound c where corp_id  = 10;

.425828461

SQL> update compound_record r

set   cd_logp         = (select jc_evaluate( cd_structure, 'logp()' ) logp from compound c where r.corp_id = c.corp_id)

  3  where corp_id = 10;

1 row updated.

 

This proble may be related to my previous post :

problem in repetitive calculate/update (https://www.chemaxon.com/forum/ftopic14362.html&sid=e64cd99583ebf630261460249e2e6791)

 

 

Can you please help me to solve this problem?

 

Best regards,

Chong Hak Chae

 

 

 

 

 

 

;---------------------------------------------------------------------------------

; Here is my environment

;

INFO: JDBC driver version: 11.2.0.3.0

Oracle environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

 

JChem owner: JCHEM

 

JChem Server environment:

Java VM vendor: Oracle Corporation

Java version: 1.8.0_65

Java VM version: 25.65-b01

JChem version: 16.2.8.0

JChem index version: 15112300

JDBC driver version: 11.2.0.3.0

JChem Server start directory: /home/chemaxon/jchem-16.2.8.0/cartridge

Maximum memory: 3 GB

JChem Server host:port : localhost:1099

 

Dear Chong Hak Chae,

This ORA error really seems to be the same as the one in your former forum post.

Unfortunately, we still cannot solve the problem, only recommend to contact Oracle support with the bug report.

Best regards,

Krisztina

kvajda wrote:

Dear Chong Hak Chae, This ORA error really seems to be the same as the one in your former forum post. Unfortunately, we still cannot solve the problem, only recommend to contact Oracle support with the bug report. Best regards, Krisztina

Dear Krisztina,

Thank you for your quick reply.

I will have to try later version of Oracles.

Regards,

Dear Krisztina, thank you for your effort on this problem.

As you have suggested, I tried the same update/jc_evaluate operation on later version of oracle, but I got the same error  : CentOS7 64-bit, oracle12c, with jchem-16.2.8.0

 

Can you please verify whether this problem is due to oracle or jchem?

Thank you.

Regards,

Chong Hak Chae,

 

 

 

<System Restart....>

SQL> select jchem_core_pkg.getenvironment() from dual;

Oracle environment:

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

PL/SQL Release 12.1.0.2.0 - Production

CORE    12.1.0.2.0      Production

TNS for Linux: Version 12.1.0.2.0 - Production

NLSRTL Version 12.1.0.2.0 - Production

JChem owner: JCHEM

JChem Server environment:

Java VM vendor: Oracle Corporation

Java version: 1.8.0_65

Java VM version: 25.65-b01

JChem version: 16.2.8.0

JChem index version: 15112300

JDBC driver version: 11.2.0.3.0

JChem Server start directory: /home/chemaxon/jchem-16.2.8.0/cartridge

Maximum memory: 7 GB

JChem Server host:port : localhost:1099

SQL>

update compound_record r

set   cd_logp         = (select ( jc_evaluate( cd_structure, 'logp()' ) ) logp from kcbdb c where c.corp_id = r.corp_id)

  3  where r.corp_id between 1 and 100;

update compound_record r

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [ktsfbget:clsviol_kcbgcur_9], [0], [4279468], [1],

[4294967250], [2], [], [], [], [], [], []

ORA-06512: at "JCHEM.JCHEM_BLOB_PKG", line 26

ORA-06512: at "JCHEM.EXEC_FUNCB", line 30

ORA-06512: at "JCHEM.EVALUATE_FUNCB", line 7

SQL> select jc_evaluate( cd_structure, 'logp()' ) logp from kcbdb where corp_id  between 1 and 100;

2.19198861

2.83815043

 3.1072599

-.08452284

...

.459476284

4.49165747

 .76175043

100 rows selected.

SQL>

update compound_record r

set   cd_logp         = (select ( jc_evaluate( cd_structure, 'logp()' ) ) logp from kcbdb c where c.corp_id = r.corp_id)

  3  where r.corp_id between 1 and 100;

100 rows updated.

Dear Chong Hak Chae,

Unfortunately, the error is still an Oracle internal error: ORA-00600. JChem Oracle Cartridge cannot handle such type of errors. If you google for this error, you may find pages where reporting the error to Oracle Support Services is recommended. See here an example.

Best regards,

Krisztina

Dear Krisztina,

Thank you for the reply. 

So I have to wait oracle to solve this problem.

Thank you.

Best wishes,

Chong Hak Chae