duplicate key name error with JChem tables

User 23ba1704ca

27-01-2014 05:35:38

Hello All

We have deployed Rest API and web services is working well. In attempt to configure same setup on different server database is imported from existing setup to new server.

Now when /webservices/rest-v0/data/<Database-Name-Here>/ is accessed to check general configuration it gives below error:

{"errorCode":1,"errorMessage":"Duplicate key name \u0027jchemmetadatatable_IDX\u0027","rootCause":"SQLException","rootErrorMessage":"Duplicate key name \u0027jchemmetadatatable_IDX\u0027"}

Same database is working well with API on existing server. Please advise.

Also, please suggest that whenever, there is an update of the JChemBase package and the update is applied, do we require to regenerate the fingerprints again?

Thanks

Ashish Dugar

ChemAxon abe887c64e

27-01-2014 13:29:35

Hi Ashish,

As for your second question, yes, you have to run a 'recalculate' process when you update your JChem to a newer version. If you use JChem Manager GUI or run 'jcman u' in commandline, you will be asked whether you want to recalculate or not, please answer 'yes'.

For answering your the first issue I move this topic to the Webservices forum topics.

Best regards,

Krisztina

ChemAxon 13811e1703

27-01-2014 15:51:11

Hi Ashish!

Which version of JChem REST Web Services are you using?
Can you please send us the log file from: %catalina home%/logs/chemaxon.log?

Thanks,
Peter

User 23ba1704ca

27-01-2014 16:52:10

Hello Peter

Please find attached the chemaxon.log file.

Thanks

Ashish

User 23ba1704ca

28-01-2014 14:21:04

Hello team

Any update on this issue.

thanks

Ashish

ChemAxon 13811e1703

28-01-2014 14:49:01

Hi!

Is it the latest version of the Jchem REST Web Services?
What is the version you are using?

Regards,
Peter

User 23ba1704ca

30-01-2014 06:32:17

Hello Peter

We are using jchem-6.1.3-windows_with_jre along with webservices-6.1.3-b13.

Interestingly, when we are deploying the webservices.war file, server information section displays the following information:

{

"welcomeMessage": "You connected to the JChem REST Web Services",

"availableServices": [

"JChem Simple Web Services"

],

"version": "6.0.1",

"jchemVersion": "6.0.1_b88",

"javaVersion": "1.7.0_17",

"osVersion": "Windows 7",

"servletVersion": "jetty/6.1.25",

"configDir": "...",

"availableLicenses": {

"ECFP/FCFP": {

"state": "valid",

"expirationDate": "2013-09-25"

},

"Structural Frameworks Plugin": {

"state": "valid",

"expirationDate": "2013-09-25"

},

"JChem Cartridge": {

"state": "valid",

"expirationDate": "2013-09-25"

},

"3D Screen": {

"state": "valid",

"expirationDate": "2013-09-25"

},

"Marvin Applets": {

"state": "valid",

"expirationDate": "2013-09-25"

}

As you can note, the web service version number is not the one we are deploying. We have consistently tried to undeploy and redeploy the webservices.war so that the right version number is displayed, but nothing is working so far.

Thanks

Ashish

User 23ba1704ca

30-01-2014 09:39:48

I can see some errors in catalina.log file, when the war file is being called, as tomcat is getting initialized:

Jan 30, 2014 3:02:39 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\ChemAxon\JChem\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Common Files\Acronis\SnapAPI\;C:\Windows\System32\WindowsPowerShell\v1.0\;.

Jan 30, 2014 3:02:42 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler ["http-bio-8080"]

Jan 30, 2014 3:02:42 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler ["ajp-bio-8009"]

Jan 30, 2014 3:02:42 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 4716 ms

Jan 30, 2014 3:02:42 PM org.apache.catalina.core.StandardService startInternal

INFO: Starting service Catalina

Jan 30, 2014 3:02:42 PM org.apache.catalina.core.StandardEngine startInternal

INFO: Starting Servlet Engine: Apache Tomcat/7.0.42

Jan 30, 2014 3:02:43 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive C:\xampp\tomcat\webapps\webservices.war

Jan 30, 2014 3:04:16 PM org.apache.catalina.startup.ContextConfig processAnnotationsJar

SEVERE: Unable to process Jar entry [COM/ibm/db2os390/sqlj/custom/DB2SQLJCustomizer.class] from Jar [jar:file:/C:/xampp/tomcat/webapps/webservices/WEB-INF/lib/db2jcc-1.0.jar!/] for annotations

org.apache.tomcat.util.bcel.classfile.ClassFormatException: null is not a Java .class file

at org.apache.tomcat.util.bcel.classfile.ClassParser.readID(ClassParser.java:238)

at org.apache.tomcat.util.bcel.classfile.ClassParser.parse(ClassParser.java:114)

at org.apache.catalina.startup.ContextConfig.processAnnotationsStream(ContextConfig.java:2118)

at org.apache.catalina.startup.ContextConfig.processAnnotationsJar(ContextConfig.java:1994)

at org.apache.catalina.startup.ContextConfig.processAnnotationsUrl(ContextConfig.java:1960)

at org.apache.catalina.startup.ContextConfig.processAnnotations(ContextConfig.java:1945)

at org.apache.catalina.startup.ContextConfig.webConfig(ContextConfig.java:1319)

at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:878)

at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:376)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5322)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Jan 30, 2014 3:04:16 PM org.apache.catalina.startup.ContextConfig processAnnotationsJar

SEVERE: Unable to process Jar entry [COM/ibm/db2os390/sqlj/custom/DB2SQLJEntryInfo.class] from Jar [jar:file:/C:/xampp/tomcat/webapps/webservices/WEB-INF/lib/db2jcc-1.0.jar!/] for annotations