I tied with and without period, but what really did the trick was capitalization. It finally passed verification, and I am anxiously awaiting the results...
Thanks!
Bart
Thanks!
Bart
--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Example syntax for no-error:
>
> FIND FIRST Customer WHERE Customer.Company = CUR-COMP AND
> Customer.CustNum = ttShipTo.CustNum NO-LOCK NO-ERROR.
>
>
>
> You might be missing a period at the end of your statement, hard to tell
> the way these emails get reformatted.
>
>
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of bartsmit01
> Sent: Tuesday, March 13, 2012 9:42 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Server dies...
>
>
>
>
>
> I rewrote it to include a "if not available" option, since I did have
> the "If available" already (I think that is what you meant):
>
> For each ttrcvdtl where
> Ttrcvdtl.rowmod = "A" no-lock
>
> Find first part where
> Part.Company = cur-comp and
> Part.PartNum = Ttrcvdtl.partnum and
> Part.CheckBox04 = true no-lock
>
> If not available part then return.
>
> If avail part then do: xyz etc
>
> When I add the "No Error", (I place it right behind the "Part.CheckBox04
> = true no-lock"), I get an error after verifying: ** Unable to
> understand after -- "= A no-lock". (247)
> ** Line 20 --Invalid FOR, DO, REPEAT, or EDITING statement. (194).
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian Roberts" <broberts@> wrote:
> >
> > Add a "no-error" to your find first statement, and an "if available
> > Part" after it, to see if you found a valid part number. PO & receipts
> > can be for items not in the part master, this is causing the "FIND
> > FIRST/LAST failed for table Part" error.
> >
> >
> >
> > But that shouldn't be killing your BPM action process, no idea on
> that.
> >
> >
> >
> > Brian.
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of bartsmit01
> > Sent: Tuesday, March 13, 2012 9:00 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: BPM Server dies...
> >
> >
> >
> >
> >
> > Hm. Maybe I am on to something; in my BPM I do have the code:
> > For each ttrcvdtl where
> > Ttrcvdtl.rowmod = "A" no-lock:
> >
> > Find first part where
> > Part.Company = cur-comp and
> > Part.PartNum = Ttrcvdtl.partnum and
> > Part.CheckBox04 = true no-lock.
> >
> > If avail part then do: etc.
> >
> > I wonder if I my grammar is correct?
> >
> > Bart
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "bartsmit01" <bartsmit01@> wrote:
> > >
> > > I did find something in the server log. This entry keeps repeating
> and
> > doesn't stop until the BPM server "disappears":
> > >
> > > [12/03/12@23:32:21.336-0400] P-003496 T-003500 1 AS -- Exec4GlAction
> > Bpm/AsyncCall.p (c:\epicor\mfgsys803\Server\Bpm\AsyncCall.r) at line
> 922
> > > [12/03/12@23:32:21.336-0400] P-003496 T-003500 1 AS --
> > ProcessQueuedActions Bpm/BpmProcessAction.p
> > (c:\epicor\mfgsys803\Server\Bpm\BpmProcessAction.r) at line 4180
> > > [12/03/12@23:32:21.336-0400] P-003496 T-003500 1 AS --
> > Bpm/BpmProcessAction.p
> > (c:\epicor\mfgsys803\Server\Bpm\BpmProcessAction.r) at line 4084
> > > [12/03/12@23:32:21.336-0400] P-003496 T-003500 1 AS --
> agent/RunTask.p
> > (c:\epicor\mfgsys803\Server\agent\RunTask.r) at line 1607
> > > [12/03/12@23:32:22.805-0400] P-003496 T-003500 1 AS -- ** FIND
> > FIRST/LAST failed for table Part. (565)
> > > [12/03/12@23:32:22.805-0400] P-003496 T-003500 1 AS -- ** 4GL
> > Debug-Alert Stack Trace **
> > > [12/03/12@23:32:22.805-0400] P-003496 T-003500 1 AS -- -->
> > bpm_serialized_action
> > c:/epicor/mfgwrk803/708191691461753148144217219416781115117.p
> > (c:\epicor\mfgwrk803\708191691461753148144217219416781115117.p) at
> line
> > 4885
> > > [12/03/12@23:32:22.805-0400] P-003496 T-003500 1 AS --
> > Stub/stub_Receipt_Update.p
> > (c:\epicor\mfgsys803\bpm\Stub\stub_Receipt_Update.r) at line 4912
> > >
> > > Hopefully this means something to somebody? I am not sure what the
> "**
> > FIND FIRST/LAST failed for table Part" points to...
> > >
> > > Bart
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "bartsmit01" <bartsmit01@> wrote:
> > > >
> > > > Hello Group!
> > > >
> > > > Just wondering if anyone has seen this behavior before; BPM server
> > runs for a bit after restart, then dies. No error messages or logs: as
> > matter of fact c:/epicor/mfgwrk803/BPMAction.log disappears into thin
> > air after BPM Server stops running...
> > > >
> > > > Thanks for the input!
> > > >
> > > > Bart
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>