Data not posting in to Data base

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Check if any message is stuck in Integration Queues or not.

If any message is stuck there or not

Regards,

Younus

[Former Member]

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

[former_member208856]

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.

[former_member186158]

Is the XI jdbc service stopped?

Check it out in NWA for PI 7.1x system.

[naveen_chichili]

Hi JAM,

please check your JDBC Adapter might have locked. GO to Visual admin or NWA and unlock the JDBC adapter then all your JDBC channels will work perfectly.Also check adapter service $XIDBAD.JDBC2XI was locked

please go through the links provided:[Link1|;,[Link2|;,[Link3|;,[Link4|;

Thanks,

NAveen.

[markangelo_dihiansan]

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

[Former Member]

I have already monitoeed JDBC receiver communication channe,but it is not showing any Audit log message and pay load.

[baskar_gopalakrishnan2]

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.

[former_member463616]

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

[former_member472138]

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

[Former Member]

Target Data base system perfectly fine, problem coming from PI end only,

JDBC adapter not received data from messaging system,how to fix this problem

all other interfaces working perfectly fine, but only JDBC scenarios have problem.