Error creating index of type jchem.jc_idxtype

I'm getting the follwoing error when trying to create an index of type jchem.jc_idxtype





CREATE INDEX jc_idx_structure ON evo_structure(smiles) INDEXTYPE IS jchem.jc_idxtype PARAMETERS('TABLESPACE=jchem_idx');


CREATE INDEX jc_idx_structure ON evo_structure(smiles) INDEXTYPE IS jchem.jc_idxtype PARAMETERS('TABLESPACE=jchem_idx')


*


ERROR at line 1:


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.NoClassDefFoundError


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 67


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 17








I've had a search through the forum but can't find anything which matches this problem exactly. I have read the installation notes but I'm not sure how to apply this.





Any clues?





Jchem version 5.1.04, Oracle 10.2.0.3, Centos 4.7 (64 bit Redhat ES 4.7)

Pete,





Please, could you post the last few sections of the Oracle session trace file in the admin/<db-name>/udump directory? (The relevant trace will contain the "java.lang.NoClassDefFoundError" string [w/o the dblquotes].)








Thanks





Peter

*** SESSION ID:(144.41884) 2009-02-17 14:38:16.863


oracle.jdbc.driver.OracleSQLException: ORA-00904: "JCHEM_CORE_PKG"."GET_CARTOWNER_SCHEMA": invalid identifier


        at oracle.jdbc.driver.T2SConnection.check_error(T2SConnection.java:154)


        at oracle.jdbc.driver.T2SPreparedStatement.checkError(T2SPreparedStatement.java:93)


        at oracle.jdbc.driver.T2SPreparedStatement.describe_internal(T2SPreparedStatement.java:164)


        at oracle.jdbc.driver.T2SPreparedStatement.executeForDescribe(T2SPreparedStatement.java:396)


        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1146)


        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)


        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1489)


        at chemaxon.jchem.cartridge.dbsession.DbSessionBase.getCartOwnerSchema(DbSessionBase.java:58)


        at chemaxon.jchem.cartridge.dbsession.JCSession.<init>(JCSession.java:81)


        at chemaxon.jchem.cartridge.dbsession.JCSession.<clinit>(JCSession.java:46)


        at chemaxon.jchem.cartridge.dbsession.DbContext.<clinit>(DbContext.java:37)


        at chemaxon.jchem.cartridge.JFunctions.isJChemTable(JFunctions.java:1691)


        at chemaxon.jchem.cartridge.Indexing.indexCreate(Indexing.java:109)


        at chemaxon.jchem.cartridge.Indexing.indexCreate(Indexing.java:73)


java.lang.NoClassDefFoundError


        at chemaxon.jchem.cartridge.JFunctions.isJChemTable(JFunctions.java:1716)


        at chemaxon.jchem.cartridge.Indexing.indexCreate(Indexing.java:109)


        at chemaxon.jchem.cartridge.Indexing.indexCreate(Indexing.java:73)

What do the following statements return?

Code:

select user from dual; select "JCHEM_CORE_PKG"."GET_CARTOWNER_SCHEMA" from dual;

connected as user jchem





SQL> select user from dual;





USER


------------------------------


JCHEM





SQL> select "JCHEM_CORE_PKG"."GET_CARTOWNER_SCHEMA" from dual;





GET_CARTOWNER_SCHEMA


--------------------------------------------------------------------------------


JCHEM





SQL>

Did you execute the problematic CREATE INDEX statements as JCHEM?