Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Problem loading MDM with tMDMOutput from CSV transform to XML

Hi everyone,
I'm posting here because i'm starting to loose my hair on this one.
My objective is simply to get a file (CSV format) and to load it on my local MDM server.
There is my Flow which had a better look when i started my job last week :

What is working :
1. tMDMConnection
2. tFileInputDelimited
Then i'm not successing to put my soap request succesfully with my 3 little records using tMDMOutput.
My CSV file :
id, societeFact, ciPublic
"id1", "Triadis Services", 3
"id2", "test", 2
"id3", "testrr", 42345
My XML output :
<Commande>
  <id>"id1"</id>
  <societeFact>"Triadis Services"</societeFact>
  <ciPublic>3</ciPublic>
</Commande>
<Commande>
  <id>"id2"</id>
  <societeFact>"test"</societeFact>
  <ciPublic>2</ciPublic>
</Commande>
<Commande>
  <id>"id3"</id>
  <societeFact>"testrr"</societeFact>
  <ciPublic>42345</ciPublic>
</Commande>
There is the start of my error message :
Exception in component tMDMOutput_1
AxisFault
 faultCode: {}Server
 faultSubcode: 
 faultString: Unable to parse document to save.; nested exception is: 
java.lang.RuntimeException: java.lang.RuntimeException: Unable to parse document to save.
 faultActor: 
 faultNode: 
If someone could provide any help/tips to solve my issue, it would be great!
If you need me to give you anything else to troubleshoot, it would be my pleasure 0683p000009MACn.png
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Very active forum.. I resolve the issue by myself. Happy Holiday