4GL query from JobHead BPM

system · May 31, 2016, 7:25pm

Only workaround I see is to write an external .p file, then create a 4GL action that forwards to it.

system · December 26, 2008, 3:44pm

Hello All,

I am trying to run a query from the JobEntry.Update Object/Method on
a
Preprocessing BPM trigger. I am using the "design query is less
than" approach for the condition. Here is my query:

For each ttJobHead where ( ttJobHead.RowMod = 'A' or ttJobHead.RowMod
= 'U' ) no-lock.
Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum AND
PartRev.RevisionNum = ttJobHead.RevisionNum.
End

The query checks out OK in the Method Directives tool but when I run
it I get the following error:
-------------------
Exception caught in: Epicor.Mfg.BO.JobEntry

Error Detail
============
Message: The field ttJobHead.AnalysisCdDescription does not have a
valid data type.
Type: Error
Program: bo/DynamicQuery.p
Method: buildTempTable
Table: SelectedField
Row:
Field:

Stack Trace
===========
at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
-------------------------------

Can anyone point me in the right direction?

What I am trying to accomplish is to read the part rev table for the
related part number and check off a VB field in JobHead to reference
on the traveler.

Thanks,
Ross

system · December 26, 2008, 4:12pm

Hello Mark:

I would like to make a couple of suggestions:
- Do not use no-lock if you plan on updating the ttjobhead record
- Always use a no-error at the end of a find statement and then use
if available for additional processing
- Always use the company field in a find statement for integrity and
speed
- Make sure code is continuous - the normal Progress structure has
end statements on its own line

For each ttjobhead where ttjobhead.rowmod = "A" or ttjobhead.rowmod = "u",
first parrev where partrev.company = ttjobhead.company and
partrev.revisionnum = ttjobread.partnum and partrev.partrev =
ttjobhead.revisionnum.

Add logic inside.
End.

Carl Peterson

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Friday, December 26, 2008 3:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL query from JobHead BPM

Hello All,

I am trying to run a query from the JobEntry.Update Object/Method on
a
Preprocessing BPM trigger. I am using the "design query is less
than" approach for the condition. Here is my query:

For each ttJobHead where ( ttJobHead.RowMod = 'A' or ttJobHead.RowMod
= 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum AND
PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If available partrev
then do: add logic end.
End

The query checks out OK in the Method Directives tool but when I run
it I get the following error:
-------------------
Exception caught in: Epicor.Mfg.BO.JobEntry

Error Detail
============
Message: The field ttJobHead.AnalysisCdDescription does not have a
valid data type.
Type: Error
Program: bo/DynamicQuery.p
Method: buildTempTable
Table: SelectedField
Row:
Field:

Stack Trace
===========
at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
-------------------------------

Can anyone point me in the right direction?

What I am trying to accomplish is to read the part rev table for the
related part number and check off a VB field in JobHead to reference
on the traveler.

Thanks,
Ross

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

system · December 26, 2008, 4:35pm

Thank you much for the suggestions, Carl.

I updated the code to the following and am still getting the same
error.

-----------------------
for each ttJobHead where
ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
First PartRev WHERE partrev.Company = ttJobHead.Company AND
PartRev.PartNum = ttJobHead.PartNum AND
PartRev.RevisionNum = ttJobHead.RevisionNum.
End.
----------------------

I tried it as a PRE and a POST but get the same results.

Thanks,
Ross

--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> Hello Mark:
>
> I would like to make a couple of suggestions:
> - Do not use no-lock if you plan on updating the ttjobhead
record
> - Always use a no-error at the end of a find statement and
then use
> if available for additional processing
> - Always use the company field in a find statement for
integrity and
> speed
> - Make sure code is continuous - the normal Progress
structure has
> end statements on its own line
>
> For each ttjobhead where ttjobhead.rowmod = "A" or ttjobhead.rowmod
= "u",
> first parrev where partrev.company = ttjobhead.company and
> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> ttjobhead.revisionnum.
>
> Add logic inside.
> End.
>
> Carl Peterson
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ross Hughes
> Sent: Friday, December 26, 2008 3:44 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] 4GL query from JobHead BPM
>
> Hello All,
>
> I am trying to run a query from the JobEntry.Update Object/Method
on
> a
> Preprocessing BPM trigger. I am using the "design query is less
> than" approach for the condition. Here is my query:
>
> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
ttJobHead.RowMod
> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum AND
> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If available
partrev
> then do: add logic end.
> End
>
> The query checks out OK in the Method Directives tool but when I
run
> it I get the following error:
> -------------------
> Exception caught in: Epicor.Mfg.BO.JobEntry
>
> Error Detail
> ============
> Message: The field ttJobHead.AnalysisCdDescription does not have a
> valid data type.
> Type: Error
> Program: bo/DynamicQuery.p
> Method: buildTempTable
> Table: SelectedField
> Row:
> Field:
>
> Stack Trace
> ===========
> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> -------------------------------
>
> Can anyone point me in the right direction?
>
> What I am trying to accomplish is to read the part rev table for
the
> related part number and check off a VB field in JobHead to
reference
> on the traveler.
>
> Thanks,
> Ross
>
>
>
> [Non-text portions of this message have been removed]
>

system · December 26, 2008, 4:35pm

Thank you much for the suggestions, Carl.

I updated the code to the following and am still getting the same
error.

-----------------------
for each ttJobHead where
ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
First PartRev WHERE partrev.Company = ttJobHead.Company AND
PartRev.PartNum = ttJobHead.PartNum AND
PartRev.RevisionNum = ttJobHead.RevisionNum.
End.
----------------------

I tried it as a PRE and a POST but get the same results.

Thanks,
Ross

--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> Hello Mark:
>
> I would like to make a couple of suggestions:
> - Do not use no-lock if you plan on updating the ttjobhead
record
> - Always use a no-error at the end of a find statement and
then use
> if available for additional processing
> - Always use the company field in a find statement for
integrity and
> speed
> - Make sure code is continuous - the normal Progress
structure has
> end statements on its own line
>
> For each ttjobhead where ttjobhead.rowmod = "A" or ttjobhead.rowmod
= "u",
> first parrev where partrev.company = ttjobhead.company and
> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> ttjobhead.revisionnum.
>
> Add logic inside.
> End.
>
> Carl Peterson
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ross Hughes
> Sent: Friday, December 26, 2008 3:44 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] 4GL query from JobHead BPM
>
> Hello All,
>
> I am trying to run a query from the JobEntry.Update Object/Method
on
> a
> Preprocessing BPM trigger. I am using the "design query is less
> than" approach for the condition. Here is my query:
>
> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
ttJobHead.RowMod
> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum AND
> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If available
partrev
> then do: add logic end.
> End
>
> The query checks out OK in the Method Directives tool but when I
run
> it I get the following error:
> -------------------
> Exception caught in: Epicor.Mfg.BO.JobEntry
>
> Error Detail
> ============
> Message: The field ttJobHead.AnalysisCdDescription does not have a
> valid data type.
> Type: Error
> Program: bo/DynamicQuery.p
> Method: buildTempTable
> Table: SelectedField
> Row:
> Field:
>
> Stack Trace
> ===========
> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> -------------------------------
>
> Can anyone point me in the right direction?
>
> What I am trying to accomplish is to read the part rev table for
the
> related part number and check off a VB field in JobHead to
reference
> on the traveler.
>
> Thanks,
> Ross
>
>
>
> [Non-text portions of this message have been removed]
>

system · December 26, 2008, 7:29pm

Just a WAG but the error message would seem to indicate a problem
with the table : field structure

what version of Vantage are you using and what db SQL or Progress?

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Thank you much for the suggestions, Carl.
>
> I updated the code to the following and am still getting the same
> error.
>
> -----------------------
> for each ttJobHead where
> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
> First PartRev WHERE partrev.Company = ttJobHead.Company AND
> PartRev.PartNum = ttJobHead.PartNum AND
> PartRev.RevisionNum = ttJobHead.RevisionNum.
> End.
> ----------------------
>
> I tried it as a PRE and a POST but get the same results.
>
> Thanks,
> Ross
>
> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@> wrote:
> >
> > Hello Mark:
> >
> > I would like to make a couple of suggestions:
> > - Do not use no-lock if you plan on updating the ttjobhead
> record
> > - Always use a no-error at the end of a find statement and
> then use
> > if available for additional processing
> > - Always use the company field in a find statement for
> integrity and
> > speed
> > - Make sure code is continuous - the normal Progress
> structure has
> > end statements on its own line
> >
> > For each ttjobhead where ttjobhead.rowmod = "A" or
ttjobhead.rowmod
> = "u",
> > first parrev where partrev.company = ttjobhead.company and
> > partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> > ttjobhead.revisionnum.
> >
> > Add logic inside.
> > End.
> >
> > Carl Peterson
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Ross Hughes
> > Sent: Friday, December 26, 2008 3:44 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] 4GL query from JobHead BPM
> >
> > Hello All,
> >
> > I am trying to run a query from the JobEntry.Update Object/Method
> on
> > a
> > Preprocessing BPM trigger. I am using the "design query is less
> > than" approach for the condition. Here is my query:
> >
> > For each ttJobHead where ( ttJobHead.RowMod = 'A' or
> ttJobHead.RowMod
> > = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
AND
> > PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
available
> partrev
> > then do: add logic end.
> > End
> >
> > The query checks out OK in the Method Directives tool but when I
> run
> > it I get the following error:
> > -------------------
> > Exception caught in: Epicor.Mfg.BO.JobEntry
> >
> > Error Detail
> > ============
> > Message: The field ttJobHead.AnalysisCdDescription does not have
a
> > valid data type.
> > Type: Error
> > Program: bo/DynamicQuery.p
> > Method: buildTempTable
> > Table: SelectedField
> > Row:
> > Field:
> >
> > Stack Trace
> > ===========
> > at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> > at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> > at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> > -------------------------------
> >
> > Can anyone point me in the right direction?
> >
> > What I am trying to accomplish is to read the part rev table for
> the
> > related part number and check off a VB field in JobHead to
> reference
> > on the traveler.
> >
> > Thanks,
> > Ross
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

system · December 27, 2008, 12:22am

Progress and 8.03.407.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Friday, December 26, 2008 6:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 4GL query from JobHead BPM

Just a WAG but the error message would seem to indicate a problem
with the table : field structure

what version of Vantage are you using and what db SQL or Progress?

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Thank you much for the suggestions, Carl.
>
> I updated the code to the following and am still getting the same
> error.
>
> -----------------------
> for each ttJobHead where
> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
> First PartRev WHERE partrev.Company = ttJobHead.Company AND
> PartRev.PartNum = ttJobHead.PartNum AND
> PartRev.RevisionNum = ttJobHead.RevisionNum.
> End.
> ----------------------
>
> I tried it as a PRE and a POST but get the same results.
>
> Thanks,
> Ross
>
> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@> wrote:
> >
> > Hello Mark:
> >
> > I would like to make a couple of suggestions:
> > - Do not use no-lock if you plan on updating the ttjobhead
> record
> > - Always use a no-error at the end of a find statement and
> then use
> > if available for additional processing
> > - Always use the company field in a find statement for
> integrity and
> > speed
> > - Make sure code is continuous - the normal Progress
> structure has
> > end statements on its own line
> >
> > For each ttjobhead where ttjobhead.rowmod = "A" or
ttjobhead.rowmod
> = "u",
> > first parrev where partrev.company = ttjobhead.company and
> > partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> > ttjobhead.revisionnum.
> >
> > Add logic inside.
> > End.
> >
> > Carl Peterson
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Ross Hughes
> > Sent: Friday, December 26, 2008 3:44 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] 4GL query from JobHead BPM
> >
> > Hello All,
> >
> > I am trying to run a query from the JobEntry.Update Object/Method
> on
> > a
> > Preprocessing BPM trigger. I am using the "design query is less
> > than" approach for the condition. Here is my query:
> >
> > For each ttJobHead where ( ttJobHead.RowMod = 'A' or
> ttJobHead.RowMod
> > = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
AND
> > PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
available
> partrev
> > then do: add logic end.
> > End
> >
> > The query checks out OK in the Method Directives tool but when I
> run
> > it I get the following error:
> > -------------------
> > Exception caught in: Epicor.Mfg.BO.JobEntry
> >
> > Error Detail
> > ============
> > Message: The field ttJobHead.AnalysisCdDescription does not have
a
> > valid data type.
> > Type: Error
> > Program: bo/DynamicQuery.p
> > Method: buildTempTable
> > Table: SelectedField
> > Row:
> > Field:
> >
> > Stack Trace
> > ===========
> > at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> > at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> > at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> > -------------------------------
> >
> > Can anyone point me in the right direction?
> >
> > What I am trying to accomplish is to read the part rev table for
> the
> > related part number and check off a VB field in JobHead to
> reference
> > on the traveler.
> >
> > Thanks,
> > Ross
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · December 27, 2008, 7:45am

Just tried a simple BPM to show message on Update method - I received
same error. My suggestion would be to contact support. I beleive the
BO is flawed.

Good Luck.

-bw

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Progress and 8.03.407.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> bw2868bond
> Sent: Friday, December 26, 2008 6:29 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: 4GL query from JobHead BPM
>
> Just a WAG but the error message would seem to indicate a problem
> with the table : field structure
>
> what version of Vantage are you using and what db SQL or Progress?
>
> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >
> > Thank you much for the suggestions, Carl.
> >
> > I updated the code to the following and am still getting the same
> > error.
> >
> > -----------------------
> > for each ttJobHead where
> > ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
> > First PartRev WHERE partrev.Company = ttJobHead.Company AND
> > PartRev.PartNum = ttJobHead.PartNum AND
> > PartRev.RevisionNum = ttJobHead.RevisionNum.
> > End.
> > ----------------------
> >
> > I tried it as a PRE and a POST but get the same results.
> >
> > Thanks,
> > Ross
> >
> > --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
wrote:
> > >
> > > Hello Mark:
> > >
> > > I would like to make a couple of suggestions:
> > > - Do not use no-lock if you plan on updating the
ttjobhead
> > record
> > > - Always use a no-error at the end of a find statement
and
> > then use
> > > if available for additional processing
> > > - Always use the company field in a find statement for
> > integrity and
> > > speed
> > > - Make sure code is continuous - the normal Progress
> > structure has
> > > end statements on its own line
> > >
> > > For each ttjobhead where ttjobhead.rowmod = "A" or
> ttjobhead.rowmod
> > = "u",
> > > first parrev where partrev.company = ttjobhead.company and
> > > partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> > > ttjobhead.revisionnum.
> > >
> > > Add logic inside.
> > > End.
> > >
> > > Carl Peterson
> > >
> > >
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> > Behalf Of
> > > Ross Hughes
> > > Sent: Friday, December 26, 2008 3:44 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] 4GL query from JobHead BPM
> > >
> > > Hello All,
> > >
> > > I am trying to run a query from the JobEntry.Update
Object/Method
> > on
> > > a
> > > Preprocessing BPM trigger. I am using the "design query is less
> > > than" approach for the condition. Here is my query:
> > >
> > > For each ttJobHead where ( ttJobHead.RowMod = 'A' or
> > ttJobHead.RowMod
> > > = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
> AND
> > > PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
> available
> > partrev
> > > then do: add logic end.
> > > End
> > >
> > > The query checks out OK in the Method Directives tool but when
I
> > run
> > > it I get the following error:
> > > -------------------
> > > Exception caught in: Epicor.Mfg.BO.JobEntry
> > >
> > > Error Detail
> > > ============
> > > Message: The field ttJobHead.AnalysisCdDescription does not
have
> a
> > > valid data type.
> > > Type: Error
> > > Program: bo/DynamicQuery.p
> > > Method: buildTempTable
> > > Table: SelectedField
> > > Row:
> > > Field:
> > >
> > > Stack Trace
> > > ===========
> > > at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> > > at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> > > at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> > > -------------------------------
> > >
> > > Can anyone point me in the right direction?
> > >
> > > What I am trying to accomplish is to read the part rev table
for
> > the
> > > related part number and check off a VB field in JobHead to
> > reference
> > > on the traveler.
> > >
> > > Thanks,
> > > Ross
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>

system · December 27, 2008, 10:44am

Thanks a lot for trying this.

I will contact support on Monday morning.

Ross

On Dec 27, 2008, at 6:45 AM, "bw2868bond" <bwalker@...>
wrote:

> Just tried a simple BPM to show message on Update method - I received
> same error. My suggestion would be to contact support. I beleive the
> BO is flawed.
>
> Good Luck.
>
> -bw
>
> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>>
>> Progress and 8.03.407.
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
>> bw2868bond
>> Sent: Friday, December 26, 2008 6:29 PM
>> To: vantage@yahoogroups.com
>> Subject: [Vantage] Re: 4GL query from JobHead BPM
>>
>> Just a WAG but the error message would seem to indicate a problem
>> with the table : field structure
>>
>> what version of Vantage are you using and what db SQL or Progress?
>>
>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
>>>
>>> Thank you much for the suggestions, Carl.
>>>
>>> I updated the code to the following and am still getting the same
>>> error.
>>>
>>> -----------------------
>>> for each ttJobHead where
>>> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
>>> First PartRev WHERE partrev.Company = ttJobHead.Company AND
>>> PartRev.PartNum = ttJobHead.PartNum AND
>>> PartRev.RevisionNum = ttJobHead.RevisionNum.
>>> End.
>>> ----------------------
>>>
>>> I tried it as a PRE and a POST but get the same results.
>>>
>>> Thanks,
>>> Ross
>>>
>>> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
> wrote:
>>>>
>>>> Hello Mark:
>>>>
>>>> I would like to make a couple of suggestions:
>>>> - Do not use no-lock if you plan on updating the
> ttjobhead
>>> record
>>>> - Always use a no-error at the end of a find statement
> and
>>> then use
>>>> if available for additional processing
>>>> - Always use the company field in a find statement for
>>> integrity and
>>>> speed
>>>> - Make sure code is continuous - the normal Progress
>>> structure has
>>>> end statements on its own line
>>>>
>>>> For each ttjobhead where ttjobhead.rowmod = "A" or
>> ttjobhead.rowmod
>>> = "u",
>>>> first parrev where partrev.company = ttjobhead.company and
>>>> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
>>>> ttjobhead.revisionnum.
>>>>
>>>> Add logic inside.
>>>> End.
>>>>
>>>> Carl Peterson
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> On
>>> Behalf Of
>>>> Ross Hughes
>>>> Sent: Friday, December 26, 2008 3:44 PM
>>>> To: vantage@yahoogroups.com
>>>> Subject: [Vantage] 4GL query from JobHead BPM
>>>>
>>>> Hello All,
>>>>
>>>> I am trying to run a query from the JobEntry.Update
> Object/Method
>>> on
>>>> a
>>>> Preprocessing BPM trigger. I am using the "design query is less
>>>> than" approach for the condition. Here is my query:
>>>>
>>>> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
>>> ttJobHead.RowMod
>>>> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
>> AND
>>>> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
>> available
>>> partrev
>>>> then do: add logic end.
>>>> End
>>>>
>>>> The query checks out OK in the Method Directives tool but when
> I
>>> run
>>>> it I get the following error:
>>>> -------------------
>>>> Exception caught in: Epicor.Mfg.BO.JobEntry
>>>>
>>>> Error Detail
>>>> ============
>>>> Message: The field ttJobHead.AnalysisCdDescription does not
> have
>> a
>>>> valid data type.
>>>> Type: Error
>>>> Program: bo/DynamicQuery.p
>>>> Method: buildTempTable
>>>> Table: SelectedField
>>>> Row:
>>>> Field:
>>>>
>>>> Stack Trace
>>>> ===========
>>>> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
>>>> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
>>>> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
>>>> -------------------------------
>>>>
>>>> Can anyone point me in the right direction?
>>>>
>>>> What I am trying to accomplish is to read the part rev table
> for
>>> the
>>>> related part number and check off a VB field in JobHead to
>>> reference
>>>> on the traveler.
>>>>
>>>> Thanks,
>>>> Ross
>>>>
>>>>
>>>>
>>>> [Non-text portions of this message have been removed]
>>>>
>>>
>>
>>
>>
>> ------------------------------------
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have
>> already linked your email address to a yahoo id to enable access. )
>> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and
>> Crystal Reports and other 'goodies', please goto:
>> http://groups.yahoo.com/group/vantage/files/.
>> (2) To search through old msg's goto:
>> http://groups.yahoo.com/group/vantage/messages
>> (3) To view links to Vendors that provide Vantage services goto:
>> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> .
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo
> ! Groups Links
>
>
>

system · December 27, 2008, 1:43pm

Why ttJobHead table and not just JobHead. Is that a BPM thing?

Bob

--- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@...> wrote:
>
> Thanks a lot for trying this.
>
> I will contact support on Monday morning.
>
> Ross
>
>
> On Dec 27, 2008, at 6:45 AM, "bw2868bond" <bwalker@...>
> wrote:
>
> > Just tried a simple BPM to show message on Update method - I
received
> > same error. My suggestion would be to contact support. I beleive
the
> > BO is flawed.
> >
> > Good Luck.
> >
> > -bw
> >
> > --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@>
wrote:
> >>
> >> Progress and 8.03.407.
> >>
> >> -----Original Message-----
> >> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of
> >> bw2868bond
> >> Sent: Friday, December 26, 2008 6:29 PM
> >> To: vantage@yahoogroups.com
> >> Subject: [Vantage] Re: 4GL query from JobHead BPM
> >>
> >> Just a WAG but the error message would seem to indicate a problem
> >> with the table : field structure
> >>
> >> what version of Vantage are you using and what db SQL or
Progress?
> >>
> >> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@>
wrote:
> >>>
> >>> Thank you much for the suggestions, Carl.
> >>>
> >>> I updated the code to the following and am still getting the
same
> >>> error.
> >>>
> >>> -----------------------
> >>> for each ttJobHead where
> >>> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
> >>> First PartRev WHERE partrev.Company = ttJobHead.Company AND
> >>> PartRev.PartNum = ttJobHead.PartNum AND
> >>> PartRev.RevisionNum = ttJobHead.RevisionNum.
> >>> End.
> >>> ----------------------
> >>>
> >>> I tried it as a PRE and a POST but get the same results.
> >>>
> >>> Thanks,
> >>> Ross
> >>>
> >>> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
> > wrote:
> >>>>
> >>>> Hello Mark:
> >>>>
> >>>> I would like to make a couple of suggestions:
> >>>> - Do not use no-lock if you plan on updating the
> > ttjobhead
> >>> record
> >>>> - Always use a no-error at the end of a find statement
> > and
> >>> then use
> >>>> if available for additional processing
> >>>> - Always use the company field in a find statement for
> >>> integrity and
> >>>> speed
> >>>> - Make sure code is continuous - the normal Progress
> >>> structure has
> >>>> end statements on its own line
> >>>>
> >>>> For each ttjobhead where ttjobhead.rowmod = "A" or
> >> ttjobhead.rowmod
> >>> = "u",
> >>>> first parrev where partrev.company = ttjobhead.company and
> >>>> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> >>>> ttjobhead.revisionnum.
> >>>>
> >>>> Add logic inside.
> >>>> End.
> >>>>
> >>>> Carl Peterson
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > On
> >>> Behalf Of
> >>>> Ross Hughes
> >>>> Sent: Friday, December 26, 2008 3:44 PM
> >>>> To: vantage@yahoogroups.com
> >>>> Subject: [Vantage] 4GL query from JobHead BPM
> >>>>
> >>>> Hello All,
> >>>>
> >>>> I am trying to run a query from the JobEntry.Update
> > Object/Method
> >>> on
> >>>> a
> >>>> Preprocessing BPM trigger. I am using the "design query is less
> >>>> than" approach for the condition. Here is my query:
> >>>>
> >>>> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
> >>> ttJobHead.RowMod
> >>>> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
> >> AND
> >>>> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
> >> available
> >>> partrev
> >>>> then do: add logic end.
> >>>> End
> >>>>
> >>>> The query checks out OK in the Method Directives tool but when
> > I
> >>> run
> >>>> it I get the following error:
> >>>> -------------------
> >>>> Exception caught in: Epicor.Mfg.BO.JobEntry
> >>>>
> >>>> Error Detail
> >>>> ============
> >>>> Message: The field ttJobHead.AnalysisCdDescription does not
> > have
> >> a
> >>>> valid data type.
> >>>> Type: Error
> >>>> Program: bo/DynamicQuery.p
> >>>> Method: buildTempTable
> >>>> Table: SelectedField
> >>>> Row:
> >>>> Field:
> >>>>
> >>>> Stack Trace
> >>>> ===========
> >>>> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> >>>> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> >>>> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> >>>> -------------------------------
> >>>>
> >>>> Can anyone point me in the right direction?
> >>>>
> >>>> What I am trying to accomplish is to read the part rev table
> > for
> >>> the
> >>>> related part number and check off a VB field in JobHead to
> >>> reference
> >>>> on the traveler.
> >>>>
> >>>> Thanks,
> >>>> Ross
> >>>>
> >>>>
> >>>>
> >>>> [Non-text portions of this message have been removed]
> >>>>
> >>>
> >>
> >>
> >>
> >> ------------------------------------
> >>
> >> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have
> >> already linked your email address to a yahoo id to enable
access. )
> >> (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and
> >> Crystal Reports and other 'goodies', please goto:
> >> http://groups.yahoo.com/group/vantage/files/.
> >> (2) To search through old msg's goto:
> >> http://groups.yahoo.com/group/vantage/messages
> >> (3) To view links to Vendors that provide Vantage services goto:
> >> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >>
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
> > must have already linked your email address to a yahoo id to
enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/
> > .
> > (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
> > ! Groups Links
> >
> >
> >
>

system · December 27, 2008, 1:55pm

tt* tables are interim tables BPM often uses..

I did try talking straight to the live table but didn't have success.
Of course, I may have done that incorrectly. I basically mirrored my
query with live tables. Different error.

Ross

On Dec 27, 2008, at 12:43 PM, "Bob Morgan" <rjmorgan@...> wrote:

> Why ttJobHead table and not just JobHead. Is that a BPM thing?
>
> Bob
>
> --- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@...> wrote:
>>
>> Thanks a lot for trying this.
>>
>> I will contact support on Monday morning.
>>
>> Ross
>>
>>
>> On Dec 27, 2008, at 6:45 AM, "bw2868bond" <bwalker@...>
>> wrote:
>>
>>> Just tried a simple BPM to show message on Update method - I
> received
>>> same error. My suggestion would be to contact support. I beleive
> the
>>> BO is flawed.
>>>
>>> Good Luck.
>>>
>>> -bw
>>>
>>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@>
> wrote:
>>>>
>>>> Progress and 8.03.407.
>>>>
>>>> -----Original Message-----
>>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
>>> Behalf Of
>>>> bw2868bond
>>>> Sent: Friday, December 26, 2008 6:29 PM
>>>> To: vantage@yahoogroups.com
>>>> Subject: [Vantage] Re: 4GL query from JobHead BPM
>>>>
>>>> Just a WAG but the error message would seem to indicate a problem
>>>> with the table : field structure
>>>>
>>>> what version of Vantage are you using and what db SQL or
> Progress?
>>>>
>>>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@>
> wrote:
>>>>>
>>>>> Thank you much for the suggestions, Carl.
>>>>>
>>>>> I updated the code to the following and am still getting the
> same
>>>>> error.
>>>>>
>>>>> -----------------------
>>>>> for each ttJobHead where
>>>>> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
>>>>> First PartRev WHERE partrev.Company = ttJobHead.Company AND
>>>>> PartRev.PartNum = ttJobHead.PartNum AND
>>>>> PartRev.RevisionNum = ttJobHead.RevisionNum.
>>>>> End.
>>>>> ----------------------
>>>>>
>>>>> I tried it as a PRE and a POST but get the same results.
>>>>>
>>>>> Thanks,
>>>>> Ross
>>>>>
>>>>> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
>>> wrote:
>>>>>>
>>>>>> Hello Mark:
>>>>>>
>>>>>> I would like to make a couple of suggestions:
>>>>>> - Do not use no-lock if you plan on updating the
>>> ttjobhead
>>>>> record
>>>>>> - Always use a no-error at the end of a find statement
>>> and
>>>>> then use
>>>>>> if available for additional processing
>>>>>> - Always use the company field in a find statement for
>>>>> integrity and
>>>>>> speed
>>>>>> - Make sure code is continuous - the normal Progress
>>>>> structure has
>>>>>> end statements on its own line
>>>>>>
>>>>>> For each ttjobhead where ttjobhead.rowmod = "A" or
>>>> ttjobhead.rowmod
>>>>> = "u",
>>>>>> first parrev where partrev.company = ttjobhead.company and
>>>>>> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
>>>>>> ttjobhead.revisionnum.
>>>>>>
>>>>>> Add logic inside.
>>>>>> End.
>>>>>>
>>>>>> Carl Peterson
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
>>> On
>>>>> Behalf Of
>>>>>> Ross Hughes
>>>>>> Sent: Friday, December 26, 2008 3:44 PM
>>>>>> To: vantage@yahoogroups.com
>>>>>> Subject: [Vantage] 4GL query from JobHead BPM
>>>>>>
>>>>>> Hello All,
>>>>>>
>>>>>> I am trying to run a query from the JobEntry.Update
>>> Object/Method
>>>>> on
>>>>>> a
>>>>>> Preprocessing BPM trigger. I am using the "design query is less
>>>>>> than" approach for the condition. Here is my query:
>>>>>>
>>>>>> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
>>>>> ttJobHead.RowMod
>>>>>> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
>>>> AND
>>>>>> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
>>>> available
>>>>> partrev
>>>>>> then do: add logic end.
>>>>>> End
>>>>>>
>>>>>> The query checks out OK in the Method Directives tool but when
>>> I
>>>>> run
>>>>>> it I get the following error:
>>>>>> -------------------
>>>>>> Exception caught in: Epicor.Mfg.BO.JobEntry
>>>>>>
>>>>>> Error Detail
>>>>>> ============
>>>>>> Message: The field ttJobHead.AnalysisCdDescription does not
>>> have
>>>> a
>>>>>> valid data type.
>>>>>> Type: Error
>>>>>> Program: bo/DynamicQuery.p
>>>>>> Method: buildTempTable
>>>>>> Table: SelectedField
>>>>>> Row:
>>>>>> Field:
>>>>>>
>>>>>> Stack Trace
>>>>>> ===========
>>>>>> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
>>>>>> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
>>>>>> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
>>>>>> -------------------------------
>>>>>>
>>>>>> Can anyone point me in the right direction?
>>>>>>
>>>>>> What I am trying to accomplish is to read the part rev table
>>> for
>>>>> the
>>>>>> related part number and check off a VB field in JobHead to
>>>>> reference
>>>>>> on the traveler.
>>>>>>
>>>>>> Thanks,
>>>>>> Ross
>>>>>>
>>>>>>
>>>>>>
>>>>>> [Non-text portions of this message have been removed]
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------
>>>>
>>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
>>> must have
>>>> already linked your email address to a yahoo id to enable
> access. )
>>>> (1) To access the Files Section of our Yahoo!Group for Report
>>> Builder and
>>>> Crystal Reports and other 'goodies', please goto:
>>>> http://groups.yahoo.com/group/vantage/files/.
>>>> (2) To search through old msg's goto:
>>>> http://groups.yahoo.com/group/vantage/messages
>>>> (3) To view links to Vendors that provide Vantage services goto:
>>>> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>>>>
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You
>>> must have already linked your email address to a yahoo id to
> enable
>>> access. )
>>> (1) To access the Files Section of our Yahoo!Group for Report
>>> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/
>>> .
>>> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
>>> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo
>>> ! Groups Links
>>>
>>>
>>>
>>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> .
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo
> ! Groups Links
>
>
>

system · December 17, 2009, 6:36pm

I know this is a somewhat dated thread but we've run into this AnalysisCdDescription error on 2 different BPM's (most others work just fine). Has anyone else had any success getting around this? Figured I'd check in here first before contacting support. We're on SQL w/ 8.03.408b.

Eric

--- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@...> wrote:
>
> Thanks a lot for trying this.
>
> I will contact support on Monday morning.
>
> Ross
>
>
> On Dec 27, 2008, at 6:45 AM, "bw2868bond" <bwalker@...>
> wrote:
>
> > Just tried a simple BPM to show message on Update method - I received
> > same error. My suggestion would be to contact support. I beleive the
> > BO is flawed.
> >
> > Good Luck.
> >
> > -bw
> >
> > --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >>
> >> Progress and 8.03.407.
> >>
> >> -----Original Message-----
> >> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of
> >> bw2868bond
> >> Sent: Friday, December 26, 2008 6:29 PM
> >> To: vantage@yahoogroups.com
> >> Subject: [Vantage] Re: 4GL query from JobHead BPM
> >>
> >> Just a WAG but the error message would seem to indicate a problem
> >> with the table : field structure
> >>
> >> what version of Vantage are you using and what db SQL or Progress?
> >>
> >> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >>>
> >>> Thank you much for the suggestions, Carl.
> >>>
> >>> I updated the code to the following and am still getting the same
> >>> error.
> >>>
> >>> -----------------------
> >>> for each ttJobHead where
> >>> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
> >>> First PartRev WHERE partrev.Company = ttJobHead.Company AND
> >>> PartRev.PartNum = ttJobHead.PartNum AND
> >>> PartRev.RevisionNum = ttJobHead.RevisionNum.
> >>> End.
> >>> ----------------------
> >>>
> >>> I tried it as a PRE and a POST but get the same results.
> >>>
> >>> Thanks,
> >>> Ross
> >>>
> >>> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
> > wrote:
> >>>>
> >>>> Hello Mark:
> >>>>
> >>>> I would like to make a couple of suggestions:
> >>>> - Do not use no-lock if you plan on updating the
> > ttjobhead
> >>> record
> >>>> - Always use a no-error at the end of a find statement
> > and
> >>> then use
> >>>> if available for additional processing
> >>>> - Always use the company field in a find statement for
> >>> integrity and
> >>>> speed
> >>>> - Make sure code is continuous - the normal Progress
> >>> structure has
> >>>> end statements on its own line
> >>>>
> >>>> For each ttjobhead where ttjobhead.rowmod = "A" or
> >> ttjobhead.rowmod
> >>> = "u",
> >>>> first parrev where partrev.company = ttjobhead.company and
> >>>> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> >>>> ttjobhead.revisionnum.
> >>>>
> >>>> Add logic inside.
> >>>> End.
> >>>>
> >>>> Carl Peterson
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > On
> >>> Behalf Of
> >>>> Ross Hughes
> >>>> Sent: Friday, December 26, 2008 3:44 PM
> >>>> To: vantage@yahoogroups.com
> >>>> Subject: [Vantage] 4GL query from JobHead BPM
> >>>>
> >>>> Hello All,
> >>>>
> >>>> I am trying to run a query from the JobEntry.Update
> > Object/Method
> >>> on
> >>>> a
> >>>> Preprocessing BPM trigger. I am using the "design query is less
> >>>> than" approach for the condition. Here is my query:
> >>>>
> >>>> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
> >>> ttJobHead.RowMod
> >>>> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
> >> AND
> >>>> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
> >> available
> >>> partrev
> >>>> then do: add logic end.
> >>>> End
> >>>>
> >>>> The query checks out OK in the Method Directives tool but when
> > I
> >>> run
> >>>> it I get the following error:
> >>>> -------------------
> >>>> Exception caught in: Epicor.Mfg.BO.JobEntry
> >>>>
> >>>> Error Detail
> >>>> ============
> >>>> Message: The field ttJobHead.AnalysisCdDescription does not
> > have
> >> a
> >>>> valid data type.
> >>>> Type: Error
> >>>> Program: bo/DynamicQuery.p
> >>>> Method: buildTempTable
> >>>> Table: SelectedField
> >>>> Row:
> >>>> Field:
> >>>>
> >>>> Stack Trace
> >>>> ===========
> >>>> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> >>>> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> >>>> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> >>>> -------------------------------
> >>>>
> >>>> Can anyone point me in the right direction?
> >>>>
> >>>> What I am trying to accomplish is to read the part rev table
> > for
> >>> the
> >>>> related part number and check off a VB field in JobHead to
> >>> reference
> >>>> on the traveler.
> >>>>
> >>>> Thanks,
> >>>> Ross
> >>>>
> >>>>
> >>>>
> >>>> [Non-text portions of this message have been removed]
> >>>>
> >>>
> >>
> >>
> >>
> >> ------------------------------------
> >>
> >> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have
> >> already linked your email address to a yahoo id to enable access. )
> >> (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and
> >> Crystal Reports and other 'goodies', please goto:
> >> http://groups.yahoo.com/group/vantage/files/.
> >> (2) To search through old msg's goto:
> >> http://groups.yahoo.com/group/vantage/messages
> >> (3) To view links to Vendors that provide Vantage services goto:
> >> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >>
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> > .
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo
> > ! Groups Links
> >
> >
> >
>

system · December 17, 2009, 7:00pm

You will have to do it in straight 4GL code as an action.

What are you trying to do?

Ross

On Dec 17, 2009, at 5:36 PM, "precisionwirecomponents" <eackerson@...

> wrote:

>
>
>
>
> I know this is a somewhat dated thread but we've run into this
> AnalysisCdDescription error on 2 different BPM's (most others work
> just fine). Has anyone else had any success getting around this?
> Figured I'd check in here first before contacting support. We're on
> SQL w/ 8.03.408b.
>
>
> Eric
>
>
>
>
> --- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@...> wrote:
>>
>> Thanks a lot for trying this.
>>
>> I will contact support on Monday morning.
>>
>> Ross
>>
>>
>> On Dec 27, 2008, at 6:45 AM, "bw2868bond" <bwalker@...>
>> wrote:
>>
>>> Just tried a simple BPM to show message on Update method - I
>>> received
>>> same error. My suggestion would be to contact support. I beleive the
>>> BO is flawed.
>>>
>>> Good Luck.
>>>
>>> -bw
>>>
>>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
>>>>
>>>> Progress and 8.03.407.
>>>>
>>>> -----Original Message-----
>>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
>>> Behalf Of
>>>> bw2868bond
>>>> Sent: Friday, December 26, 2008 6:29 PM
>>>> To: vantage@yahoogroups.com
>>>> Subject: [Vantage] Re: 4GL query from JobHead BPM
>>>>
>>>> Just a WAG but the error message would seem to indicate a problem
>>>> with the table : field structure
>>>>
>>>> what version of Vantage are you using and what db SQL or Progress?
>>>>
>>>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
>>>>>
>>>>> Thank you much for the suggestions, Carl.
>>>>>
>>>>> I updated the code to the following and am still getting the same
>>>>> error.
>>>>>
>>>>> -----------------------
>>>>> for each ttJobHead where
>>>>> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
>>>>> First PartRev WHERE partrev.Company = ttJobHead.Company AND
>>>>> PartRev.PartNum = ttJobHead.PartNum AND
>>>>> PartRev.RevisionNum = ttJobHead.RevisionNum.
>>>>> End.
>>>>> ----------------------
>>>>>
>>>>> I tried it as a PRE and a POST but get the same results.
>>>>>
>>>>> Thanks,
>>>>> Ross
>>>>>
>>>>> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
>>> wrote:
>>>>>>
>>>>>> Hello Mark:
>>>>>>
>>>>>> I would like to make a couple of suggestions:
>>>>>> - Do not use no-lock if you plan on updating the
>>> ttjobhead
>>>>> record
>>>>>> - Always use a no-error at the end of a find statement
>>> and
>>>>> then use
>>>>>> if available for additional processing
>>>>>> - Always use the company field in a find statement for
>>>>> integrity and
>>>>>> speed
>>>>>> - Make sure code is continuous - the normal Progress
>>>>> structure has
>>>>>> end statements on its own line
>>>>>>
>>>>>> For each ttjobhead where ttjobhead.rowmod = "A" or
>>>> ttjobhead.rowmod
>>>>> = "u",
>>>>>> first parrev where partrev.company = ttjobhead.company and
>>>>>> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
>>>>>> ttjobhead.revisionnum.
>>>>>>
>>>>>> Add logic inside.
>>>>>> End.
>>>>>>
>>>>>> Carl Peterson
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
>>> On
>>>>> Behalf Of
>>>>>> Ross Hughes
>>>>>> Sent: Friday, December 26, 2008 3:44 PM
>>>>>> To: vantage@yahoogroups.com
>>>>>> Subject: [Vantage] 4GL query from JobHead BPM
>>>>>>
>>>>>> Hello All,
>>>>>>
>>>>>> I am trying to run a query from the JobEntry.Update
>>> Object/Method
>>>>> on
>>>>>> a
>>>>>> Preprocessing BPM trigger. I am using the "design query is less
>>>>>> than" approach for the condition. Here is my query:
>>>>>>
>>>>>> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
>>>>> ttJobHead.RowMod
>>>>>> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
>>>> AND
>>>>>> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
>>>> available
>>>>> partrev
>>>>>> then do: add logic end.
>>>>>> End
>>>>>>
>>>>>> The query checks out OK in the Method Directives tool but when
>>> I
>>>>> run
>>>>>> it I get the following error:
>>>>>> -------------------
>>>>>> Exception caught in: Epicor.Mfg.BO.JobEntry
>>>>>>
>>>>>> Error Detail
>>>>>> ============
>>>>>> Message: The field ttJobHead.AnalysisCdDescription does not
>>> have
>>>> a
>>>>>> valid data type.
>>>>>> Type: Error
>>>>>> Program: bo/DynamicQuery.p
>>>>>> Method: buildTempTable
>>>>>> Table: SelectedField
>>>>>> Row:
>>>>>> Field:
>>>>>>
>>>>>> Stack Trace
>>>>>> ===========
>>>>>> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
>>>>>> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
>>>>>> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
>>>>>> -------------------------------
>>>>>>
>>>>>> Can anyone point me in the right direction?
>>>>>>
>>>>>> What I am trying to accomplish is to read the part rev table
>>> for
>>>>> the
>>>>>> related part number and check off a VB field in JobHead to
>>>>> reference
>>>>>> on the traveler.
>>>>>>
>>>>>> Thanks,
>>>>>> Ross
>>>>>>
>>>>>>
>>>>>>
>>>>>> [Non-text portions of this message have been removed]
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------
>>>>
>>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
>>> must have
>>>> already linked your email address to a yahoo id to enable access. )
>>>> (1) To access the Files Section of our Yahoo!Group for Report
>>> Builder and
>>>> Crystal Reports and other 'goodies', please goto:
>>>> http://groups.yahoo.com/group/vantage/files/.
>>>> (2) To search through old msg's goto:
>>>> http://groups.yahoo.com/group/vantage/messages
>>>> (3) To view links to Vendors that provide Vantage services goto:
>>>> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>>>>
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
>>> must have already linked your email address to a yahoo id to enable
>>> access. )
>>> (1) To access the Files Section of our Yahoo!Group for Report
>>> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
>>> .
>>> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>>> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo
>>> ! Groups Links
>>>
>>>
>>>
>>
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> .
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo!
> Groups Links
>
>
>

system · November 18, 2011, 5:27pm

I am having the same problem with this error. has anyone found anything new about it or how to get around it?

thanks

--- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@...> wrote:
>
> You will have to do it in straight 4GL code as an action.
>
> What are you trying to do?
>
> Ross
>
> On Dec 17, 2009, at 5:36 PM, "precisionwirecomponents" <eackerson@...
> > wrote:
>
> >
> >
> >
> >
> > I know this is a somewhat dated thread but we've run into this
> > AnalysisCdDescription error on 2 different BPM's (most others work
> > just fine). Has anyone else had any success getting around this?
> > Figured I'd check in here first before contacting support. We're on
> > SQL w/ 8.03.408b.
> >
> >
> > Eric
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@> wrote:
> >>
> >> Thanks a lot for trying this.
> >>
> >> I will contact support on Monday morning.
> >>
> >> Ross
> >>
> >>
> >> On Dec 27, 2008, at 6:45 AM, "bw2868bond" <bwalker@>
> >> wrote:
> >>
> >>> Just tried a simple BPM to show message on Update method - I
> >>> received
> >>> same error. My suggestion would be to contact support. I beleive the
> >>> BO is flawed.
> >>>
> >>> Good Luck.
> >>>
> >>> -bw
> >>>
> >>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >>>>
> >>>> Progress and 8.03.407.
> >>>>
> >>>> -----Original Message-----
> >>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> >>> Behalf Of
> >>>> bw2868bond
> >>>> Sent: Friday, December 26, 2008 6:29 PM
> >>>> To: vantage@yahoogroups.com
> >>>> Subject: [Vantage] Re: 4GL query from JobHead BPM
> >>>>
> >>>> Just a WAG but the error message would seem to indicate a problem
> >>>> with the table : field structure
> >>>>
> >>>> what version of Vantage are you using and what db SQL or Progress?
> >>>>
> >>>> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >>>>>
> >>>>> Thank you much for the suggestions, Carl.
> >>>>>
> >>>>> I updated the code to the following and am still getting the same
> >>>>> error.
> >>>>>
> >>>>> -----------------------
> >>>>> for each ttJobHead where
> >>>>> ttJobHead.RowMod = 'A' or ttJobHead.RowMod = 'U' ,
> >>>>> First PartRev WHERE partrev.Company = ttJobHead.Company AND
> >>>>> PartRev.PartNum = ttJobHead.PartNum AND
> >>>>> PartRev.RevisionNum = ttJobHead.RevisionNum.
> >>>>> End.
> >>>>> ----------------------
> >>>>>
> >>>>> I tried it as a PRE and a POST but get the same results.
> >>>>>
> >>>>> Thanks,
> >>>>> Ross
> >>>>>
> >>>>> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@>
> >>> wrote:
> >>>>>>
> >>>>>> Hello Mark:
> >>>>>>
> >>>>>> I would like to make a couple of suggestions:
> >>>>>> - Do not use no-lock if you plan on updating the
> >>> ttjobhead
> >>>>> record
> >>>>>> - Always use a no-error at the end of a find statement
> >>> and
> >>>>> then use
> >>>>>> if available for additional processing
> >>>>>> - Always use the company field in a find statement for
> >>>>> integrity and
> >>>>>> speed
> >>>>>> - Make sure code is continuous - the normal Progress
> >>>>> structure has
> >>>>>> end statements on its own line
> >>>>>>
> >>>>>> For each ttjobhead where ttjobhead.rowmod = "A" or
> >>>> ttjobhead.rowmod
> >>>>> = "u",
> >>>>>> first parrev where partrev.company = ttjobhead.company and
> >>>>>> partrev.revisionnum = ttjobread.partnum and partrev.partrev =
> >>>>>> ttjobhead.revisionnum.
> >>>>>>
> >>>>>> Add logic inside.
> >>>>>> End.
> >>>>>>
> >>>>>> Carl Peterson
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> >>> On
> >>>>> Behalf Of
> >>>>>> Ross Hughes
> >>>>>> Sent: Friday, December 26, 2008 3:44 PM
> >>>>>> To: vantage@yahoogroups.com
> >>>>>> Subject: [Vantage] 4GL query from JobHead BPM
> >>>>>>
> >>>>>> Hello All,
> >>>>>>
> >>>>>> I am trying to run a query from the JobEntry.Update
> >>> Object/Method
> >>>>> on
> >>>>>> a
> >>>>>> Preprocessing BPM trigger. I am using the "design query is less
> >>>>>> than" approach for the condition. Here is my query:
> >>>>>>
> >>>>>> For each ttJobHead where ( ttJobHead.RowMod = 'A' or
> >>>>> ttJobHead.RowMod
> >>>>>> = 'U' ). Find PartRev WHERE PartRev.PartNum = ttJobHead.PartNum
> >>>> AND
> >>>>>> PartRev.RevisionNum = ttJobHead.RevisionNum no-error. If
> >>>> available
> >>>>> partrev
> >>>>>> then do: add logic end.
> >>>>>> End
> >>>>>>
> >>>>>> The query checks out OK in the Method Directives tool but when
> >>> I
> >>>>> run
> >>>>>> it I get the following error:
> >>>>>> -------------------
> >>>>>> Exception caught in: Epicor.Mfg.BO.JobEntry
> >>>>>>
> >>>>>> Error Detail
> >>>>>> ============
> >>>>>> Message: The field ttJobHead.AnalysisCdDescription does not
> >>> have
> >>>> a
> >>>>>> valid data type.
> >>>>>> Type: Error
> >>>>>> Program: bo/DynamicQuery.p
> >>>>>> Method: buildTempTable
> >>>>>> Table: SelectedField
> >>>>>> Row:
> >>>>>> Field:
> >>>>>>
> >>>>>> Stack Trace
> >>>>>> ===========
> >>>>>> at Epicor.Mfg.Proxy.JobEntryImpl.Update(JobEntryDataSet ds)
> >>>>>> at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Update()
> >>>>>> at Epicor.Mfg.UI.App.JobEntry.Transaction.Update()
> >>>>>> -------------------------------
> >>>>>>
> >>>>>> Can anyone point me in the right direction?
> >>>>>>
> >>>>>> What I am trying to accomplish is to read the part rev table
> >>> for
> >>>>> the
> >>>>>> related part number and check off a VB field in JobHead to
> >>>>> reference
> >>>>>> on the traveler.
> >>>>>>
> >>>>>> Thanks,
> >>>>>> Ross
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> [Non-text portions of this message have been removed]
> >>>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>> ------------------------------------
> >>>>
> >>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> >>> must have
> >>>> already linked your email address to a yahoo id to enable access. )
> >>>> (1) To access the Files Section of our Yahoo!Group for Report
> >>> Builder and
> >>>> Crystal Reports and other 'goodies', please goto:
> >>>> http://groups.yahoo.com/group/vantage/files/.
> >>>> (2) To search through old msg's goto:
> >>>> http://groups.yahoo.com/group/vantage/messages
> >>>> (3) To view links to Vendors that provide Vantage services goto:
> >>>> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >>>>
> >>>
> >>>
> >>>
> >>> ------------------------------------
> >>>
> >>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> >>> must have already linked your email address to a yahoo id to enable
> >>> access. )
> >>> (1) To access the Files Section of our Yahoo!Group for Report
> >>> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> >>> .
> >>> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> >>> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo
> >>> ! Groups Links
> >>>
> >>>
> >>>
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> > .
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo!
> > Groups Links
> >
> >
> >
>

Topic		Replies	Views
Excuting 4GL code Problem Yahoo Archive	3	525	November 22, 2011
Update table via BPM Yahoo Archive	7	498	February 26, 2011
Record has been modified Yahoo Archive	4	523	December 16, 2008
BPMs and ttTables Yahoo Archive	9	1674	July 31, 2008
4GL Problem on BPM Yahoo Archive	5	412	August 6, 2009

4GL query from JobHead BPM

Related Topics