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 :)

 

SXMB_MONI at the receiver system's end: Blank Payload :(

 

 

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: <Table Name>.resultSet

                Document Namespace: urn:sap.com:jdbcAdapter

 

To find out these values, you can also open the Operation Mapping - > "Test" Tab and check the XML source code.

I hope this helps you while using JDBC adapter in PI 7.1 and prevents you from doing it the harder way [that I had to follow :(]...

All the best :)