cancel
Showing results for 
Search instead for 
Did you mean: 

jdbc --> File scenario: Root Element Issue

Former Member
0 Kudos

Hello,

   When testing my mapping in PI 7.1 (NW 7.4) I get the error "Cannot create target element /ns0:MT_JDBCtoXML_Receiver/Customers. Values missing in queue context."

In the Message Mapping Test tool, if I use the source example it works:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_JDBCtoXML_Sender xmlns:ns0="http://ns_JDBCtoXML">

   <row>

      <CUSTOMER_ID>1234</CUSTOMER_ID>

      <ADRS_CITY_NAME>fgh</ADRS_CITY_NAME>

   </row>

</ns0:MT_JDBCtoXML_Sender>

However using the payload from moni it gives the previously mentioned error:

<?xml version="1.0" encoding="UTF-8"?>

<MT_JDBCtoXML_Sender>

<row>

  <CUSTOMER_ID>6434238</CUSTOMER_ID> <ADRS_CITY_NAME>TORONTO </ADRS_CITY_NAME>

</row>

</MT_JDBCtoXML_Sender>

If I replace this line: <MT_JDBCtoXML_Sender> with this line: <ns0:MT_JDBCtoXML_Sender xmlns:ns0="http://ns_JDBCtoXML">

and then the last line </MT_JDBCtoXML_Sender> with this line: </ns0:MT_JDBCtoXML_Sender>

it works.

So my mapping from field to field is correct, it is just the generation of the root element that seems to be the issue.  Can you please advise what I've setup incorrectly?

Thank you,

Jerry

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

It looks you have not maintained the document namespace in the sender JDBC channel configuration. Kindly check.

Former Member
0 Kudos

Thank you very much Ramkumar!  That was it!

Jerry

Answers (0)