[resolved] Cannot open connection exception

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
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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads