Maximum number of searches allowed exceeded

Hi.


I'm running the following query.


select ACCSPEED.BVTCIMS.compound_id,ACCSPEED.BVTCIMS.molfile from ACCSPEED.BVTCIMS where jc_containsb(ACCSPEED.BVTCIMS.cd_structure,(select molfile from temp_mol where pkey = 3))=1 order by ACCSPEED.BVTCIMS.compound_id





against approx 2000000 compounds. It should take about 500 sec. and return ~300000 hits.





During the search I get the following error.





Error> ORA-29902: error in executing ODCIIndexStart() routine


ORA-29532: Java call terminated by uncaught Java exception: java.lang.Exception:


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_BLOB_PKG", line 0


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 449 (jchem.bee:625)


Error> ORA-29902: error in executing ODCIIndexStart() routine


ORA-29532: Java call terminated by uncaught Java exception: java.lang.Exception:


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_BLOB_PKG", line 0


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





Please help.


Regards,


/Mikael

Mikael,





Please, restart Tomcat (or reload the JChemStreams application context) in order to force it to re-read the licensing info. (If you have recently re-registered the license keys as part of a JChem Cartridge ugrade, it is possible that JChemSearch was reading the licensing info at a point in the past, when there happend to be nothing in the JChemProperties table.)





Peter

Already done that, but with the same result.


/Mikael

Have you specified any JChemProperties table as an index parameter when creating a jc_idxtype index on ACCSPEED.BVTCIMS.cd_structure?





Peter

No.


I used the following to create the index.


CREATE INDEX idx_jchem_struct ON bvtcims(cd_structure) INDEXTYPE IS jchem.jc_idxtype;





/Mikael

You logged in as ACCSPEED, didn't you?





Can you see the license key for JChem Base in the prop_value column of the ACCSPEED.JCHEMPROPERTIES table?





Which JChem version are you using?





Peter

Hi.


No, I can not see the license information in accpseed.jchemproperties, but I can see it in my small database which works. They are both on the same server.





I'm running version


JChem version: 3.0.13


JChem Streams version: 3.0.13





/Mikael

For each jc_idxtype index, the licensing information is taken from the jchemproperties table associated with the index. The jchemproperties table associated with a jc_idxtype index by default is:

Code:

<indexed-table-schema>.JCHEMPROPERTIES

Please, register your JChem Base and JChem Cartridge license keys using JChemManager so that it is pointing to the ACCSPEED.JCHEMPROPERTIES table. You can select the jchemproperties table as you connect with the JChemManager GUI to your database. That should solve the problem.





Peter

Hi.


Since I created the index without the license, do I have to drop the index and recreate it after I have entered the license ?


/Mikael

No need to recreate the index. Just register the licenses and restart Tomcat





Peter