Skip to Content
0
Jan 17, 2011 at 03:26 AM

Issue in Synchronous JDBC Receiver: Unknown payload format 0 in message

297 Views

Hello Experts,

I'd like to consult with you an issue which has been recurring in our JDBC Receiver, which is Unknown payload format 0 in message. Our scenario is like this:

SAP (Synch Abap Proxy) < > PI < > (Synch JDBC) DB

We are using XML SQL for our JDBC Receiver. With the following structure:

<?xml version="1.0" encoding="UTF-8"?>
<ns1:SourceMT xmlns:ns1="http://sourcenamespace.com">
   <stmt>
      <query action="SQL_QUERY">
         <access>SELECT SKILLID, SKILLTYPEID FROM SKILL</access>
      </query>
   </stmt>
</ns1:Source_MT>

Now the problem is, if we execute the Abap proxy the first time. The SQL query will timeout, but the subsequent executions will not (they will be processed successfully). Here is the log from MDT:

2011-01-17 03:13:48 Information Delivering to channel: CC_JDBC_Receiver 
2011-01-17 03:13:48 Information JDBC Adapter Receiver processing started, required QoS BestEffort 
2011-01-17 03:16:48 Error Synchronous timeout exceeded. 
2011-01-17 03:16:48 Error The message status was set to FAIL. 

The simple SQL statement was not even executed.

Any inputs will be greatly appreciated.

Regards,

Mark