Skip to Content

SAP PI 7.5 JDBC SENDER ADAPTER - NOT ALL COLUMNS ARE GETTING READ by PI

Hi All,

I am working on one JDBC<-->PI<-->SAP scenario.

What seems to be happening is that only transaction ID (one of the primary key) is getting READ from the Table, and rest of the fields are coming as BLANK in PI. I have created the structure similar to what I am SELECTING.

If I run the SELECT query directly in SQL Developer, all the relevant columns are getting selected.

I am using the SELECT statement directly in the Channel.

Attached the Channel, and ESR objects screen prints

Channel polling result in PI:

<?xml version="1.0" encoding="UTF-8"?> <ns1:ZPO_UPD_NM_ORDER xmlns:ns1="urn:sap-com:document:sap:rfc:functions">

<NM_ORDER>

<item> <TRANSACTION_ID>25511576</TRANSACTION_ID>

<ORDER_NUMBER/>

<ORDER_LINE_NO/> //NOT FILLED with DB VALUES

<STATUS/>

<MESSAGE/>

</item> </NM_ORDER>

</ns1:ZPO_UPD_NM_ORDER>

esr-mt.jpg (39.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 08 at 01:25 PM

    Hi All,

    I think I found the issue, but not sure how to fix it. PI is able to SELECT 'transaction_id' since it is of type 'NUMBER', all rest are of type VARCHAR2. IF I read any other column OTHER THAN VARCHAR2, I am able to fetch that in PI. Can anyone suggest what data type should be used to read VARCHAR2, given the fact that STRING is not working. ..

    Any help would be much appreciated...

    p.s. Database in use is Oracle

    Many Thanks!

    Regards,

    Anuj

    Add comment
    10|10000 characters needed characters exceeded