Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Sender Config

The scenario is JDBC to IDOC using Graphical Mapping in PI 7.1

I am looking at extracting data from a view in sql server into PI to make sure that data can be extracted into PI. In the ESR the DT , MT , MI and OM has been definied.

In the Integration directory the configuration has been done correctly and the SQL Query and Update statement looks like below.

Select Query Statement : SELECT * FROM view

Update Statement: <test>

The Sender CC is active but I cannot see any xml messages in PI ?? At this point I would have expected records to be fixed by PI.

Please advice.



Former Member
Former Member replied

Hi Hari,

I hope you are not able to see your message id in your communication channel.

1. check if you are able to ping/connect from your pi server.

2. check if you have provided correct user credentials in your channel

3. Check if there are any locks on your JDBC adapter service in visual admin

4. Finally try restarting JDBC adapter service in Visual admin.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question