error during jc_insert : Warning: ociexecute(): ORA-20104...

Hello,

I have this following error during the use of jc_insert function :

Warning: ociexecute(): ORA-20104: Missing credential(s).Either jchem_core_pkg.use_password(...) must be called or oracle.server.login must be set. (See http://www.chemaxon.com/jchem/doc/admin/cartridge.html#jcserver_dbaccess_credentials)

ORA-06512: a "SYSADMIN.JCHEM_CORE_PKG", ligne 45

ORA-06512: a "SYSADMIN.JCHEM_TABLE_PKG", ligne 53

Hello,

What is "cnfusion"?

Thanks,

Peter

cnfusion is the user who  uses jc_insert function, 

with this user, structures are inserted in the database

hello,

any idea?

I try to reinstall JchemCartridge without error but during the insertion of structures, i have always the same error : 

Warning: ociexecute(): ORA-20104: Missing credential(s).Either jchem_core_pkg.use_password(...) must be called or oracle.server.login must be set. (See http://www.chemaxon.com/jchem/doc/admin/cartridge.html#jcserver_dbaccess_credentials)

ORA-06512: at "SYSADMIN.JCHEM_CORE_PKG", line 45

ORA-06512: at "SYSADMIN.JCHEM_TABLE_PKG", line 53

I also try to run : /server.sh purge-connection-caches

but same error...

thanks

Which JChem version is this?

release 6.0.1

I cannot reproduce the error.

The jc_insert function is directly called in a PL/SQL program, correct? Please, could tell us (1) how this program (function or procedure) is declared, (2) in which schema it is stored and (3) which user is trying to execute it?

Thanks,

Peter

Hi Peter,

$stmt = OCIParse($link,"DECLARE

cd_id cd_id_array;

BEGIN

cd_id := sysadmin.jchem_table_pkg.jc_insert(:molfile1,'sysadmin.sub_structure', 'sysadmin.JCHEMPROPERTIES','true','false');

dbms_output.put_line(cd_id(1));

END;");

it is included in a php script.

This script worked well before, except for the error ORA-00600.

Now I try to reinstall Jchem Cartridge without error and now we have this error.

jc_insert is stored in SYSADMIN schema and CNFUSION try to use it.

I run : ./config-util.sh list-sqls-for-jcc-user-privs

+ ./config-util.sh config-index-user

to allow CNFUSION to use jc_insert function.

Please, could you do the following:

1. stop the JChem Cartridge server (bash server.sh stop)

2. add to the jchem/cartridge/conf/logging.properties file the following line:

chemaxon.jchem.cartridge.servlets.JccConnectionManager.level = FINEST

3. start the JChem Cartridge server (bash server.sh start)

4. exercise the failing jc_insert function

5. stop the JChem Cartridge server

6. upload the content of the jchem/cartridge/logs directory.

Thanks,

Peter

I attach the logs folder.

Thank you. Please, could you perform the same steps as before with the exception that in step #4 you call jchem_core_pkg.use_password(), before you exercise the jc_insert function?

Thanks,

Peter

I attach the new log files

Thank you! The error is actually thrown for user CNLECTEUR. Do you also call use_password for CNLECTEUR?

Thanks,

Peter

I have to check why CNLECTEUR is called, normally only CNFUSION must be called.

It works now!!!

by default, the connexion was with user CNLECTEUR

we modify the parameters files and the connexion with user SYSADMIN was deleted by error

Thanks