cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Updates via PI interface using JDBC connection

Former Member
0 Kudos

Hello,

I am having scenario where in SQL table gets updated from PI via JDBC connection. In PI monitoring it shows processing status as Successful but no updates in SQL. any suggestions where I can cross check steps one by one.

Thanks,

A Pat.

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

hi,

1. you can turn the logging on in the JDBC channel to see the real SQL statement (logsqlstatement)

2. you can turn the logging on your DB - to see what is happening

in 99,9% of cases this is enough to get the issue solved,

Regards,

Michal Krawczyk

Former Member
0 Kudos

Ho do I switch on logging, can you please send me steps to go for logging.

Thanks.

former_member184720
Active Contributor
0 Kudos

Hi Pat - Can you check the SAP  #Note 801367 - XI 3.0 JDBC Adapter: Additional Parameters."

under the additional parameters you need to add "logsqlstatement" and set this to true so that you can see how the SQL statements are being formed and how they are being executing in the audit log.

Regards,

Hareesh

Answers (2)

Answers (2)

rajasekhar_reddy14
Active Contributor
0 Kudos
Former Member
0 Kudos

Next, where can I find log detail's is this same as in Monitoring --> Trace?

Thanks, A Pat.

former_member184720
Active Contributor
0 Kudos

open the corresponding message in adapter engine and go to audit log.

Here you can find the SQL query and the status of each query..

Former Member
0 Kudos

Can you send me exact steps to folllow to cross check this.

Thanks., A Pat.

former_member184720
Active Contributor
0 Kudos

go to run time work bench -> message monitoring-> adapter engine->database-> give the required details(sender interface/receiver interface details)-> execute->

if there are any messages processed for that interface then it'll display the messages.

select any of the message->open->on the top you should be having three tabs->go to audit log-> here you should be able to see the logged information.

Regards,

Hareesh

allamudi_loordh
Active Participant
0 Kudos

Hi ,

what is the action that you gave. Can you please check the receiver jdbc structure properly. please check the jdbc receiver structures in help.sap.

Check the status of communication channel if you see any errors.

Regards,

Loordh