Skip to Content
0

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

May 07 at 08:58 AM

42

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Anuj Dulta May 08 at 01:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded