Canot create JChem index

Hi support team

We have encountered a problem with the JChem cartridge when trying to create an index.  Please can you advise on why this might be happening?

The full error string is shown below for ease of reference.

Many thanks

Karen

 

create index struct_jchem_idx on structures (structure)

  indextype is
jchem.jc_idxtype

 
parameters('tableType=anyStructures')

Error at line 1

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

ORA-29532: Java call terminated by uncaught Java exception:
java.rmi.ServerException: RemoteException occurred in server thread; nested
exception is:

                java.rmi.RemoteException:
OALL8 is in an inconsistent state

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

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

Hi,

I'm working with Karen on this and I will just supplement this with a few details. 

Oracle is 10.2.0.4 on Linux Redhat AS 4 (I think).  JChem is 5.2.6.

Regards,

Steve H

Hi,

 

Please look for the corresponding stack trace in the JChem Server's log directory.

(jchem/cartridge/logs)

You may also zip and attach all the files.

Purging the connection cache (or restarting the jchem server) might worth a try:

http://www.chemaxon.com/jchem/doc/admin/cartridge.html#purge_connection_caches 

 

Best regards,

 

Szilard

You might also want to look for errors in the Oracle alert.log file, as OALL8 is often an indication that the backend Oracle session process crashed.

You can also get OALL8, if the Oracle server was shutdown or brought into some form of restricted/single-user mode of operation without the JChem Server having been restarted.

Peter

Thanks to you both.

We're trying to get hold of the logs (the server is at a remote site with time differences) and will also sggest a JChem and Oracle restart.

Steve

Hello

Just to let you know that a restart of JChem appears to have moved the situation forward as the user is now receiving an error related to privleges:

create index struct_jchem_idx on structures (structure) 

  indextype is jchem.jc_idxtype 

  parameters('tableType=anyStructures') 

Error at line 1 

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

ORA-29532: Java call terminated by uncaught Java exception:
java.rmi.ServerException: RemoteException occurred in server thread; nested
exception is: 

        java.rmi.RemoteException: ORA-01031:
insufficient privileges 

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

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

 

We have instructed them how to set the required privileges, and have asdvised a reinstallation.  For your interest I have attached the logs to this post.

 

Many thanks

 

Karen

Hi Karen,

I suspect the logs were probably taken after the JChem Server was restarted and before the privilege related error occurred.

Let us know if problems persist.

Peter

Thanks Peter

We will consider this closed for now and get back to you if we have any further issues.

Many thanks

Karen