jc_evaluateb give ORA-06502

Hi,

when running
jc_evaluate or jc_evaluateb I get ORA-06502 (which was supposedly fixed in relase
3.1.7).  The problem appeared after we
had to make a disaster recovery of the database server.  At that moment we also moved to a later SuSE
OS and Oracle release.

 

Example:

select
jc_evaluate_x('OC(=O)c1c2ccccc2nc3ccccc13','chemTerms:logp') from dual;

 

runs ok, provides a
result.  But:

 

select
jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','logp()') from dual;

 

ORA-06502: PL/SQL: numeric or value error:
character to number conversion error

ORA-06512: at "JCHEM.EXEC_FUNCB",
row 18

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

 

The production code I
have been running but which now fails is:

 

select  jc_evaluateb(cd_structure,'logp()') 

from
bcpvs.JCSEPMOL_MOLTABLE ;

 

 

I rebuilt all indexes on the table but that did not help. 

 

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 Server environment:

Java VM vendor: Oracle Corporation

Java version: 1.8.0_25

Java VM version: 25.25-b02

JChem version: 5.3.0.1

JChem Index version: 5030002

JDBC driver version: 11.1.0.7.0-Production

 

Hi Christer,

I tried to run your first failing select statement with the latest version of JChem Cartridge, and it runs without any error.

select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','logp()') from dual;

There might be a bug in the old version (5.3.0.1) you are using. Upgrading your system to a fresh version wouldn't be an appropriate solution? There are many improvements and bugfixes included relating to 5.3.0.1.

Nevertheless,  find here the jc_evaluate functions available now.

Best regards

Krisztina

Ok, I'll have a talk with the chemistry team and schedule an upgrade.