on 01-28-2015 3:35 PM
I dont see any error in the RWB for sender JDBC adapter apart from 'processed finished successfully' with Message ID link but it does not have any payload. Does it mean SQL query returned 0(zero) or NO rows? or JDBC connection/driver user name & pwd provided is not supporting any transaction. I neither see any errors also in ALL logs.
Unfortuantley I do not have access at DB level to cross verify and also I dont see any message arrived into Integration engine or message monitoring from AE.
Please suggest.
Experts - Any idea please on how can I identify the root cause?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vishnu,
This is a CC log when there are no records picked from the DB.
You will just see 'processing finished successfully'
This is an example of the CC log when there are records picked from the DB.
There will be an additional line that will state ' Message with ID <messageID> processed.
Since in your case, you do not see the additional line in the CC logs, I am pretty confident that there were no data picked by the PI channel during that polling instance.
Hope this information helped.
Regards,
Prajeet Jain
if you dont see message means it has been archived!
Did you try check the Audit log in the channel monitoring? or Get the message id from the channel log and search in SXMB_Moni to track the message in Integration Engine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Brhamma,
This is that there is not files to be picked.
When i haven't direct access to the DB i do another scenario SOAP - JDBC to let me to do SELECTs to the table, i do a XSL mapping that simply copies the input to the output. With SOAPui i do the XML-JDBC PI format directly to be passed to the JDBC receiver.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I dont think that I followed your suggestion anyhow but I cant play with it in prod. Just can anyone help/answer what happens When query returns Zero(0) rows? do we see error or success in PI? Please consider it an interview question though I'm NOT intenionally checking, as I badly need help
Hi Brahma,
Why dont you check the JDBC connectivity for Login errors.
http://<PIserver>:<JDBC port>/ftpjdbc/jdbc/db_conn_a.html
Put JDBC driver details. but you may have to enter UN and PW which you have entered in JDBC communication channel.
Thanks
Tharaka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
of course it's there in comm channel. All ports that you see in channels are proxies, So we cannot know how it was by passed to actual DB server? Anyhow I tried your URL (http://XXXX.XXX.com:1533/ftpjdbc/jdbc/db_conn_a.html) and getting a mesasge " Internet explorer cannot display the webpage" in IE.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.