on 05-09-2011 12:13 PM
Hi Experts,
We have around 30 JDBC receiver interfaces, but suddently something gone wrong,
When i am posting data it is not going to data base, all pipe line steps executed correctlt and call adapter steps also called,but communication channel not received payload.
this is hapening for all of my interfaces.
anyone put some light on this.
Regards,
JAM
Hi,
The other solution to the problem can be to restart the java server nodes.
Pls try this as well.
If you investigations lead that
1. There are no issues at the database side.
2. No changes have happened either at the Database or in the PI server.
3. Even after Java Server node restarts, the issue does not get resolved.
I would suggest to go for a complete PI server restart.
Regards,
Younus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check if any message is stuck in Integration Queues or not.
If any message is stuck there or not
Regards,
Younus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Please go to nwa
Go to operation management, Systems, Start and stop.
Go to Java EE Services
Choose the service : XPI Adapter: JDBC
Check if it started. You are stop it and restart it
Regards
Monika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are working on Receiver JDBC, mean posting data in JDBC table using Receiver CC.
The data is not coming in CC Monitoring.
For Receiver JDBC, we are filling data in Message Mapping. check your Message Mapping for that Interface.
If the data is coming in CC Monitoring & you are not able to post that in JDBC table, check the error log & check you are able to ping the system from SAP PI System.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the XI jdbc service stopped?
Check it out in NWA for PI 7.1x system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
all pipe line steps executed correctlt and call adapter steps also called,but communication channel not received payload.
You are just looking into sxi_monitor. What you need to do is to look at the message at the adapter engine level/communication channel level. Go to RWB -> message monitoring or RWB -> component monitoring -> adapter engine -> communication channel monitoring. Let us know of the error.
Hope this helps,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Couple of quick things to do..
1) Are u getting any error such as No channel is registered or something.? If so jdbc drivers software might have corrupted. In this case channel would be gray color. If that is the case, you might have to re install jdbc drivers.
2) check the database USERNAME and PASSWORD? if the username and password changed recently, messages will not go through. Plus if adapter uses invalid login credentials three times or so, oracle will lock the user and after that communication will not go through.
3) In the Receiver adapter (JDBC) go to advanced tab and add parameter logSQLStatement and value is true. This will help to trace the log much better.
Hope that helps.
HI,
It seems to like your database server might be down at receiver side. Once again please check with Database Administrator.
Hope this helps to you.
Regards,
P.Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would ask you to restart the database once and see. Also are there any changes at database side or channel parameters?
Did you see recently any patches applied at SAP PI or even for db side?
Regards
Pothana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.