Skip to Content
Author's profile photo Former Member

Mystery of “Document Name & Namespace” Revealed : JDBC Adapter PI 7.1

In the past few days I have seen multiple posts on SDN that talks about the problem while creating Sender Communication Channel in PI 7.1. The problems that normally people face is that the Sender JDBC comm. channel picks up the records correctly from the database but these records do not get passed on to the receiver side. Even though the  Operation Mapping is fine.   *SXMB_MONI at the PI end*: Successfully fetches data from Database 🙂  image”   *SXMB_MONI at the receiver system’s end*: Blank Payload 🙁  image”  The most common problem behind this is due to the incorrect values provided to “Document Name” and “Document Namespace” while creating the Sender JDBC Comm Channel. The most astonishing part is the lack of documentation on the same which forced me to invest my time in writing this blog. Let me elaborate on this.  When we create the Sender JDBC Comm Channel, the “Document Name” is defaulted with “*resultSet*”. But if the Sender Interface has been created by using External Definition for importing the database table structure, these fields should be populated as below:    *Document Name*:                 *Document Namespace*:  image”  To find out these values, you can also open the Operation Mapping – > “Test” Tab and check the XML source code.image

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Helpful information.