Skip to Content
0

Proxy Report Data Stopped in Queue - Not Reaching SAP PI (7.5)

Jul 13, 2017 at 05:16 AM

67

avatar image

Hi Experts,

There is a Proxy-to-File (Async) scenario.The data generated by the reports from SE38,the ABAP queue (XBTS*Table) status when checked from SXI_MONITOR is showing as stopped.

After referring various blogs and SDN questions we tried the following from the ABAP side:

1)De-register and register the queue from sxmb_adm.

2)Clearing the queues from SMQ2.

3)Dump check in ECC.

From the PI side we checked the RFC destination in SM59 ,which is working fine(200 OK)

also we have cross checked whether we are using the appropriate Business System.

After doing all the above steps the messages are reaching SAP PI and getting stuck in ABAP queue.

Kindly suggest us some solution to overcome this problem.

P.S : Attached are the screenshots for reference.

screenshot1.png (87.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Prithviraj Rajpurohit Jul 13, 2017 at 08:42 AM
0

Hi Sreyas,

Try executing the LUW again to see if the queue gets processed.

You can schedule the report RSQIWKEX this will pick all the stuck entries and re-process them.

Try to clear the queues and then re-register the queue.

You can also try to debug the queue if that helps. (save the queue SMQ3 and try to debug it)

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded
Bhagya Nayanala Jul 13, 2017 at 05:52 AM
0

Hi

you can click on the Queue name and check the error details for more information related to struck messages.

Regards

Bhagya

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Following screenshots will give a glimpse of problem.. as there are no errors given by queue

error1st.png

Going into queue we see this,
error2.png

Following status with retry in the queue,
err0r3.png

Marked report is for our scenario as " transaction recorded" with any error.
err0r5.png

Last screenshot says transaction recorded for that particular executed report.

Help us find the error.

error1st.png (80.7 kB)
error2.png (52.3 kB)
err0r3.png (54.2 kB)
err0r5.png (129.3 kB)
0

Hi Bhagya ,
These are the screenshots of the queue.We are clueless about to how solve it as we are not facing any errors.

0

Hi Mohit

Could you please attach the screenshots.

I couldn't see the screenshots. I tried using a different browser too.

Regards

Bhagya

0

Hi Bhagya
Please click on link provided for respective images in above post.

Regards,
Mohit yadav

0
Bhagya Nayanala Jul 13, 2017 at 09:50 AM
0

Hi

From your screenshot, the messages are struck in the queue. You can move the failed message to SMQ3 through "Save LUW" and unlock the queue to allow the rest of the messages to pass through.

Regards

Bhagya

Share
10 |10000 characters needed characters left characters exceeded
Sreyas R Jul 14, 2017 at 06:03 AM
0

Hi All,

The problem got resolved after we cleared the queues in SMQ2.

Thanks you

Sreyas

Share
10 |10000 characters needed characters left characters exceeded