Index Build Error with version 6.1

I have upgraded to version from 5.12 to 6.1 as follows:

Windors Server 2012 Standerd Edition 64 bit   |  16GB RAM   |   Intel Xeon Processor

Oracle 11.2g

JChem 6.1

Rather than upgrade I did a complete uninstall and then new install of the JChem cartridge.

I did have to follow these instructions in order to install jchem as a windows service:

https://www.chemaxon.com/forum/ftopic10940.html&highlight=

When I issue the command to create the index I get the following error message:

SQL> CREATE INDEX akos_jc_molix ON akos_moltable(ctab_clob) INDEXTYPE IS jchem.jc_idxtype PARAMETERS('haltOnError=nf');

CREATE INDEX akos_jc_molix ON akos_moltable(ctab_clob) INDEXTYPE IS jchem.jc_idxtype PARAMETERS('haltOnError=nf')

*

FEHLER in Zeile 1:

ORA-29855: Fehler bei Ausf³hrung der Routine ODCIINDEXCREATE

ORA-29532: Java-Aufruf durch nicht abgefangene Java-Exception beendet:

java.rmi.ServerException: RemoteException occurred in server thread; nested

exception is:

java.rmi.RemoteException: java.sql.SQLSyntaxErrorException: ORA-01031:

insufficient privileges

ORA-06512: in "JCHEM.JCHEM_CORE_PKG", Zeile 105

ORA-06512: in "JCHEM.JC_IDXTYPE_IM", Zeile 20

 

Please advise.

 

Thanks for your help.

 

Bernard D'Alwis

 

Hello,

Can you send us (or upload) the log files from jchem/cartridge/logs directory?

Thank you,

Tamas

Hi Tamas

 

Please find attached the log files that I found in JChem\Cartridge\logs ...

 

Thanks

 

Bernard.

Thank you,

And can you tell us how did you exactlyset up the user privileges for the JChem Server. With the use_password function or by the jcart.properties file? Which user are they set up to (the user name if you use use_password or the oracle.server.login name in the jcart.properties file)? Does this user have privilege to the akos_moltable table?

Regards,

Tamas

Hi Tamas:

• User AKOS_SAMPLES is running the create index command.


• AKOS_SAMPLES owns to molecle table (AKOS_MOLTABLE).


• AKOS_SAMPLES has been granted the JCC_BASIC_ROLE.


• I am using use_password and giving the JCHEM user credentials with this function call:

call jchem.jchem_core_pkg.use_password('jchem', '**********');

 

Many thanks

 

Bernard

Hi Tamas:

After writing my last reply I was prompted to try to use AKOS_SAMPLES in the use_password funciton call:

call jchem.jchem_core_pkg.use_password('AKOS_SAMPLES', '**********');

It now seems to be creating the domain index after issuing the create index command.

I think in the past I have used the jchem user and password with success. Has something changed or am I mistaken?

Thanks

 

Bernard

 

Hi,

As far as I know, there haven't been changes in the handling of user credentials in JChem Cartridge. Maybe you used the 1 parameter version of the use_password function, where only the password needs to be given (the user in that case is the logged in user).

Regards,

Tamas