cancel
Showing results for 
Search instead for 
Did you mean: 

Help with removing messages from the adapter engine queues..?

Former Member
0 Kudos

During testing the jdbc adapter (which is extremely slow) we have got 90,000 messages sitting in the adapter queue (JDBC_http://sap.com/xi/XI/SystemRecv). These will take days and days to clear out. They are all sitting in status "to be delivered" while the 5 available java threads slowly process them.

Is there a way to delete these. I have found by disabling the comm channel the messages get set to system error status, but even this process takes a full day.

Surely there is a way to get in there and delete the messages from the queue?

Regards,

Jason.

Edited by: Jason Scott on Dec 4, 2008 1:43 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

dharamveer_gaur2
Active Contributor
0 Kudos
Former Member
0 Kudos

The standard message delete jobs will only delete messages that are in a "final" state, therefore they are no help here...

Former Member
0 Kudos

HI

Cancel them from RWB

Check this

Thanks

Gaurav

Former Member
0 Kudos

ha-ha... tried that of course... problem is there's over 90,000. It will take me forever. If I try to do 10,000 at a time the jsp for message montoring times-out.

Former Member
0 Kudos

Then Delete them from sap tables using ABAP

Thanks

Gaurav

Former Member
0 Kudos

The messages are in a queue in the jdbc receiver adapter in status "to be processed"..? How would I delete these from ABAP ???

Former Member
0 Kudos

HI Jason

First thing that can help in such situation is changing the EOIO for adapter engine

1. Call the following page: http://<host><port>/MessagingSystem/migration.jsp.

The migration status is Never started.

The system displays the logs that have their own event handler.

2. To start the change, choose Start Migration.

You cannot interrupt the change.

3. To update the display, choose Refresh Status.

With this Set up Archive and delete for adapter framework

http://help.sap.com/saphelp_nw04/helpdata/en/05/b1b740f83db533e10000000a155106/content.htm

Thanks

Gaurav

Former Member
0 Kudos

I'm not sure what you mean by this process... Are you saying that by following your instructions it will change all 90,000 message from to-be-delivered status to system error status so I can then delete them with the standard delete/archive jobs?

Former Member
0 Kudos

HI Jason

Yes you will be able to delete them. Default archive and delete job works with 24 hours timings. Once you set up these you can change the timings for this job.

Once you are able to remove 90,000 messages then change adapter framework property from EOIO so that like IE, AE can process messages in parallel as EO.

I think this can help you. I am also looking at this problem from yesterday. Check the discussion we were trying to solve this EOIO stuck problem in Unni' thread

I feel your problem is same. I have not tried this myself due to system unavailability.

Thanks

Gaurav