Maximum number of searches allowed per minute is exceeded

We are running a query using Jchem cartridge and getting the following error. This is working in one of our data schema but as soon as we query from another schema we are getting the following error.





SELECT par.parent_id


FROM mdlacd_2005_2.PARENT par


WHERE par.parent_id IN (


SELECT v.parent_id


FROM mdlacd_2005_2.VERSION v


WHERE jc_compare (v.isosmiles, 'CCCc1ccc2ccccc2c1', 'sep=~ t:s ') =


1)


AND ROWNUM < 5001


ORDER BY par.molecular_weight





We are getting results but if run the sam query from different schema we getting the following error





SELECT par.parent_id


FROM mdlacd_2007_3.PARENT par


WHERE par.parent_id IN (


SELECT v.parent_id


FROM mdlacd_2007_3.VERSION v


WHERE jc_compare (v.isosmiles, 'CCCc1ccc2ccccc2c1', 'sep=~ t:s ') =


1)


AND ROWNUM < 5001


ORDER BY par.molecular_weight





ORA-29902: error in executing ODCIIndexStart() routine


ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: The following exception has been thrown by the servlet:


Exception: Maximum number of searches allowed per minute is exceeded. Please try it later.


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


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


ORA-06512: at line 1

Hi Catherine,





The license codes are stored in jchemproperties tables. The user of the jc_compare operator must be able to "see" (must be granted a SELECT privilege on) the jchemproperties table associated with the jc_idxtype index created on mdlacd_2005_2.VERSION.isosmiles. If you use default jchemproperties tables, you simply have to grant SELECT privilege on mdlacd_2005_2.jchemproperties to the "other" user. Please, see http://www.chemaxon.com/jchem/FAQ.html#jcart_jchemproperties_table for a more detailed discussion.





Note that starting with JChem 5.0, license management will be substantially simplified: license codes (license files) dropped in a (configurable) directory will have a scope global to the JChem Cartridge instance.





Best Regards


Peter