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.
Naveen Kumar Reddy chichili replied
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.