Re: Problem loading MDM with tMDMOutput - Page 2 - Qlik Community

Anonymous · ‎2010-04-20

Hi, I am having difficulty loading some simple data into MDM using tMDMOutput. have gone through the various forums here but no luck.
I have created the MDM data model, got some csv data and configured a tWriteXMLField job which gives the following output if I hook it up to tLogRow:

"AGS"
"AGENCIES"

"BND"
"BOND"

"CAP"
"CAPITAL MARKETS"

If I then hook this up to tMDMOutput I get java rmi exceptions. Do I need to configure the XML tree in the tMDMOutput Advanced Settings? Any other pointers gratefully received....

_AnonymousUser · ‎2010-09-15

The notes from Thomas above should fix this problem.
if you stil lhave issue, you may also want to try different credentials in your configuration of the tMDMOutput component. you are currently using the user/pass combo of admin/talend. perhaps try user/user. the admin credentials are typically reserved for management not data.
-Jim

Anonymous · ‎2010-09-16

Thank you Thomas and Jwalker for the solution.
I changed the "rootTag" to "Product" and it works fine now.
regards,

Anonymous · ‎2011-01-20

<ROOT>
<CUSTOMER id="3301">
<NAME>Rahul</NAME>
<MONTH>Jan</MONTH>
<YEAR>2010</YEAR>
<SALARY>7000</SALARY>
</CUSTOMER>
<CUSTOMER id="3301">
<NAME>Rahul</NAME>
<MONTH>Feb</MONTH>
<YEAR>2010</YEAR>
<SALARY>8000</SALARY>
</CUSTOMER>
<CUSTOMER id="3301">
<NAME>Rahul</NAME>
<MONTH>March</MONTH>
<YEAR>2010</YEAR>
<SALARY>10000</SALARY>
</CUSTOMER>
<CUSTOMER id="3302">
<NAME>Rohit</NAME>
<MONTH>Jan</MONTH>
<YEAR>2010</YEAR>
<SALARY>5600</SALARY>
</CUSTOMER>
<CUSTOMER id="3302">
<NAME>Rohit</NAME>
<MONTH>Feb</MONTH>
<YEAR>2010</YEAR>
<SALARY>10000</SALARY>
</CUSTOMER>
<CUSTOMER id="3302">
<NAME>Rohit</NAME>
<MONTH>March</MONTH>
<YEAR>2010</YEAR>
<SALARY>6745</SALARY>
</CUSTOMER>
<CUSTOMER id="67043">
<NAME>Ashish</NAME>
<MONTH>Jan</MONTH>
<YEAR>2010</YEAR>
<SALARY>9467</SALARY>
</CUSTOMER>
<CUSTOMER id="67043">
<NAME>Ashish</NAME>
<MONTH>Feb</MONTH>
<YEAR>2010</YEAR>
<SALARY>9912</SALARY>
</CUSTOMER>
<CUSTOMER id="67043">
<NAME>Ashish</NAME>
<MONTH>March</MONTH>
<YEAR>2010</YEAR>
<SALARY>10077</SALARY>
</CUSTOMER>
</ROOT>

This is the xml file having data which i need to upload in talend MDM

Anonymous · ‎2011-01-20

Starting job Test at 14:49 20/01/2011.
connecting to socket on port 3851
connected
log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
Exception in component tMDMOutput_1_In
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
faultSubcode:
faultString: java.rmi.RemoteException
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.rmi.RemoteException
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 org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
disconnected
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.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:5405)
at honeymdm.test_0_1.Test.tFileInputXML_1Process(Test.java:2096)
at honeymdm.test_0_1.Test.runJobInTOS(Test.java:2309)
at honeymdm.test_0_1.Test.main(Test.java:2169)
{http://xml.apache.org/axis/}hostname:01HW278702.india.tcs.com
java.rmi.RemoteException
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 org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.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:5405)
at honeymdm.test_0_1.Test.tFileInputXML_1Process(Test.java:2096)
at honeymdm.test_0_1.Test.runJobInTOS(Test.java:2309)
at honeymdm.test_0_1.Test.main(Test.java:2169)

I am facing this error please help me out

here i have declare
root tag as root
its subelement as Customer_Records(which is the name of entity in Talend MDM)
its attribute as id

Anonymous · ‎2011-01-20

Hi honeybakliwal,
I don't know how your model is designed, but seeing the XML you posted above, the XML tree defined inside the tMDMOutput Component (try double clicking it) should be something like:

<CUSTOMER>
    <ID>3301</ID>
    <NAME>Rahul</NAME>
    <MONTH>Jan</MONTH>
    <YEAR>2010</YEAR>
    <SALARY>7000</SALARY>
</CUSTOMER>

As I stated, I don't know your model, but most certainly <ROOT> doesn't belong to your XML tree.
Hope it helps.
Best regards,
Diogo

Anonymous · ‎2011-01-21

I tried everything the above xml is my xml file that has to be parsed in tmdmoutput

i am facing this error again
Starting job Test at 12:02 21/01/2011.
connecting to socket on port 4018
connected
log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
Exception in component tMDMOutput_1_In
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
faultSubcode:
faultString: java.rmi.RemoteException
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.rmi.RemoteException
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 org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
disconnected
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.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:5405)
at honeymdm.test_0_1.Test.tFileInputXML_1Process(Test.java:2029)
at honeymdm.test_0_1.Test.runJobInTOS(Test.java:2242)
at honeymdm.test_0_1.Test.main(Test.java:2102)
{http://xml.apache.org/axis/}hostname:01HW278702.india.tcs.com
java.rmi.RemoteException
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 org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.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:5405)
at honeymdm.test_0_1.Test.tFileInputXML_1Process(Test.java:2029)
at honeymdm.test_0_1.Test.runJobInTOS(Test.java:2242)
at honeymdm.test_0_1.Test.main(Test.java:2102)
Job Test ended at 12:02 21/01/2011.

Anonymous · ‎2011-01-24

Please help me its really very urgent

Anonymous · ‎2011-01-25

I tried everything the above xml is my xml file that has to be parsed in tmdmoutput

Hi honeybakliwal,
You cannot output XML directly to tMDMOutput... You have to parse the XML, put it into output row, link it to tMDMOutput and then map it inside tMDMOutput (double click component) to the XML tree you defined on MDM model, without forgetting to set the loop element. tMDMOutput is not able to parse XML...
Best regards,
Diogo Afonso

Anonymous · ‎2011-03-31

Hi,
I just had the same problem but found the solution - hopefully this also helps you:
In the configuration of the XML tree in the tMDMOutput-component I just forgot to write the entities name (e. g. "Customer") instead of "rootTag" which is there by default!
Enjoy Talend!
Cheers

Problem loading MDM with tMDMOutput

mdm

Other