Processing Started in JDBC communication Channel?

[former_member190681]

Dear Friends,

in JDBC Sender Channel i am facing one issue, i.e the data coming from DB but in PI/PO 7.4 data is not reached and channel is showing Green color and log is showing processing started. But as per my experience may the data is locked in server level. PI 7.0 for this type of issues we are deleted the locks in adapter level in visual admin. but 7.4 version is not having Visual Administrator. Please suggest how to resolve this issue in sap pi 7.4?

Note: Previously it is working fine.

please find the screen shots for your reference.

Regards,

Kiran Polani

[Former Member · Accepted solution]

Hi,

Restart the java stack. Should resolve the issue.

Regards,

Jannus Botha

[former_member190681 · Accepted solution]

Dear Friends,

i seen ur answers, but if it is production that is not possible to take restart ther server, for this visual administrator -->adapter locks i deleted db locks previously in pi 7.0 but i need solution for 7.4.

2) http://hostname:port/nwa/locks as suggested by naveeen, for this type of issue dblocks are not available in this url location.

and i have check this also no use and stoped communication channel and started so many times no use and maintained DIsconnect from Database after processing each message in channel level

Regards,

Kiran Polani

[Former Member · Accepted solution]

Hi,

Please go to NWA. Go to your search field on the top left. Type in locks.

It will return Java Locks. Select it.

Then it will take you to where all the locks are.

Remove the problem lock.

Regards,

Jannus Botha

[former_member190681 · Accepted solution]

Dear Janus,

i am not able to see locks in nwa/locks in sap pi 7.4 but in communication channel it is showing processing started.

please suggest any other solution for it.

Regards,

Kiran Polani

[iaki_vila · Accepted solution]

Hi Polani,

Have you tried from here?:

Regards

[former_member190681 · Accepted solution]

Dear,

i checked that DBlocks, but i was not found any loks there.

when i restarted java stack, that channel is working and second way, when i created new channel it is working. but that is not the solution for me.

please suggest me for solution for this.

Regards,

Kiran Polani

[Former Member · Accepted solution]

Hi

How are you searching the locks in nwa/locks?? I hope you are searching in Lock Argument column with channel ID.

The lock will have $XIDBAD.JDBC2XI and channel ID in its name.

Regards

Osman

[former_member190681 · Accepted solution]

Dear friends,

kindly suggest for resolve my issue.

Regards,

Kiran Polani

[naveen_chichili · Accepted solution]

Hi Kiran,

Could you please check the query at DB level if you are able to fetch the records from the table in DB.

Regards,

Naveen

[former_member184720 · Accepted solution]

Try restarting the XPI Adapter: JDBC service from NWA. It should work.

http://host:port/nwa/start-stop

[Former Member]

Hi,

As you mentioned, this is happening because of adapter lock. Try doing JDBC adapter restart alone, if it doesn't hep you may need to bounce the JAVA stack to fix this.

Regards,

Deepak R

[iaki_vila]

Hi Polani,

Also the lock problem you can check if there is really data to be retrieved.

Regards.

[naveen_chichili]

Hi Kiran,

Go to NWA http://hostname:port/nwa/locks and delete the locks and also did you try "DIsconnect from Database after processing each message" SAP Note:831162

Thanks,

Naveen