Skip to Content
avatar image
Former Member

JDBC receiver channel process null vaules to database

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

pimon.JPG (161.1 kB)
null2.JPG (148.6 kB)
null1.JPG (216.4 kB)
sqlerror.JPG (89.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 15, 2016 at 06:48 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded