JDBC Sender Config

[Former Member]

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.

Thanks,

Hari

[naveen_chichili · Accepted solution]

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.

Regards,

Naveen.

[Former Member · Accepted solution]

Thanks for the tips Naveen. I will take a look at the CC . I would have expected some kind of xml messages in PI even if the Graphical Mapping was not perfect. We wanted to make sure connection was good and PI could extract data with the configuration.

Will let you know.

[rajasekhar_reddy14 · Accepted solution]

Hi Hari,

First check in tables data available or not, if yes then monitor JDBC sender communication in Communication channel monitoring,

it will show the status and generates messaged id,if connection working between PI and Data base.

Regards,Raj

[baskar_gopalakrishnan2 · Accepted solution]

In addition to above, Please do the following..

a) Use outside PI testing using Toad or SQLPlus and check whether you are able to reach database using login credentials and more.

b) Also specify in the advance tab of sender jdbc adapter as below...

logSQLStatement true.

This is for adapter log tracing.