No valid license key has been found for HBDAPlugin

Hi,





I installed the newest version of jchem cartridge to tomcat5 server/oracle10g, following the installation documents.


Both tests to jchemstreams and jchem manager were passed as described in the documents. The licenses.dat was uploaded thru jchemstreams and saved in tomcat owner/,chemaxon/


However, when I executed sql in sqlplus of oracle, I got below error messages


please helps. Thank you








ERROR at line 1:


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.Exception: The following exception has been thrown by the servlet:


Exception: Error while evaluating expression:


donorCount


No valid license key has been found for HBDAPlugin.


The maximal number of calls (1) without a license key has been reached.


Please contact sales _at_ chemaxon.com to obtain a license key.


Students and academic researchers can obtain license keys


for free through our Academic Package, for more information


please visit: http://www.chemaxon.com/acpack_conditions.html


No valid license key has been found for HBDAPlugin.


The maximal number of calls (1) without a license key has been reached.


Please contact sales _at_ chemaxon.com to obtain a license key.


Students and academic researchers can obtain license keys


for free through our Academic Package, for more information


please visit: http://www.chemaxon.com/acpack_conditions.html


ORA-06512: at "JCHEM_CARTRIDGE.JCHEM_CORE_PKG", line 84


ORA-06512: at "JCHEM_CARTRIDGE.JCF_EVALUA

Hi,





Have you restarted Tomcat after loading the license file?





Thanks


Peter

Yes. I did tomcat/bin/shutdown.sh followed by tomcat/bin/startup.sh


The license file I uploaded starts with three lines not using "=", but ":" before their values.

Please, could send the license file to pkovacs at chemaxon dot com?





Please, could you also specify the sql statement which you were trying to execute?





Thanks


Peter

Please, could you check the proper location for the license file using JChemStreams:





1. Point your WEB-browser to the JChemStreams WEB-application, i.e. to the URL which you specified during the installation of JChem Cartridge (or http://localhost:8080/jchemstreams, if you haven't specified any during installation)





2. Follow the link "Check Java system properties here.."





3. Look for the user.home system property.





The value of the user.home system property is the directory which should contain the .chemaxon sub-directory (or chemaxon -- without the starting dot -- if Tomcat is running Windows) where the licenses.dat file should be stored.





(Based on the SQL statements you sent me, I am also not sure where you actually need the HDBA plug-in. Maybe during structure insert? Have you, perhaps, specified a custom Standardizer configuration?)





Thanks


Peter

Hi,





The "Java system properties" gives me





user.home = /usr/share/tomcat5





where is the tomcat home dir of the user "tomcat" (owner of tomcat server) of my SuSE10:





tomcat@ywuibm52:~> cd .chemaxon/


tomcat@ywuibm52:~/.chemaxon> ls -la


total 8


drwxr-xr-x 2 tomcat tomcat 112 2007-11-11 04:45 .


drwxr-xr-x 8 tomcat tomcat 400 2007-11-10 15:28 ..


-rw-r--r-- 1 tomcat tomcat 358 2007-11-10 23:11 .cartridge


-rw-r--r-- 1 tomcat tomcat 1215 2007-11-11 04:45 licenses.dat


tomcat@ywuibm52:~/.chemaxon>





The sql script is use to validate the compound structures previously loaded to a stage table and to copy (insert) them from the stage table to a compound table.





I did use command line to do molconvert and sandardize and bot are fine.





Please suggest other points I should check.


Thanks

Please, could you post the corresponding Java stack trace from the Tomcat logs?





It looks as though you were using jc_evaluate, but I cannot see it be used in the SQL code snippets you have sent to me.





Thanks


Peter

Hi, Peter





We do have triggers associated with the table, which compounds will be inserted to. They do use jcf_evaluate, like





:new.hbd :=jcf_evaluate(smiles, 'donorCount');


:new.hba :=jcf_evaluate(smiles, 'acceptorCount');


:new.tpsa :=jcf_evaluate(smiles, 'PSA');


-- :new.clogp :=jcf_evaluate(smiles, 'logP');





log files are attached.





Thanks

I assume you are not able to successfully use donorCount from with SQLPlus either (like in

Code:

select jcf_evaluate('c1ccccc1', 'donorCount') from dual;

), are you?





Thanks


Peter

Hi,





No, I can not. I got the same error message.


Trying "insert into cpd (asmiles) values ('c1ccccc1');"


dose not work, neither. (attached catalina.out)





Then, "select * from cpd where jc_compare(jc_smiles, 'c1ccccc1','t:r')=1;" gives "no rows selected".





Thank you

Hi, Peter





In stead of using the table that errors occured, I connected the database


using JChem Manager. Then, I created a new structure table in the schema


by click "Create" followed by several "OK". I connected a new filed "logp" to "logp()" as described in admin document.





The, agian lincense error appeared as I "Import" a sdf file.





Any suggestion to fix it?


Thanks

Hi, Peter





I think I find the problem and fix it.





It was an ignored error occured when I was using the "LicenseHandler"


under jchem (or the marvin/bin/license) to install the license keys.





The error was "Could not set license keys for: Jchem/ chemaxon.marvin.space.GraphicScene/ JKlustor"


If click "ok" to the error message followed by clicking on "License Group/ALL"


and then "Set license keys", I've had "License key have been updated.".





But the license keys were acctually not saved.





using "license -l", I see all packages are with "--", not the '+" sign.











Ying-Ta

Hi Ying-Ta,





I am not sure what you mean by the file not having been saved. In your directory listing from tomcat home ~/.chemaxon, there is clearly a licenses.dat file. If the file is there and contains the license (and tomcat has been restarted), the HDBA license code should be found by JChemStreams in Tomcat.





But I am glad you have found the solution.





Thanks


Peter