on 12-04-2008 12:43 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.