SWEQSRV hanging, events stuck "In Process"

[Mike Gambier]

Hi Gav,
 
Personally I would ask your Basis guys to check the Workflow settings in SWU3 again. Things like an expired WF User password can sometimes cause issues like this.
 
Are there any feedback messages in the tRFC entries in ARFCSSTATE for WORKFLOW_LOCAL_0100?
 
Does SMQ2 have anything useful to say?
 
Are these events for the same Workflow/Task? If so does everything compile, buffers dropped etc etc?
 
Also on the subject of Event processing have you enabled Parallel processing? If so check your Server Group settings too.
 
Be advised that SAP are currently testing OSS Note 1079021 with us that should prevent the same errored Workflow step from being processed twice by consecutive Restart Temporary Exceptions (RSWWERRE) job runs.
 
The note also introduces a flexible 'hang-up' time variable that can be passed through from the RSWWERRE variant to expand or reduce the step selection in terms of processing date/time. Quite why they didn't make this a config setting in SWEQADM or SWWD though I don't know.
 
I have heard that ERP 2006 has altered the way these jobs schedule themselves which is good news by the way. But I don't know yet whether they have bothered to build in proper event database locking which would also be useful (somehow I doubt they'll bother).
 
Regards,
 
Mike GT
> Subject: RE: SWEQSRV hanging, events stuck "In Process"> Date: Thu, 20 Dec 2007 13:50:25 +0800> From: jocelyn.dart at sap.com> To: sap-wug at mit.edu; sap-wug at mit.edu> > Gavin, > Rather than reduce the number of events raised at one time, it might be better to put a bit more of a gap between each block of events. > > Generally SAP recommends at least 3 minutes between individual runs of repeating batch jobs. > > Just gives the system a chance to sort out all the peripheral stuff around locking, job queues, etc. It could be the job is getting deadlocked. > > After all if you are raising 12000 events, then spreading it out over half an hour gives everyone else using the system a chance to get there work donw. > Regards,> Jocelyn.> > ________________________________> > From: sap-wug-bounces at mit.edu on behalf of Gavin Mooney> Sent: Thu 20/12/2007 9:23 AM> To: SAP Workflow Users' Group> Subject: SWEQSRV hanging, events stuck "In Process"> > > > Hi everyone,> > In our performance test (of a real scenario) we've noticed a problem> with the event queue job. Around 12,000 events are raised and go into> the queue. The job is set to process 200 at a time, each minute. The> app server seems able to handle this quite happily and finishes> processing the batch of 200 after about 20 seconds. Then, next minute,> another 200 events are processed. We see the system use a load of> background processes to deliver the events and then these processes> free up again. Fine.> > After a few cycles of reading the queue and processing events the job> hangs. SWEQADM says that 200 events are in process (and their status> is indeed "in process") but from SM66/SM50 we can see that they are> not actually being processed. There is just one (dialog) process> active which has status On Hold with reason RFC. This process stays On> Hold until we cancel the job. No short dumps and the RFC queues are> also empty. We tried reducing the number of events processed per> minute but the job still hangs.> > We're on WAS 700, level 9.> > I'd be very interested to know if anyone else has had a similar problem.> > Regards,> Gavin> _______________________________________________> SAP-WUG mailing list> SAP-WUG at mit.edu> http://mailman.mit.edu/mailman/listinfo/sap-wug> > > > _______________________________________________> SAP-WUG mailing list> SAP-WUG at mit.edu> http://mailman.mit.edu/mailman/listinfo/sap-wug
_________________________________________________________________
Who's friends with who and co-starred in what?
http://www.searchgamesbox.com/celebrityseparation.shtml
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20071220/b251c38d/attachment.htm