One Star

[resolved] Cannot open connection exception

Hi
I've created a few jobs to insert/update data in MDM. I orchestrated these job. When I want to run these jobs I sometimes get the following error:
org.hibernate.exception.GenericJDBCException: Cannot open connection; nested exception is:
       com.amalto.core.util.XtentisException: org.hibernate.exception.GenericJDBCException: Cannot open connection

This error causes the whole chain to fail. I get this error in different child jobs and the jobs in which the error appears seem to be different every time I run the whole process.
How can I resolve this issue?
Kind regards
Dries
2014-12-30 08:38:24|9phZSd|RbxY5f|x94SSz|1216|HELIOS|j001_DEDUP_KBO_process_uniques|_FhBcUItrEeSgMb5eiNG0XA|0.1|Dev||begin||
org.hibernate.exception.GenericJDBCException: Cannot open connection; nested exception is:
       com.amalto.core.util.XtentisException: org.hibernate.exception.GenericJDBCException: Cannot open connection
2014-12-30 08:38:24|muIof3|9phZSd|x94SSz|1216|HELIOS|j001_CSV2MDM_insert_unique_organisation|_4bnecIp8EeS_1c0iisjjIg|0.1|Dev||begin||
2014-12-30 08:38:24|lliweN|muIof3|x94SSz|1216|HELIOS|j001_CSV2MDM_insert_sources|_fr1lcIqREeS_1c0iisjjIg|0.1|Dev||begin||
org.hibernate.exception.GenericJDBCException: Cannot open connection; nested exception is:
       com.amalto.core.util.XtentisException: org.hibernate.exception.GenericJDBCException: Cannot open connection
2014-12-30 08:38:37|lliweN|muIof3|x94SSz|1216|HELIOS|j001_CSV2MDM_insert_sources|_fr1lcIqREeS_1c0iisjjIg|0.1|Dev||end|success|13081
Exception in component tMDMOutput_2
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
faultSubcode:
faultString: Cannot open connection; nested exception is:
       java.lang.RuntimeException: javax.ejb.TransactionRolledbackLocalException: Cannot open connection
faultActor:
faultNode:
faultDetail:
       {http://xml.apache.org/axis/}stackTrace:Cannot open connection; nested exception is:
       java.lang.RuntimeException: javax.ejb.TransactionRolledbackLocalException: Cannot open connection
       at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
       at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
       at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
       at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(Unknown Source)
       at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
       at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
       at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
       at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:796)
       at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
       at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
       at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
       at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
       at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
       at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
       at org.apache.axis.client.Call.invoke(Call.java:2767)
       at org.apache.axis.client.Call.invoke(Call.java:2443)
       at org.apache.axis.client.Call.invoke(Call.java:2366)
       at org.apache.axis.client.Call.invoke(Call.java:1812)
       at org.talend.mdm.webservice.XtentisBindingStub.putItemArray(XtentisBindingStub.java:6666)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.tFileInputDelimited_5Process(j001_CSV2MDM_insert_unique_or
ganisation.java:5079)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.tRunJob_1Process(j001_CSV2MDM_insert_unique_organisation.j
ava:2584)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.tFileInputDelimited_4Process(j001_CSV2MDM_insert_unique_or
ganisation.java:2369)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.runJobInTOS(j001_CSV2MDM_insert_unique_organisation.java:8
670)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.runJob(j001_CSV2MDM_insert_unique_organisation.java:8521)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.tRunJob_1Process(j001_DEDUP_KBO_process_uniques.java:3993)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.tFileInputDelimited_3Process(j001_DEDUP_KBO_process_uniques.java:3814)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.runJobInTOS(j001_DEDUP_KBO_process_uniques.java:9198)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.runJob(j001_DEDUP_KBO_process_uniques.java:9049)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.tRunJob_2Process(j001_DEDUP_KBO_mr1.java:906)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.tRunJob_1Process(j001_DEDUP_KBO_mr1.java:770)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.runJobInTOS(j001_DEDUP_KBO_mr1.java:3492)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.runJob(j001_DEDUP_KBO_mr1.java:3277)
       at helios.j000_dedup_kbo_do_all_0_1.j000_DEDUP_KBO_do_all.tRunJob_1Process(j000_DEDUP_KBO_do_all.java:686)
       at helios.j000_dedup_kbo_do_all_0_1.j000_DEDUP_KBO_do_all.runJobInTOS(j000_DEDUP_KBO_do_all.java:3096)
       at helios.j000_dedup_kbo_do_all_0_1.j000_DEDUP_KBO_do_all.runJob(j000_DEDUP_KBO_do_all.java:2881)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.tRunJob_1Process(j000_DEDUP_organisation_do_all.java:1285)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.tFixedFlowInput_1Process(j000_DEDUP_organisation_do_all.java:1143)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.tFileExist_1Process(j000_DEDUP_organisation_do_all.java:716)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.runJobInTOS(j000_DEDUP_organisation_do_all.java:3698)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.runJob(j000_DEDUP_organisation_do_all.java:3483)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.tRunJob_2Process(j000_MDM_do_all.java:884)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.tRunJob_1Process(j000_MDM_do_all.java:748)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.runJobInTOS(j000_MDM_do_all.java:3288)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.main(j000_MDM_do_all.java:3066)
       {http://xml.apache.org/axis/}hostname:vntseimdev
Cannot open connection; nested exception is:
       java.lang.RuntimeException: javax.ejb.TransactionRolledbackLocalException: Cannot open connection
       at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
       at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
       at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
       at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
       at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
       at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(Unknown Source)
       at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
       at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
       at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
       at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:796)
       at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
       at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
       at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
       at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
       at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
       at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
       at org.apache.axis.client.Call.invoke(Call.java:2767)
       at org.apache.axis.client.Call.invoke(Call.java:2443)
       at org.apache.axis.client.Call.invoke(Call.java:2366)
       at org.apache.axis.client.Call.invoke(Call.java:1812)
       at org.talend.mdm.webservice.XtentisBindingStub.putItemArray(XtentisBindingStub.java:6666)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.tFileInputDelimited_5Process(j001_CSV2MDM_insert_unique_or
ganisation.java:5079)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.tRunJob_1Process(j001_CSV2MDM_insert_unique_organisation.j
ava:2584)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.tFileInputDelimited_4Process(j001_CSV2MDM_insert_unique_or
ganisation.java:2369)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.runJobInTOS(j001_CSV2MDM_insert_unique_organisation.java:8
670)
       at helios.j001_csv2mdm_insert_unique_organisation_0_1.j001_CSV2MDM_insert_unique_organisation.runJob(j001_CSV2MDM_insert_unique_organisation.java:8521)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.tRunJob_1Process(j001_DEDUP_KBO_process_uniques.java:3993)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.tFileInputDelimited_3Process(j001_DEDUP_KBO_process_uniques.java:3814)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.runJobInTOS(j001_DEDUP_KBO_process_uniques.java:9198)
       at helios.j001_dedup_kbo_process_uniques_0_1.j001_DEDUP_KBO_process_uniques.runJob(j001_DEDUP_KBO_process_uniques.java:9049)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.tRunJob_2Process(j001_DEDUP_KBO_mr1.java:906)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.tRunJob_1Process(j001_DEDUP_KBO_mr1.java:770)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.runJobInTOS(j001_DEDUP_KBO_mr1.java:3492)
       at helios.j001_dedup_kbo_mr1_0_1.j001_DEDUP_KBO_mr1.runJob(j001_DEDUP_KBO_mr1.java:3277)
       at helios.j000_dedup_kbo_do_all_0_1.j000_DEDUP_KBO_do_all.tRunJob_1Process(j000_DEDUP_KBO_do_all.java:686)
       at helios.j000_dedup_kbo_do_all_0_1.j000_DEDUP_KBO_do_all.runJobInTOS(j000_DEDUP_KBO_do_all.java:3096)
       at helios.j000_dedup_kbo_do_all_0_1.j000_DEDUP_KBO_do_all.runJob(j000_DEDUP_KBO_do_all.java:2881)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.tRunJob_1Process(j000_DEDUP_organisation_do_all.java:1285)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.tFixedFlowInput_1Process(j000_DEDUP_organisation_do_all.java:1143)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.tFileExist_1Process(j000_DEDUP_organisation_do_all.java:716)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.runJobInTOS(j000_DEDUP_organisation_do_all.java:3698)
       at helios.j000_dedup_organisation_do_all_0_1.j000_DEDUP_organisation_do_all.runJob(j000_DEDUP_organisation_do_all.java:3483)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.tRunJob_2Process(j000_MDM_do_all.java:884)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.tRunJob_1Process(j000_MDM_do_all.java:748)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.runJobInTOS(j000_MDM_do_all.java:3288)
       at helios.j000_mdm_do_all_0_1.j000_MDM_do_all.main(j000_MDM_do_all.java:3066)
2014-12-30 08:38:49|muIof3|x94SSz|9phZSd|HELIOS|j001_CSV2MDM_insert_unique_organisation|Dev|6|Java Exception|tMDMOutput_2|org.apache.axis.AxisFault:Cannot open
connection; nested exception is:
       java.lang.RuntimeException: javax.ejb.TransactionRolledbackLocalException: Cannot open connection|1
2014-12-30 08:38:49|muIof3|9phZSd|x94SSz|1216|HELIOS|j001_CSV2MDM_insert_unique_organisation|_4bnecIp8EeS_1c0iisjjIg|0.1|Dev||end|failure|25559
2 REPLIES
Employee

Re: [resolved] Cannot open connection exception

Hi,
Could you check in the server log (jboss_dir/server/default/log/server.log) for a more detailed exception? It looks like MDM server is unable to insert data in the underlying database for some reason.
One Star

Re: [resolved] Cannot open connection exception

Hi
Thanks for your reply and sorry for my late reply.
We resolved the issue by restarting our MDM server.
Kind regards
Dries