Event Queue

[Bibby, David]

Thanks Mike.
The intention was to only have the workflow trigger once.
The first trigger causes the workflow to add an entry to the table. All
other events then do not trigger because before triggering the event a
check is made to see if the entry already exists.
Because they are happening so close together that's why (I think) this
is happening.
It didn't happen yesterday, but I optimized the code and now it's
running faster this is happening.

Thanks for your suggestions, I will look into those.
Regards
David 

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Mike Pokraka
Sent: 06 April 2006 18:06
To: SAP Workflow Users' Group
Subject: Re: Event Queue

Au contraire! Switching on the event queue will compound your problem.
Instead of a couple of flows triggering within a few seconds, the queue
will collect all events in a minute and then fire them all off together.

Though if you are looking for an urgent *short term fix* it *might*
help to switch it on in synchronous sequential processing mode (intended
more for dev/testing purposes). This contradicts it's intended purpose
of optimizing performance in high volume scenarios, thus should not
normally be a productive setting.

If you are trying to control a single WF start from multiple events, it
might help to move the testing/checking into a check FM. Also look at
using an enqueue lock - if it can't get a lock then wait a few seconds
and repeat the check.

Cheers
Mike

Bibby, David wrote:
> All,
> I have a problem and wonder if switching theevent queue on would solve

> the problem.
> The problem is the symptom is only happening in our production system.
>
> An event is triggering multiple times simultaneously. The first thing 
> the workflow does is check if an entry exists in a table, if it 
> doesn't it adds the entry.
>
> We are getting the situation where the subsequent workflows check that

> table see that the entry does not exist and then try to insert that 
> entry, in the meantime the entry has been inserted, so the workflow 
> goes into error.
> My question is, if I switch on the event queue will this stagger the 
> event triggers or will it just delay the problem?
>
> Many Thanks
> David
>
>
> _______________________________________________
> This message is confidential. It may also be privileged or otherwise 
> protected by work product immunity or other legal rules. If you have 
> received it by mistake please let us know by reply and then delete it 
> from your system; you should not copy it or disclose its contents to
anyone.
> All messages sent to and from Linklaters may be monitored to ensure 
> compliance with internal policies and to protect our business. Emails 
> are not secure and cannot be guaranteed to be error free as they can 
> be intercepted, amended, lost or destroyed, or contain viruses. Anyone

> who communicates with us by email is taken to accept these risks.
>
> The contents of any email addressed to our clients are subject to our 
> usual terms of business; anything which does not relate to the 
> official business of the firm is neither given nor endorsed by it.
>
> The registered address of the UK partnership of Linklaters is One Silk

> Street, London, EC2Y 8HQ. Please refer to 
> http://www.linklaters.com/regulation for important information on the 
> regulatory position of the firm.
>
>
> _______________________________________________
> 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