[resolved] Unable to read records from MDM Hub

Four Stars

[resolved] Unable to read records from MDM Hub

Hi - 
I am trying to import the records from MDM Hub that are fed from the MDM Portal and write them to my DB. However I am receiving the below error when i try to read the records via job using the MDM Entity. (I am using the community edition on my local machine with java 1.8)
My container and entity name are 'Product' as in the 'TalendOpenStudio_MDM_GettingStarted_6.1.1_EN.pdf'
Below are the steps I followed:
1. Create the container and entity called product as mentioned in the pdf.
2. Publish the view onto the portal as mentioned in the pdf.
3. Insert a record from the MDM portal.
4. Create a Talend MDM Connection for 'Product' entity.
5. Create a Talend Job to read from the 'Product' MDM Input component from step 4 above and write to the target table in 'Postgres'
I have attached the screenshots that should help on what I am trying to achieve. Can you please let me know if I am missing something?
I tried to check the connection for the Talend MDM Connection 'Product' and the connection has no issues.
Mar 10, 2016 8:09:21 PM org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean buildServiceFromClass
INFO: Creating Service {http://www.talend.com/mdm}TMDMService from class org.talend.mdm.webservice.TMDMService
Mar 10, 2016 8:09:23 PM org.apache.cxf.phase.PhaseInterceptorChain doDefaultLogging
WARNING: Interceptor for {http://www.talend.com/mdm}TMDMService#{http://www.talend.com/mdm}getItems has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Could not send Message.
at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:64)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:514)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:423)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:324)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:277)
at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:96)
at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:139)
at com.sun.proxy.$Proxy41.getItems(Unknown Source)
at local_project.vm_insert_product_0_1.vm_insert_product.tMDMInput_1_InProcess(vm_insert_product.java:1793)
at local_project.vm_insert_product_0_1.vm_insert_product.runJobInTOS(vm_insert_product.java:2591)
at local_project.vm_insert_product_0_1.vm_insert_product.main(vm_insert_product.java:2435)
Caused by: org.apache.cxf.transport.http.HTTPException: HTTP response '401: Unauthorized' when communicating with http://localhost:8180/talendmdm/services/soap
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.doProcessResponseCode(HTTPConduit.java:1599)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1606)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1550)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1347)
at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56)
at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:651)
at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62)
... 11 more

Could not send Message.
Mar 10, 2016 8:09:23 PM org.apache.cxf.phase.PhaseInterceptorChain doDefaultLogging
WARNING: Interceptor for {http://www.talend.com/mdm}TMDMService#{http://www.talend.com/mdm}logout has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Could not send Message.
at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:64)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:514)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:423)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:324)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:277)
at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:96)
at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:139)
at com.sun.proxy.$Proxy41.logout(Unknown Source)
at local_project.vm_insert_product_0_1.vm_insert_product.tMDMInput_1_InProcess(vm_insert_product.java:2190)
at local_project.vm_insert_product_0_1.vm_insert_product.runJobInTOS(vm_insert_product.java:2591)
at local_project.vm_insert_product_0_1.vm_insert_product.main(vm_insert_product.java:2435)
Caused by: org.apache.cxf.transport.http.HTTPException: HTTP response '401: Unauthorized' when communicating with http://localhost:8180/talendmdm/services/soap
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.doProcessResponseCode(HTTPConduit.java:1599)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1606)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1550)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1347)
at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56)
at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:651)
at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62)
... 11 more

Could not send Message.

Error : The server was unable to save the uploaded file. Please contact the forum administrator at

Error : The server was unable to save the uploaded file. Please contact the forum administrator at
Employee

Re: [resolved] Unable to read records from MDM Hub

Hi,
What you're receiving is an authentication error
HTTP response '401: Unauthorized'

Likely the credentials you're using aren't correct.
Four Stars

Re: [resolved] Unable to read records from MDM Hub

Thanks pbadin. That was it i was using the the one that I used to create the MDM Entity and they didnt work to retreive the data. The default MDM Portal user id and pass worked.
One Star

Re: [resolved] Unable to read records from MDM Hub

Hi,
I am trying to do the same with Talent 6.2.1 version and getting the same kind of error.
Could you please tell me what would be the URL for the mdm server. I am giving  and I know this is not correct.
Also for authentication I am using MDM administrator username and password. Any help is greatly appreciated.
Thanks,
Kishore