JDBC receiver channel process null vaules to database

[Former Member]

Hi Experts,

We are working on Proxy--->PI---->JDBC asynchronous communication in single stack PO 7.4 .

Here we are facing one issue we are not able to inbound payload in receiver communication channel monitoring level it showed outbound payload only and it pass the null values to database.

Please find the below screen shots on this.

Receiver side Datatype

Message mapping

PI Montoring

While doing the tracing we found below error and please below error link

file:///C:/Users/amarnadh/Desktop/server_7788550/xpi_traces.html

Please help me on this it's urgent.

Thanks,

Raju

[ravicarpenter · Accepted solution]

Hi,

Receiver structure is wrong. Please correct it..Action, table, access key all under ROW.

For readability purpose if you want, you can rename ROW to TBL_xxxx.

[Former Member · Accepted solution]

Hi Ravi,

Now it's working fine.

Thankyou yar........

Thanks,

Raju

[Former Member · Accepted solution]

Hi Ravi,

Please help me on this below thread.

Thanks,

Raju.