on 05-09-2013 12:52 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.