Multiple schemas search errors

Hi,

I am trying to do across schemas search and getting Oracle errors. Structural table and index belongs to one schema and using different schema within the same database. The errors are:

ORA-29902: error in executing ODCIIndexStart() routine

ORA-29540: class chemaxon/jchem/cartridge/serverside/JFunctions does not exist

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

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

29902. 00000 -  "error in executing ODCIIndexStart() routine"

*Cause:    The execution of ODCIIndexStart routine caused an error.

*Action:   Examine the error messages produced by the indextype code and

           take appropriate action.

I have granted appropriate privileges via jcc_basic role and direct grants 

for select, insert, delete, update privs to other tables as well (ic_idx_property, jchemproperties, jchemproperties_cr)

Please let me know how to resolve this issue.

Thank you.

IY

Hi,

Did you

call privman_pkg.grants_on_jcobjs(<jcc-install-schema>, <index-owner>)

and

call privman_pkg.grants_on_jcobjs(<jcc-install-schema>, <index-user>)

?

Thanks,

Peter

Hi Peter,

Thank you for solution. I missed that part. It worked except it gave me new errors and I had to manually grant select,insert,update,delete on compounds_jcx table. Should the privman_pkg grant all privileges?

Please advise.

Regards,

IY

Hi,

What was the error message you got? And for which call did you get it: for the first one or the second one I suggested?

The recommended "entry point" to grant JChem Cartridge-related privileges is to use the "config-util.sh" tool in the jchem/cartridge directory. In your case, executing

bash config-util.sh config-index-user

is recommended. It is supposed to list the steps to execute and (optionally) to execute them for you.

Thanks,

Peter