topic Re: Error with MDM (maybe with crossreference) again and again... in Talend Data Catalog

Error with MDM (maybe with crossreference) again and again...

justine_revol — Wed, 23 Nov 2016 13:29:27 GMT

Hello everybody.
I have a job that perfectly works with few lines (15) but sometimes it crashes (more than 50% runs go wrong)...
I try to insert data into a "Client" entity . The creation triggers an insert into the crossreference table.
So, when it crashes, I try to relaunch it but I have the issue :

nov. 23, 2016 11:18:53 AM org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean buildServiceFromClass
INFOS: Creating Service {}TMDMService from class org.talend.mdm.webservice.TMDMService
nov. 23, 2016 11:18:54 AM org.apache.cxf.phase.PhaseInterceptorChain doDefaultLogging
AVERTISSEMENT: Interceptor for {}TMDMService#{}ping has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Unmarshalling Error: Unexpected EOF; was expecting a close tag for element <soap:Body>
 at :  
	at org.apache.cxf.jaxb.JAXBEncoderDecoder.unmarshall(JAXBEncoderDecoder.java:905)
	at org.apache.cxf.jaxb.JAXBEncoder

To see the whole post, download it here

Re: Error with MDM (maybe with crossreference) again and again...

Anonymous — Thu, 24 Nov 2016 06:44:25 GMT

Hi,
Could you please indicate on which build version you got this issue?
Best regards
Sabrina

Re: Error with MDM (maybe with crossreference) again and again...

justine_revol — Thu, 24 Nov 2016 08:12:14 GMT

Hello,
I am running on 6.1.1
Thank for your help !
Best regards

Re: Error with MDM (maybe with crossreference) again and again...

Anonymous — Thu, 22 Dec 2016 07:58:52 GMT

Hello,
I am running on 6.1.1
Thank for your help !
Best regards

I had the same problem, what component you use for your job ? If it is tMDMOutput and tMDMConnection, verify that your connection is perfectly opened and closed in your job.
Another thing verify : your hibernate configuration, to relase properly connection ...
Pat

Re: Error with MDM (maybe with crossreference) again and again...

jscher01 — Tue, 07 Aug 2018 16:06:41 GMT

Hello patgream,

Yes, the issue tends to be with connections staying open between SQL and MDM. Turning on Auto Commit on the connection component helps. Also try tweaking the buffer size on output components if there is still an issue. Setting the hibernate configuration to auto close open connections after a shorter time helps during development.

Whenever anyone is seeing issues like 'logout has thrown exception, unwinding now' when using Talend MDM. Ask a DBA to look at open connections.

Re: Error with MDM (maybe with crossreference) again and again...

Anonymous — Fri, 10 Aug 2018 08:51:52 GMT

Hi,

It will be a good idea to add a tMDMClose component in the tPostJob to make sure that connections are getting closed when you are moving out of the job.

Warm Regards,

Nikhil Thampi

Re: Error with MDM (maybe with crossreference) again and again...

jscher01 — Fri, 10 Aug 2018 14:55:31 GMT

Nikhil,

Logically adding a close connect to the post job section of the job would make sense. We have one there and it appears to close the connect from Talend to MDM but not from MDM to SQL server. Another work around was to add close connections to the pre job section after each tMDMInput component but turning on auto commit was cleaner.

Thanks,

James