Skip to Content
0

Inbound Queue being stuck in Schedule Status in SXMB_MONI

Sep 05, 2017 at 11:04 AM

375

avatar image
Former Member

Dear PI / ABAP / BASIS Experts,

Our scenario is JDBC - PI - PROXY(SAP ECC), we are facing issue at the QUEUE level in the ECC system. SAP PI is picking data from JDBC and is successfully able to process to ECC system. But when we are analyzing inbound queue (SMQ2) the messages are stuck in schedule status due to which SAP Inbound Proxy is getting same data again and again at some particular interval of time but in PI we have only one success message.

We are getting below error in the Queue:

SXMB_MONI Screen shot for Queue in Schedule status:

Error: Connection Closed (no data).

What might be the reason that the messages are going into Schedule status instead of going into Processed status.

Would be grateful for your replies.

Thanks and Regards

Deepak Soni

q1.png (9.4 kB)
q2.jpg (41.3 kB)
q3.jpg (18.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Sep 05, 2017 at 04:41 PM
0

Hi PI Experts / ABAP Developers ,

Greetings for the day ahead .

I am working as a ABAP Developer with the PI developer who has Posted about the Issue . When Consulted with Basis Person , it was Informed that the Queue is Registered and Active .

Inbound data payload doesnot have the data issue because , it successfully creates a QM notification through the BAPI which uses the Input data from Inbound Proxy .

The issue is such that , It again gives the same data as Input to the BAPI and again Creates the QM notification after some time interval 1-2 min and it continues . The Objective is to stop the Scheduling of this data from Inbound Queue .

Kindly provide some hints to solve the issue .

Would be grateful for your Replies .

Thanks and Rgds ,

Devendra Singh

SAP ABAP Developer

Share
10 |10000 characters needed characters left characters exceeded
Priyanka Anagani Sep 05, 2017 at 11:17 AM
0

Hi Deepak,

Did you check if the queue is registered and active in ECC. If not, please register it.

Also, double click on the green flag in your screenshot, it opens the inbound message in SXMB_MONI in ECC. Copy the inbound payload and try to debug the inbound proxy with this payload to ensure that there are no issues with data/proxy.

--Priyanka

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Priyanka / PI Experts / ABAP Developers ,

Greetings for the day ahead .

Thanks for the Reply . I am working as a ABAP Developer with the PI developer who has Posted about the Issue . When Consulted with Basis Person , it was Informed that the Queue is Registered and Active .

Inbound data payload doesnot have the data issue because , it successfully creates a QM notification through the BAPI which uses the Input data from Inbound Proxy .

The issue is such that , It again gives the same data as Input to the BAPI and again Creates the QM notification after some time interval 1-2 min and it continues . The Objective is to stop the Scheduling of this data from Inbound Queue .

Kindly provide some hints to solve the issue .

Would be grateful for your Replies .

Thanks and Rgds ,

Devendra Singh

SAP ABAP Developer

0
Former Member
Former Member

Thanks Priyanka, as suggested I have checked the Queue (XBTR*) that is register.

Refer snapshot Q4

And I have manually executed the payload that is also working fine.

Do I need to make any changes in Advance tab of sender JDBC channel under Transactional Isolation Level. As of now I have given value “Default”

Refer snapshot Q5

Would be grateful for your reply.

Regards

Deepak Soni

q4.jpg (53.3 kB)
q5.jpg (32.8 kB)
0
Raghuraman S Sep 06, 2017 at 10:55 AM
0

Can u check the data sent via proxy and debut, this seems to be an issue with the data sent via proxy.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Raghuraman ,

Thanks for the Reply . Data has been checked and there is no issue with the data .

Thanks and Rgds ,

Devendra Singh

SAP ABAP Developer

0