Error creating index of type jchem.jc_idxtype

User 17c734543a

17-02-2009 13:50:55

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)

ChemAxon aa7c50abf8

17-02-2009 14:09:46

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

User 17c734543a

17-02-2009 15:32:43

*** 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)

ChemAxon aa7c50abf8

17-02-2009 16:34:43

What do the following statements return?








Code:
select user from dual;


select "JCHEM_CORE_PKG"."GET_CARTOWNER_SCHEMA" from dual;

User 17c734543a

17-02-2009 17:04:02

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>

ChemAxon aa7c50abf8

17-02-2009 17:08:30

Did you execute the problematic CREATE INDEX statements as JCHEM?