jdbc adapter stuck

[Former Member]

Hi All:

We are facing problems with the JDBC adapter, for unknown reason the JDBC Adapter stuck and do not pick the table entries. The only way to fix the issue is

- copy sender JDBC adapter

- rename sender JDBC adapter

- change old sender JDBC adapter on Sender agreement

and I know that this is not a good solution.

We are using SAP PI 7.1 and connecting into Oracle database.

Any of you are facing the same problem? What do you do to fix the issue?

Warm Regards,

PM

[Former Member]

There are two possible causes.

1) Adapter locks in PI. Logic into NWA. go to Resource Monitoring and then go to locks. Delete JDBC locks if there are any.

2) Open session in the database which you are trying to connect. please ask your DBA to kill all open session with the user what you are trying to connect.

make sure you stop the communication channel before you do the above activities.Once done, please restart them.

[naveen_chichili]

Hi,

Are you facing the problem with the single channel or all the JDBC channels?

Try restarting the JDBC Adapter service in visual admin(PI 7.0)or from NWA (PI 7.1)and then you would be able to process the messages.

Regards,

Naveen.

[Former Member]

When you face this problem, check the locking adapter and [see if there are any stuck locks|http://sapnwnewbie.blogspot.com/2011/05/sap-xi-jdbc-communication-channels-not.html] related to the channel. If you see JDBC lock stuck for a long time, stop the channel, delete that lock and start it again. For a permanent fix, apply the patch indicated in SAP note 1510659.