Skip to Content
avatar image
Former Member

Namespace issue in Sender JDBC message

Hi All,

My scenario is pulling data from Oracle DB(3rd party) and pushing it to SAP ECC system. Here I am using the table metadata in the form of an External Definition.I am directly using this ED in my message mapping and service interface. I am able to test the mapping locally, when I run the scenario the target message type is generated but the main element node inside is automatically suppressed. The structure examples are given as below(been taken from message mapping test tab):

Source

<?xml version="1.0" encoding="UTF-8"?>
<ns0:TABLE_NAME.resultSet xmlns:ns0="urn:sap.com:jdbcAdapter">
   <row>
      <A/>
      <BV/>
    </row>
</ns0:TABLE_NAME.resultSet>

Target:

<?xml version="1.0" encoding="UTF-8"?>
<MT_Inbound>
   <Main_Node>
      <X/>
      <Y/>
   </Main_Node>
</MT_Inbound>

I guess the problem is with the namespace and prefix which is coming along with the table metadata(ns0). I tried removing it by XML AnonymizerBean module in my sender JDBC channel but this did not solve the purpose.

Request you all to help in solving this.

Thanks in Advance

Lalitkumar.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 10, 2011 at 10:29 AM

    Hi Lalitkumar,

    Remove the XML Namespace in the source message type. Even though it is removed, the mapping will work. No need to worry about it.

    Thanks,

    Edited by: Hareenkumar on Feb 10, 2011 11:33 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2011 at 07:27 AM

    >>>>>>>>>> I guess the problem is with the namespace and prefix

    Yes, you are true. This happens if you don't give namespace in the sender (JDBC) channel. Generally people use to ignore it since it is not mandt.

    So, namespace must be provided for the Document(Message type) in channel.

    Note:This was the case for me.

    Regards

    Pothana

    Add comment
    10|10000 characters needed characters exceeded