JChem Oracle error: Descriptor name is too long

Hello,

 I'm trying to create a molecule index for markush structure, but even on a empty table I'm getting "Descriptor name is too long. The maximum allowed length is 0." Oracle error.

The code is the following:

create table chemical_entity3 (
  chemical_entity_id integer not null,
  structure clob not null,

  CONSTRAINT chemical_entity3_pk PRIMARY KEY (chemical_entity_id)
);

create index chem_entity3_jchem_idx on chemical_entity3(structure) indextype is jchem.jc_idxtype PARAMETERS ('structureType=markush'); 

The output is the following:

Error starting at line : 14 in command -
create index chem_entity3_jchem_idx on chemical_entity3(structure) indextype is jchem.jc_idxtype PARAMETERS ('structureType=markush,')
Error at Command Line : 14 Column : 14
Error report -
SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20105: Descriptor name is too long. The maximum allowed length is 0.
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 45
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 29
29855. 00000 -  "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause:    Failed to successfully execute the ODCIIndexCreate routine.
*Action:   Check to see if the routine has been coded correctly.  

For non-markush index it works fine:

create index chem_entity3_jchem_idx on chemical_entity3(structure) indextype is jchem.jc_idxtype PARAMETERS ('')

 How should I create a molecule index for Markush structures?

 JChem environment is the following:

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

JChem owner: JCHEM

JChem Server environment: 
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_45
Java VM version: 20.45-b01
JChem version: 5.12.3
JChem Index version: 5120000
JDBC driver version: 11.1.0.7.0-Production  

 

Thanks!

Mikhail

I was able to solve my problem by using a shorter name for index.

Hi,

The maximum length of the names of markush type tables is 18 (22 for other table types). We'll have a more informative error message at index creation from version 6.3.

Regards,

Tamas