Error Message on BPM

Try this instead of the Assign.

Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'FirmRelease', "NO").

This sample is used to set the OrderRel.FirmRelease field to False. You may want to comment out the message section to see if that is your error.

--- In vantage@yahoogroups.com, "Cathy" <cathy@...> wrote:
>
> I am still missing the correct syntax. My BPM lets me validate the code
> but, when I try testing - I get an "Unexpected error - see appserver logs."
>
>
>
> It does not even display the "Setting Checkbox to False" - when I comment
> out the Assign JobOper01 = False - it will loop through and display all the
> Operations.
>
>
>
> Any suggestions?
>
>
>
> Thank you -
>
>
>
> ****************************************************************************
> *************************************
>
>
>
> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox01 = False.
>
> End.
>
> End.
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> cathyattechnologicsys
> Sent: Monday, August 12, 2013 3:10 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Error Message on BPM
>
>
>
>
>
> Just shoot me - yes it is checkbox01.
>
> Now, I am getting an "Unexpected error - see appserver logs."
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@> wrote:
> >
> > You said checkbox= false... don't you mean checkbox01?
> > On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@>
> > wrote:
> >
> > > **
> > >
> > >
> > > I am writing a BPM - Data Directive - In Transaction on the Job
> Operation
> > > Table.
> > >
> > > I want to set checkbox01 to false on all operation when the operation
> > > complete checkbox is true and have a loop.
> > >
> > > The BPM is below but, I receive a message "checkbox matches multiple
> > > fields in JobOper. (3509)".
> > >
> > > It displays each record separately so, why can't it assign checkbox01 =
> > > false separately.
> > >
> > > What is the correct syntax? Your help is appreciated.
> > >
> > > ********************************************************************
> > >
> > > define variable vSubject as character no-undo.
> > >
> > > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
> =
> > > True no-lock.
> > >
> > > For each JobOper where ttJobOper.Company = JobOper.Company
> > > and ttJobOper.JobNum = JobOper.JobNum:
> > >
> > > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
> +
> > > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > > {lib/publishinfomsg.i &infomsg = vSubject} .
> > >
> > > Assign JobOper.checkbox01 = False.
> > >
> > > End.
> > >
> > > End.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I am writing a BPM - Data Directive - In Transaction on the Job Operation Table.

I want to set checkbox01 to false on all operation when the operation complete checkbox is true and have a loop.

The BPM is below but, I receive a message "checkbox matches multiple fields in JobOper. (3509)".

It displays each record separately so, why can't it assign checkbox01 = false separately.

What is the correct syntax? Your help is appreciated.

********************************************************************


define variable vSubject as character no-undo.

For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete = True no-lock.

For each JobOper where ttJobOper.Company = JobOper.Company
and ttJobOper.JobNum = JobOper.JobNum:



assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) + '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
{lib/publishinfomsg.i &infomsg = vSubject} .



Assign JobOper.checkbox = False.


End.


End.
You said checkbox= false... don't you mean checkbox01?
On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@...>
wrote:

> **
>
>
> I am writing a BPM - Data Directive - In Transaction on the Job Operation
> Table.
>
> I want to set checkbox01 to false on all operation when the operation
> complete checkbox is true and have a loop.
>
> The BPM is below but, I receive a message "checkbox matches multiple
> fields in JobOper. (3509)".
>
> It displays each record separately so, why can't it assign checkbox01 =
> false separately.
>
> What is the correct syntax? Your help is appreciated.
>
> ********************************************************************
>
> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox = False.
>
> End.
>
> End.
>
>
>


[Non-text portions of this message have been removed]
Just shoot me - yes it is checkbox01.

Now, I am getting an "Unexpected error - see appserver logs."

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> You said checkbox= false... don't you mean checkbox01?
> On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@...>
> wrote:
>
> > **
> >
> >
> > I am writing a BPM - Data Directive - In Transaction on the Job Operation
> > Table.
> >
> > I want to set checkbox01 to false on all operation when the operation
> > complete checkbox is true and have a loop.
> >
> > The BPM is below but, I receive a message "checkbox matches multiple
> > fields in JobOper. (3509)".
> >
> > It displays each record separately so, why can't it assign checkbox01 =
> > false separately.
> >
> > What is the correct syntax? Your help is appreciated.
> >
> > ********************************************************************
> >
> > define variable vSubject as character no-undo.
> >
> > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> > True no-lock.
> >
> > For each JobOper where ttJobOper.Company = JobOper.Company
> > and ttJobOper.JobNum = JobOper.JobNum:
> >
> > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > {lib/publishinfomsg.i &infomsg = vSubject} .
> >
> > Assign JobOper.checkbox01 = False.
> >
> > End.
> >
> > End.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
I am still missing the correct syntax. My BPM lets me validate the code
but, when I try testing - I get an "Unexpected error - see appserver logs."



It does not even display the "Setting Checkbox to False" - when I comment
out the Assign JobOper01 = False - it will loop through and display all the
Operations.



Any suggestions?



Thank you -



****************************************************************************
*************************************



define variable vSubject as character no-undo.

For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
True no-lock.

For each JobOper where ttJobOper.Company = JobOper.Company
and ttJobOper.JobNum = JobOper.JobNum:

assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
'' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
{lib/publishinfomsg.i &infomsg = vSubject} .

Assign JobOper.checkbox01 = False.

End.

End.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cathyattechnologicsys
Sent: Monday, August 12, 2013 3:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Error Message on BPM





Just shoot me - yes it is checkbox01.

Now, I am getting an "Unexpected error - see appserver logs."

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
>
> You said checkbox= false... don't you mean checkbox01?
> On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@...>
> wrote:
>
> > **
> >
> >
> > I am writing a BPM - Data Directive - In Transaction on the Job
Operation
> > Table.
> >
> > I want to set checkbox01 to false on all operation when the operation
> > complete checkbox is true and have a loop.
> >
> > The BPM is below but, I receive a message "checkbox matches multiple
> > fields in JobOper. (3509)".
> >
> > It displays each record separately so, why can't it assign checkbox01 =
> > false separately.
> >
> > What is the correct syntax? Your help is appreciated.
> >
> > ********************************************************************
> >
> > define variable vSubject as character no-undo.
> >
> > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
=
> > True no-lock.
> >
> > For each JobOper where ttJobOper.Company = JobOper.Company
> > and ttJobOper.JobNum = JobOper.JobNum:
> >
> > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
+
> > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > {lib/publishinfomsg.i &infomsg = vSubject} .
> >
> > Assign JobOper.checkbox01 = False.
> >
> > End.
> >
> > End.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Are your quotes off?

Brenda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Tuesday, August 13, 2013 12:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Error Message on BPM



I am still missing the correct syntax. My BPM lets me validate the code
but, when I try testing - I get an "Unexpected error - see appserver logs."

It does not even display the "Setting Checkbox to False" - when I comment
out the Assign JobOper01 = False - it will loop through and display all the
Operations.

Any suggestions?

Thank you -

****************************************************************************
*************************************

define variable vSubject as character no-undo.

For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
True no-lock.

For each JobOper where ttJobOper.Company = JobOper.Company
and ttJobOper.JobNum = JobOper.JobNum:

assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
'' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
{lib/publishinfomsg.i &infomsg = vSubject} .

Assign JobOper.checkbox01 = False.

End.

End.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
cathyattechnologicsys
Sent: Monday, August 12, 2013 3:10 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Error Message on BPM

Just shoot me - yes it is checkbox01.

Now, I am getting an "Unexpected error - see appserver logs."

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...<mailto:jose@...>> wrote:
>
> You said checkbox= false... don't you mean checkbox01?
> On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@...<mailto:cathy@...>>
> wrote:
>
> > **
> >
> >
> > I am writing a BPM - Data Directive - In Transaction on the Job
Operation
> > Table.
> >
> > I want to set checkbox01 to false on all operation when the operation
> > complete checkbox is true and have a loop.
> >
> > The BPM is below but, I receive a message "checkbox matches multiple
> > fields in JobOper. (3509)".
> >
> > It displays each record separately so, why can't it assign checkbox01 =
> > false separately.
> >
> > What is the correct syntax? Your help is appreciated.
> >
> > ********************************************************************
> >
> > define variable vSubject as character no-undo.
> >
> > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
=
> > True no-lock.
> >
> > For each JobOper where ttJobOper.Company = JobOper.Company
> > and ttJobOper.JobNum = JobOper.JobNum:
> >
> > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
+
> > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > {lib/publishinfomsg.i &infomsg = vSubject} .
> >
> > Assign JobOper.checkbox01 = False.
> >
> > End.
> >
> > End.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
What does the message log show for the error. You are assigning without locking the record.

I write messages to the appserver log instead of alerts in Data Directives.

Greg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
Sent: Tuesday, August 13, 2013 1:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Error Message on BPM



Are your quotes off?

Brenda

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Cathy
Sent: Tuesday, August 13, 2013 12:43 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Error Message on BPM

I am still missing the correct syntax. My BPM lets me validate the code
but, when I try testing - I get an "Unexpected error - see appserver logs."

It does not even display the "Setting Checkbox to False" - when I comment
out the Assign JobOper01 = False - it will loop through and display all the
Operations.

Any suggestions?

Thank you -

****************************************************************************
*************************************

define variable vSubject as character no-undo.

For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
True no-lock.

For each JobOper where ttJobOper.Company = JobOper.Company
and ttJobOper.JobNum = JobOper.JobNum:

assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
'' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
{lib/publishinfomsg.i &infomsg = vSubject} .

Assign JobOper.checkbox01 = False.

End.

End.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
cathyattechnologicsys
Sent: Monday, August 12, 2013 3:10 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Error Message on BPM

Just shoot me - yes it is checkbox01.

Now, I am getting an "Unexpected error - see appserver logs."

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...<mailto:jose@...<mailto:jose@...%3cmailto:jose@...>>> wrote:
>
> You said checkbox= false... don't you mean checkbox01?
> On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@...<mailto:cathy@...<mailto:cathy@...%3cmailto:cathy@...>>>
> wrote:
>
> > **
> >
> >
> > I am writing a BPM - Data Directive - In Transaction on the Job
Operation
> > Table.
> >
> > I want to set checkbox01 to false on all operation when the operation
> > complete checkbox is true and have a loop.
> >
> > The BPM is below but, I receive a message "checkbox matches multiple
> > fields in JobOper. (3509)".
> >
> > It displays each record separately so, why can't it assign checkbox01 =
> > false separately.
> >
> > What is the correct syntax? Your help is appreciated.
> >
> > ********************************************************************
> >
> > define variable vSubject as character no-undo.
> >
> > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
=
> > True no-lock.
> >
> > For each JobOper where ttJobOper.Company = JobOper.Company
> > and ttJobOper.JobNum = JobOper.JobNum:
> >
> > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
+
> > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > {lib/publishinfomsg.i &infomsg = vSubject} .
> >
> > Assign JobOper.checkbox01 = False.
> >
> > End.
> >
> > End.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
Sometimes i find it useful to use an "If Available [table] Then Do:" when assigning some values. You might want to try that.






define variable vSubject as character no-undo.

For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
True no-lock.

For each JobOper where ttJobOper.Company = JobOper.Company
and ttJobOper.JobNum = JobOper.JobNum:

If Available JobOper Then Do:

assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
'' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
{lib/publishinfomsg.i &infomsg = vSubject} .

Assign JobOper.checkbox01 = False.

End.

End.


--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> What does the message log show for the error. You are assigning without locking the record.
>
> I write messages to the appserver log instead of alerts in Data Directives.
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
> Sent: Tuesday, August 13, 2013 1:54 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Error Message on BPM
>
>
>
> Are your quotes off?
>
> Brenda
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Cathy
> Sent: Tuesday, August 13, 2013 12:43 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Error Message on BPM
>
> I am still missing the correct syntax. My BPM lets me validate the code
> but, when I try testing - I get an "Unexpected error - see appserver logs."
>
> It does not even display the "Setting Checkbox to False" - when I comment
> out the Assign JobOper01 = False - it will loop through and display all the
> Operations.
>
> Any suggestions?
>
> Thank you -
>
> ****************************************************************************
> *************************************
>
> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox01 = False.
>
> End.
>
> End.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
> cathyattechnologicsys
> Sent: Monday, August 12, 2013 3:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Error Message on BPM
>
> Just shoot me - yes it is checkbox01.
>
> Now, I am getting an "Unexpected error - see appserver logs."
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@<mailto:jose@<mailto:jose@%3cmailto:jose@>>> wrote:
> >
> > You said checkbox= false... don't you mean checkbox01?
> > On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@<mailto:cathy@<mailto:cathy@%3cmailto:cathy@>>>
> > wrote:
> >
> > > **
> > >
> > >
> > > I am writing a BPM - Data Directive - In Transaction on the Job
> Operation
> > > Table.
> > >
> > > I want to set checkbox01 to false on all operation when the operation
> > > complete checkbox is true and have a loop.
> > >
> > > The BPM is below but, I receive a message "checkbox matches multiple
> > > fields in JobOper. (3509)".
> > >
> > > It displays each record separately so, why can't it assign checkbox01 =
> > > false separately.
> > >
> > > What is the correct syntax? Your help is appreciated.
> > >
> > > ********************************************************************
> > >
> > > define variable vSubject as character no-undo.
> > >
> > > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
> =
> > > True no-lock.
> > >
> > > For each JobOper where ttJobOper.Company = JobOper.Company
> > > and ttJobOper.JobNum = JobOper.JobNum:
> > >
> > > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
> +
> > > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > > {lib/publishinfomsg.i &infomsg = vSubject} .
> > >
> > > Assign JobOper.checkbox01 = False.
> > >
> > > End.
> > >
> > > End.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>
I did try the IF Available and still get the error.

The quotes are OK - when I comment out the Assign Checkbox01 - it runs through the loop.

I don't know the syntax for writing the message to the appserver log.

Would you please send a sample. I am sure the way I program it will come in handy.

Thanks All



--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> What does the message log show for the error. You are assigning without locking the record.
>
> I write messages to the appserver log instead of alerts in Data Directives.
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
> Sent: Tuesday, August 13, 2013 1:54 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Error Message on BPM
>
>
>
> Are your quotes off?
>
> Brenda
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Cathy
> Sent: Tuesday, August 13, 2013 12:43 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Error Message on BPM
>
> I am still missing the correct syntax. My BPM lets me validate the code
> but, when I try testing - I get an "Unexpected error - see appserver logs."
>
> It does not even display the "Setting Checkbox to False" - when I comment
> out the Assign JobOper01 = False - it will loop through and display all the
> Operations.
>
> Any suggestions?
>
> Thank you -
>
> ****************************************************************************
> *************************************
>
> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox01 = False.
>
> End.
>
> End.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
> cathyattechnologicsys
> Sent: Monday, August 12, 2013 3:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Error Message on BPM
>
> Just shoot me - yes it is checkbox01.
>
> Now, I am getting an "Unexpected error - see appserver logs."
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@<mailto:jose@<mailto:jose@%3cmailto:jose@>>> wrote:
> >
> > You said checkbox= false... don't you mean checkbox01?
> > On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@<mailto:cathy@<mailto:cathy@%3cmailto:cathy@>>>
> > wrote:
> >
> > > **
> > >
> > >
> > > I am writing a BPM - Data Directive - In Transaction on the Job
> Operation
> > > Table.
> > >
> > > I want to set checkbox01 to false on all operation when the operation
> > > complete checkbox is true and have a loop.
> > >
> > > The BPM is below but, I receive a message "checkbox matches multiple
> > > fields in JobOper. (3509)".
> > >
> > > It displays each record separately so, why can't it assign checkbox01 =
> > > false separately.
> > >
> > > What is the correct syntax? Your help is appreciated.
> > >
> > > ********************************************************************
> > >
> > > define variable vSubject as character no-undo.
> > >
> > > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
> =
> > > True no-lock.
> > >
> > > For each JobOper where ttJobOper.Company = JobOper.Company
> > > and ttJobOper.JobNum = JobOper.JobNum:
> > >
> > > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
> +
> > > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > > {lib/publishinfomsg.i &infomsg = vSubject} .
> > >
> > > Assign JobOper.checkbox01 = False.
> > >
> > > End.
> > >
> > > End.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>
Try with Standard directive instead of In-Transaction.
Â
Regards,
Arul
Â

________________________________
From: cathyattechnologicsys <cathy@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 14 August 2013 4:37 AM
Subject: [Vantage] Re: Error Message on BPM


Â

I did try the IF Available and still get the error.

The quotes are OK - when I comment out the Assign Checkbox01 - it runs through the loop.

I don't know the syntax for writing the message to the appserver log.

Would you please send a sample. I am sure the way I program it will come in handy.

Thanks All

--- In mailto:vantage%40yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> What does the message log show for the error. You are assigning without locking the record.
>
> I write messages to the appserver log instead of alerts in Data Directives.
>
> Greg
>
> From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of brenda mohr
> Sent: Tuesday, August 13, 2013 1:54 PM
> To: mailto:vantage%40yahoogroups.com
> Subject: RE: [Vantage] Re: Error Message on BPM
>
>
>
> Are your quotes off?
>
> Brenda
>
> From: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Cathy
> Sent: Tuesday, August 13, 2013 12:43 PM
> To: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Error Message on BPM
>
> I am still missing the correct syntax. My BPM lets me validate the code
> but, when I try testing - I get an "Unexpected error - see appserver logs."
>
> It does not even display the "Setting Checkbox to False" - when I comment
> out the Assign JobOper01 = False - it will loop through and display all the
> Operations.
>
> Any suggestions?
>
> Thank you -
>
> ****************************************************************************
> *************************************
>
> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox01 = False.
>
> End.
>
> End.
>
> From: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
> cathyattechnologicsys
> Sent: Monday, August 12, 2013 3:10 PM
> To: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Error Message on BPM
>
> Just shoot me - yes it is checkbox01.
>
> Now, I am getting an "Unexpected error - see appserver logs."
>
> --- In mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@<mailto:jose@<mailto:jose@%3cmailto:jose@>>> wrote:
> >
> > You said checkbox= false... don't you mean checkbox01?
> > On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@<mailto:cathy@<mailto:cathy@%3cmailto:cathy@>>>
> > wrote:
> >
> > > **
> > >
> > >
> > > I am writing a BPM - Data Directive - In Transaction on the Job
> Operation
> > > Table.
> > >
> > > I want to set checkbox01 to false on all operation when the operation
> > > complete checkbox is true and have a loop.
> > >
> > > The BPM is below but, I receive a message "checkbox matches multiple
> > > fields in JobOper. (3509)".
> > >
> > > It displays each record separately so, why can't it assign checkbox01 =
> > > false separately.
> > >
> > > What is the correct syntax? Your help is appreciated.
> > >
> > > ********************************************************************
> > >
> > > define variable vSubject as character no-undo.
> > >
> > > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
> =
> > > True no-lock.
> > >
> > > For each JobOper where ttJobOper.Company = JobOper.Company
> > > and ttJobOper.JobNum = JobOper.JobNum:
> > >
> > > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
> +
> > > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > > {lib/publishinfomsg.i &infomsg = vSubject} .
> > >
> > > Assign JobOper.checkbox01 = False.
> > >
> > > End.
> > >
> > > End.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
You need to Exclusive lock the table to write to it.

> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete => True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum exclusive-lock:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox01 = False.
>
> End.
>
> End.






________________________________
From: cathyattechnologicsys <cathy@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 13, 2013 1:37 PM
Subject: [Vantage] Re: Error Message on BPM



Â
I did try the IF Available and still get the error.

The quotes are OK - when I comment out the Assign Checkbox01 - it runs through the loop.

I don't know the syntax for writing the message to the appserver log.

Would you please send a sample. I am sure the way I program it will come in handy.

Thanks All

--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> What does the message log show for the error. You are assigning without locking the record.
>
> I write messages to the appserver log instead of alerts in Data Directives.
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
> Sent: Tuesday, August 13, 2013 1:54 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Error Message on BPM
>
>
>
> Are your quotes off?
>
> Brenda
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Cathy
> Sent: Tuesday, August 13, 2013 12:43 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Error Message on BPM
>
> I am still missing the correct syntax. My BPM lets me validate the code
> but, when I try testing - I get an "Unexpected error - see appserver logs."
>
> It does not even display the "Setting Checkbox to False" - when I comment
> out the Assign JobOper01 = False - it will loop through and display all the
> Operations.
>
> Any suggestions?
>
> Thank you -
>
> ****************************************************************************
> *************************************
>
> define variable vSubject as character no-undo.
>
> For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> True no-lock.
>
> For each JobOper where ttJobOper.Company = JobOper.Company
> and ttJobOper.JobNum = JobOper.JobNum:
>
> assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> {lib/publishinfomsg.i &infomsg = vSubject} .
>
> Assign JobOper.checkbox01 = False.
>
> End.
>
> End.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
> cathyattechnologicsys
> Sent: Monday, August 12, 2013 3:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Error Message on BPM
>
> Just shoot me - yes it is checkbox01.
>
> Now, I am getting an "Unexpected error - see appserver logs."
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@<mailto:jose@<mailto:jose@%3cmailto:jose@>>> wrote:
> >
> > You said checkbox= false... don't you mean checkbox01?
> > On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@<mailto:cathy@<mailto:cathy@%3cmailto:cathy@>>>
> > wrote:
> >
> > > **
> > >
> > >
> > > I am writing a BPM - Data Directive - In Transaction on the Job
> Operation
> > > Table.
> > >
> > > I want to set checkbox01 to false on all operation when the operation
> > > complete checkbox is true and have a loop.
> > >
> > > The BPM is below but, I receive a message "checkbox matches multiple
> > > fields in JobOper. (3509)".
> > >
> > > It displays each record separately so, why can't it assign checkbox01 =
> > > false separately.
> > >
> > > What is the correct syntax? Your help is appreciated.
> > >
> > > ********************************************************************
> > >
> > > define variable vSubject as character no-undo.
> > >
> > > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
> =
> > > True no-lock.
> > >
> > > For each JobOper where ttJobOper.Company = JobOper.Company
> > > and ttJobOper.JobNum = JobOper.JobNum:
> > >
> > > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
> +
> > > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > > {lib/publishinfomsg.i &infomsg = vSubject} .
> > >
> > > Assign JobOper.checkbox01 = False.
> > >
> > > End.
> > >
> > > End.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
Message "This will show up in the server log".

Even before making that change what error previously showed up in the server log? It is located in the server/logs directory on your server running Epicor.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "cathyattechnologicsys" <cathy@...> wrote:
>
> I did try the IF Available and still get the error.
>
> The quotes are OK - when I comment out the Assign Checkbox01 - it runs through the loop.
>
> I don't know the syntax for writing the message to the appserver log.
>
> Would you please send a sample. I am sure the way I program it will come in handy.
>
> Thanks All
>
>
>
> --- In vantage@yahoogroups.com, Greg Payne <gpayne@> wrote:
> >
> > What does the message log show for the error. You are assigning without locking the record.
> >
> > I write messages to the appserver log instead of alerts in Data Directives.
> >
> > Greg
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
> > Sent: Tuesday, August 13, 2013 1:54 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: Error Message on BPM
> >
> >
> >
> > Are your quotes off?
> >
> > Brenda
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Cathy
> > Sent: Tuesday, August 13, 2013 12:43 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Re: Error Message on BPM
> >
> > I am still missing the correct syntax. My BPM lets me validate the code
> > but, when I try testing - I get an "Unexpected error - see appserver logs."
> >
> > It does not even display the "Setting Checkbox to False" - when I comment
> > out the Assign JobOper01 = False - it will loop through and display all the
> > Operations.
> >
> > Any suggestions?
> >
> > Thank you -
> >
> > ****************************************************************************
> > *************************************
> >
> > define variable vSubject as character no-undo.
> >
> > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete =
> > True no-lock.
> >
> > For each JobOper where ttJobOper.Company = JobOper.Company
> > and ttJobOper.JobNum = JobOper.JobNum:
> >
> > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq) +
> > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > {lib/publishinfomsg.i &infomsg = vSubject} .
> >
> > Assign JobOper.checkbox01 = False.
> >
> > End.
> >
> > End.
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
> > cathyattechnologicsys
> > Sent: Monday, August 12, 2013 3:10 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Error Message on BPM
> >
> > Just shoot me - yes it is checkbox01.
> >
> > Now, I am getting an "Unexpected error - see appserver logs."
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Jose
> > Gomez <jose@<mailto:jose@<mailto:jose@%3cmailto:jose@>>> wrote:
> > >
> > > You said checkbox= false... don't you mean checkbox01?
> > > On Aug 12, 2013 5:50 PM, "cathyattechnologicsys" <cathy@<mailto:cathy@<mailto:cathy@%3cmailto:cathy@>>>
> > > wrote:
> > >
> > > > **
> > > >
> > > >
> > > > I am writing a BPM - Data Directive - In Transaction on the Job
> > Operation
> > > > Table.
> > > >
> > > > I want to set checkbox01 to false on all operation when the operation
> > > > complete checkbox is true and have a loop.
> > > >
> > > > The BPM is below but, I receive a message "checkbox matches multiple
> > > > fields in JobOper. (3509)".
> > > >
> > > > It displays each record separately so, why can't it assign checkbox01 =
> > > > false separately.
> > > >
> > > > What is the correct syntax? Your help is appreciated.
> > > >
> > > > ********************************************************************
> > > >
> > > > define variable vSubject as character no-undo.
> > > >
> > > > For Each ttJobOper where ttJobOper.rowmod = 'U' and ttJobOper.OpComplete
> > =
> > > > True no-lock.
> > > >
> > > > For each JobOper where ttJobOper.Company = JobOper.Company
> > > > and ttJobOper.JobNum = JobOper.JobNum:
> > > >
> > > > assign vSubject = "Setting Checkbox to False " + string(joboper.OprSeq)
> > +
> > > > '' + joboper.OpDesc + "Job Oper Complete " + string(joboper.OpComplete).
> > > > {lib/publishinfomsg.i &infomsg = vSubject} .
> > > >
> > > > Assign JobOper.checkbox01 = False.
> > > >
> > > > End.
> > > >
> > > > End.
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ________________________________
> > CONFIDENTIALITY NOTICE
> >
> > The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
> >
> > "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
> >
> >
> > [Non-text portions of this message have been removed]
> >
>