[OAUGNet]-Re: URGENT! - Issue with Workflow Background process

["Benhur, Daniel" <Daniel_Benhur@pas-technologies.com>]

Mike,

We don't know what is happening during that time, that is what we are trying to find out and with a Sev1 P1 SR with On Demand for almost a month and doing everything what they are asking, still don't have a clue about the cause.  The problem is, this is happening mostly during the last week of the month when our production is busy and lot of OM Transactions occur during this time.

Being an On Demand customer we are very limited to what we can do, when it started happening, we used to terminate the long running WBP request and call On Demand and have them kill the Session. But this is very time consuming, by the time we can get hold of someone to kill the session it may be too late and delay our invoicing.

Thanks for your suggestion regarding finding the blocking locks, do you have a script which we can use to get the blocking locks. I tried with some
scripts from metalink, but didn't find anything to resolve our issue.

Any suggestions is greatly appreciated.

Benhur.

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Mike Charchuk
Sent: Wednesday, August 27, 2008 4:32 PM
To: OAUG Net listserver
Subject: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process

Is your workflow actually processing during the long runs or is it
waiting for a lock to be cleared.  We have had some OE forms users
blocking our OEOH and OEOL workflows on a regular basis.  I have a
blocking locks job that runs every 10 minutes or so to check for
blocking locks.  If an OE form is blocking the workflow we attempt to
contact the user to get out of the form and if we can't contact them we
typically kill their forms session.  I also have a jobs that checks to
see if a workflow has been running for more than 5 minutes, which has
proven to be usefull.

Benhur, Daniel wrote:
> Based on the completion of the prior run.
>
> -----Original Message-----
> From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Burriack, Gillian
> Sent: Wednesday, August 27, 2008 3:59 PM
> To: OAUG Net listserver
> Subject: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process
>
> Did you schedule it to run based on the completion of the prior run or
> based on the start of the prior run?
>
> -----Original Message-----
> From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of
> McRaney, Ronald
> Sent: Wednesday, August 27, 2008 4:53 PM
> To: OAUG Net listserver
> Subject: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process
>
> Daniel,
> You might take a look at the http://blogs.oracle.com for some ideas.  I
> found this article from Gaurav Verma interesting enough dealing with
> some ONT customizations.  Look through it and might help,
> http://blogs.oracle.com/gverma/2008/03/when_conventional_thinking_fai_1.
> html
>
> Good Luck,
> Ron
>
> -----Original Message-----
> From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Benhur,
> Daniel
> Sent: Wednesday, August 27, 2008 1:28 PM
> To: OAUG Net listserver
> Subject: [OAUGNet]-URGENT! - Issue with Workflow Background process
>
> Hello,
>
> We are recently experiencing performance problem with Workflow
> background process and its taking anywhere between 5 mins to more than
> an hour to complete. During this time the Auto invoice program is
> getting stuck and delaying our Invoicing process. We have been going
> back and forth with Oracle support on this and so far no solution to
> this even with a Sev1 P1 SR.
>
> This is specific to Order management and the workflow we are concerned
> is the OEOL(Order lines) and the parameters are deferred 'Yes', Time
> out' No and Stuck "No'. We scheduled it to run every 2 mins(we scheduled
> it for every 5 mins as per development recommendation but no
> difference).
>
> Any suggestions or ideas regarding where to look and what might be
> causing this. We haven't customized the standard OEOL workflow at all.
>
> Thanks,
> Daniel Benhur
> PAS Technologies
> 1234 North Kansas City, MO 64116
> P: 816 556 5122
> C: 816 804 2876
> www.pas-technologies.com
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
> list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED
> mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
> DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX
> mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
> list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED
> mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
> DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX
> mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
> Send administrative queries to  <OAUGNet-request@oaug.com>
>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
> Send administrative queries to  <OAUGNet-request@oaug.com>
>
>
>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>