BPM on ORDER MISC

I have a question. Why are we using OHOrderMsc instead of OrderMsc??
I have OrderMsc.MiscCode 'FRGT' for freight.
because that's the name of the trable in 9 not sure in 8. Do a trace and
send it in. I want to see if tis the same in 8. Do a trace with show
changes only and remove the irrelevant stuff please.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 10:54 AM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> I have a question. Why are we using OHOrderMsc instead of OrderMsc??
> I have OrderMsc.MiscCode 'FRGT' for freight.
>
>
>


[Non-text portions of this message have been removed]
Can I send you the trace log file to your email??

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> because that's the name of the trable in 9 not sure in 8. Do a trace and
> send it in. I want to see if tis the same in 8. Do a trace with show
> changes only and remove the irrelevant stuff please.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jun 10, 2013 at 10:54 AM, sanjay219@...
> <sanjay219@...>wrote:
>
> > **
> >
> >
> > I have a question. Why are we using OHOrderMsc instead of OrderMsc??
> > I have OrderMsc.MiscCode 'FRGT' for freight.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Just send it thought the list please. So that everyone can get a benefit.
You can upload it ot the group or paste it


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 11:10 AM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> Can I send you the trace log file to your email??
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > because that's the name of the trable in 9 not sure in 8. Do a trace and
> > send it in. I want to see if tis the same in 8. Do a trace with show
> > changes only and remove the irrelevant stuff please.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Mon, Jun 10, 2013 at 10:54 AM, sanjay219@...
> > <sanjay219@...>wrote:
> >
> > > **
>
> > >
> > >
> > > I have a question. Why are we using OHOrderMsc instead of OrderMsc??
> > > I have OrderMsc.MiscCode 'FRGT' for freight.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
Sure. I just uploaded the file to File area. Please take a look. Thanks.
Yeah change it to OrdsMsc since 8x doesn't have the toher table and try
again.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 11:23 AM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> Sure. I just uploaded the file to File area. Please take a look. Thanks.
>
>
>


[Non-text portions of this message have been removed]
Ok. I tried. Application Error. But, I guess we are much closer!! :)

Error Detail
============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Table: OrderDtl
Company='' OrderNum='0' OrderLine='0' RowIdent='': ForeignKeyConstraint OrderHedOrderDtl requires the child key values (, 0) to exist in the parent table.


Stack Trace
===========
at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable targetDT)
at Epicor.Mfg.Pro.Convert.ToDataSet(ParameterSet parameters, DataSet ds, Int32 paramPos)
at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()

Inner Exception
===============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Inner Stack Trace
=================
at System.Data.DataSet.FailedEnableConstraints()
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.DataTable.EndLoadData()
at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable targetDT


App server log:

[13/06/10@11:18:35.334-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6430) 1
[13/06/10@11:18:35.334-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6434) 2
[13/06/10@11:18:35.334-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6467) 3
[13/06/10@11:18:35.381-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6471) 4
[13/06/10@11:18:35.397-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6478) 5
[13/06/10@11:18:36.006-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6483) 6
[13/06/10@11:18:36.022-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6488) 7
[13/06/10@11:18:36.022-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6494) 8
[13/06/10@11:18:36.053-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6500) 9
[13/06/10@11:18:36.053-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6507) 10
[13/06/10@11:18:36.428-0400] P-002948 T-005100 1 AS -- (Procedure: 'refreshttOrderDtl Server/bo/SalesOrder.p' Line:135265) Source element of a BUFFER-COPY statement has no record. (5365)
[13/06/10@11:18:36.615-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6512) 11
[13/06/10@11:18:36.834-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6517) 12
[13/06/10@11:18:36.834-0400] P-002948 T-005100 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6521) 13
Paste the code again plkease. With the changes.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 11:37 AM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> Ok. I tried. Application Error. But, I guess we are much closer!! :)
>
> Error Detail
> ============
> Failed to enable constraints. One or more rows contain values violating
> non-null, unique, or foreign-key constraints.
>
> Table: OrderDtl
> Company='' OrderNum='0' OrderLine='0' RowIdent='': ForeignKeyConstraint
> OrderHedOrderDtl requires the child key values (, 0) to exist in the parent
> table.
>
> Stack Trace
> ===========
> at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable
> targetDT)
> at Epicor.Mfg.Pro.Convert.ToDataSet(ParameterSet parameters, DataSet ds,
> Int32 paramPos)
>
> at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
>
> Inner Exception
> ===============
> Failed to enable constraints. One or more rows contain values violating
> non-null, unique, or foreign-key constraints.
>
> Inner Stack Trace
> =================
> at System.Data.DataSet.FailedEnableConstraints()
> at System.Data.DataSet.EnableConstraints()
> at System.Data.DataSet.set_EnforceConstraints(Boolean value)
> at System.Data.DataTable.EndLoadData()
> at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable
> targetDT
>
> App server log:
>
> [13/06/10@11:18:35.334-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6430) 1
> [13/06/10@11:18:35.334-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6434) 2
> [13/06/10@11:18:35.334-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6467) 3
> [13/06/10@11:18:35.381-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6471) 4
> [13/06/10@11:18:35.397-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6478) 5
> [13/06/10@11:18:36.006-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6483) 6
> [13/06/10@11:18:36.022-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6488) 7
> [13/06/10@11:18:36.022-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6494) 8
> [13/06/10@11:18:36.053-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6500) 9
> [13/06/10@11:18:36.053-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6507) 10
> [13/06/10@11:18:36.428-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'refreshttOrderDtl Server/bo/SalesOrder.p' Line:135265) Source element of a
> BUFFER-COPY statement has no record. (5365)
> [13/06/10@11:18:36.615-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6512) 11
> [13/06/10@11:18:36.834-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6517) 12
> [13/06/10@11:18:36.834-0400] P-002948 T-005100 1 AS -- (Procedure:
> 'UpdatePost30_A1 bo/SalesOrder.p' Line:6521) 13
>
>
>


[Non-text portions of this message have been removed]
SalesOrder.update Post-Process.


DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
DEFINE VARIABLE icustnum as integer no-undo.
DEFINE VARIABLE iordernum as integer no-undo.

message '1'.

for each ttorderhed where ttorderhed.TermsCode='CC':

message '2'.

assign iOrderNum = ttorderhed.OrderNum.

{lib/PublishInfoMsg.i &InfoMsg = iordernum}.

message '3'.

RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.

message '4'.

FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
Customer.CustNum= ttorderhed.CustNum:
Assign miscCode = Customer.ShortChar01.
END.

message '5'.

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

message '6'.

RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).

message '7'.

FOR EACH ttOrderMsc WHERE ttOrderMsc.RowMod='A':
Assign ttOrderMsc.MiscCode='FRGT'.
END.

message '8'.

RUN ChangeMiscCode in
hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
'OrderMsc').

message '9'.

FOR EACH ttOrderMsc WHERE ttOrderMsc.RowMod='A':
ttOrderMsc.FreqCode='E'.
ttordermsc.DocMiscAmt= ttordermsc.DocMiscAmt + 10.
END.

message '10'.

RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).


message '11'.

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

message '12'.

DELETE OBJECT hSalesOrder.

message '13'.

end.
RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).

you are passing line number 0... you need line 1 or something ... depends
on what line you are trying to add the misc charge to


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 11:40 AM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
>
> SalesOrder.update Post-Process.
>
>
> DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> DEFINE VARIABLE icustnum as integer no-undo.
> DEFINE VARIABLE iordernum as integer no-undo.
>
> message '1'.
>
> for each ttorderhed where ttorderhed.TermsCode='CC':
>
> message '2'.
>
> assign iOrderNum = ttorderhed.OrderNum.
>
> {lib/PublishInfoMsg.i &InfoMsg = iordernum}.
>
> message '3'.
>
> RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
>
> message '4'.
>
> FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> Customer.CustNum= ttorderhed.CustNum:
> Assign miscCode = Customer.ShortChar01.
> END.
>
> message '5'.
>
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
>
> message '6'.
>
> RUN GetNewOrderMsc in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
>
> message '7'.
>
> FOR EACH ttOrderMsc WHERE ttOrderMsc.RowMod='A':
> Assign ttOrderMsc.MiscCode='FRGT'.
>
> END.
>
> message '8'.
>
> RUN ChangeMiscCode in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> 'OrderMsc').
>
> message '9'.
>
> FOR EACH ttOrderMsc WHERE ttOrderMsc.RowMod='A':
> ttOrderMsc.FreqCode='E'.
> ttordermsc.DocMiscAmt= ttordermsc.DocMiscAmt + 10.
>
> END.
>
> message '10'.
>
> RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
>
> message '11'.
>
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
>
> message '12'.
>
> DELETE OBJECT hSalesOrder.
>
> message '13'.
>
> end.
>
>
>


[Non-text portions of this message have been removed]
Yes. Only line 1. But its taking too much time after we add new line. Seems, its stuck on 'Saving Data...'
Did you change it to line 1? how far did it get in the messages?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> Yes. Only line 1. But its taking too much time after we add new line.
> Seems, its stuck on 'Saving Data...'
>
>
>


[Non-text portions of this message have been removed]
What's the port number you are using to run this? 8301 8321 or 8331?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 11:54 AM, Jose Gomez <jose@...> wrote:

> Did you change it to line 1? how far did it get in the messages?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@... <sanjay219@...
> > wrote:
>
>> **
>>
>>
>> Yes. Only line 1. But its taking too much time after we add new line.
>> Seems, its stuck on 'Saving Data...'
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
Yes I did:


DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
DEFINE VARIABLE icustnum as integer no-undo.
DEFINE VARIABLE iordernum as integer no-undo.

message '1'.

for each ttorderhed where ttorderhed.TermsCode='CC':

message '2'.

assign iOrderNum = ttorderhed.OrderNum.

{lib/PublishInfoMsg.i &InfoMsg = iordernum}.

message '3'.

RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.

message '4'.

FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
Customer.CustNum= ttorderhed.CustNum:
Assign miscCode = Customer.ShortChar01.
END.

message '5'.

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

message '6'.

RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,1).

message '7'.

FOR EACH ttOrderMsc WHERE ttOrderMsc.RowMod='A':
Assign ttOrderMsc.MiscCode='FRGT'.
END.

message '8'.

RUN ChangeMiscCode in
hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
'OrderMsc').

message '9'.

FOR EACH ttOrderMsc WHERE ttOrderMsc.RowMod='A':
ttOrderMsc.FreqCode='E'.
ttordermsc.DocMiscAmt= ttordermsc.DocMiscAmt + 10.
END.

message '10'.

RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).


message '11'.

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

message '12'.

DELETE OBJECT hSalesOrder.

message '13'.

end.




[13/06/10@11:48:28.944-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6430) 1
[13/06/10@11:48:28.944-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6434) 2
[13/06/10@11:48:28.944-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6467) 3
[13/06/10@11:48:29.240-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6471) 4
[13/06/10@11:48:29.240-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6478) 5
[13/06/10@11:48:29.694-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6483) 6
[13/06/10@11:48:29.740-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6488) 7
[13/06/10@11:48:29.740-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6494) 8
[13/06/10@11:48:29.787-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6500) 9
[13/06/10@11:48:29.787-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6507) 10
[13/06/10@11:48:31.022-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6430) 1
[13/06/10@11:48:31.022-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6434) 2
[13/06/10@11:48:31.022-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6467) 3
[13/06/10@11:48:31.319-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6471) 4
[13/06/10@11:48:31.319-0400] P-005212 T-002276 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6478) 5

Stuck on 5!!
8321

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> What's the port number you are using to run this? 8301 8321 or 8331?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jun 10, 2013 at 11:54 AM, Jose Gomez <jose@...> wrote:
>
> > Did you change it to line 1? how far did it get in the messages?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/> <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@... <sanjay219@...
> > > wrote:
> >
> >> **
> >>
> >>
> >> Yes. Only line 1. But its taking too much time after we add new line.
> >> Seems, its stuck on 'Saving Data...'
> >>
> >>
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
That's because its going through an infinite loop. Set CheckBox01 or
something like that on SalesORderHead after processing and make that a
condition on the BPM.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 12:00 PM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> 8321
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > What's the port number you are using to run this? 8301 8321 or 8331?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Mon, Jun 10, 2013 at 11:54 AM, Jose Gomez <jose@...> wrote:
> >
> > > Did you change it to line 1? how far did it get in the messages?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@...
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/> <
> http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > > On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@... <sanjay219@...
> > > > wrote:
> > >
> > >> **
>
> > >>
> > >>
> > >> Yes. Only line 1. But its taking too much time after we add new line.
> > >> Seems, its stuck on 'Saving Data...'
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
Sorry, I didnt get you, Can you please explain it?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> That's because its going through an infinite loop. Set CheckBox01 or
> something like that on SalesORderHead after processing and make that a
> condition on the BPM.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jun 10, 2013 at 12:00 PM, sanjay219@...
> <sanjay219@...>wrote:
>
> > **
> >
> >
> > 8321
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > What's the port number you are using to run this? 8301 8321 or 8331?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > > On Mon, Jun 10, 2013 at 11:54 AM, Jose Gomez <jose@> wrote:
> > >
> > > > Did you change it to line 1? how far did it get in the messages?
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/> <
> > http://www.josecgomez.com/feed/>
> > > > <http://www.usdoingstuff.com>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > > On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@ <sanjay219@
> > > > > wrote:
> > > >
> > > >> **
> >
> > > >>
> > > >>
> > > >> Yes. Only line 1. But its taking too much time after we add new line.
> > > >> Seems, its stuck on 'Saving Data...'
> > > >>
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Make sure you have the setting for loop limit set to something like 100. It is unchecked and set to 1000 by default.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "Jose Gomez" <jose@...>
To: "Vantage" <vantage@yahoogroups.com>
Sent: Monday, June 10, 2013 11:02:38 AM
Subject: Re: [Vantage] Re: BPM on ORDER MISC

That's because its going through an infinite loop. Set CheckBox01 or
something like that on SalesORderHead after processing and make that a
condition on the BPM.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 12:00 PM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> 8321
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > What's the port number you are using to run this? 8301 8321 or 8331?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Mon, Jun 10, 2013 at 11:54 AM, Jose Gomez <jose@...> wrote:
> >
> > > Did you change it to line 1? how far did it get in the messages?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@...
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/> <
> http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > > On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@... <sanjay219@...
> > > > wrote:
> > >
> > >> **
>
> > >>
> > >>
> > >> Yes. Only line 1. But its taking too much time after we add new line.
> > >> Seems, its stuck on 'Saving Data...'
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[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






[Non-text portions of this message have been removed]
SIGH
Ok you need to set CheckBox01 on OrderHead to True and then on the BPM
Conditions make sure that it only triggers when that CheckB ox is false. So
that when your code runs it only fires once.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jun 10, 2013 at 12:04 PM, sanjay219@...
<sanjay219@...>wrote:

> **
>
>
> Sorry, I didnt get you, Can you please explain it?
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > That's because its going through an infinite loop. Set CheckBox01 or
> > something like that on SalesORderHead after processing and make that a
> > condition on the BPM.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Mon, Jun 10, 2013 at 12:00 PM, sanjay219@...
> > <sanjay219@...>wrote:
> >
> > > **
> > >
> > >
> > > 8321
>
> > >
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > What's the port number you are using to run this? 8301 8321 or 8331?
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > > <http://www.usdoingstuff.com>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > > On Mon, Jun 10, 2013 at 11:54 AM, Jose Gomez <jose@> wrote:
> > > >
> > > > > Did you change it to line 1? how far did it get in the messages?
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *T: 904.469.1524 mobile
> > > > > E: jose@
> > > > > http://www.josecgomez.com
> > > > > <http://www.linkedin.com/in/josecgomez> <
> > > http://www.facebook.com/josegomez>
> > > > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > > > <http://www.josecgomez.com/professional-resume/> <
> > > http://www.josecgomez.com/feed/>
> > > > > <http://www.usdoingstuff.com>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > > On Mon, Jun 10, 2013 at 11:51 AM, sanjay219@ <sanjay219@
>
> > > > > > wrote:
> > > > >
> > > > >> **
> > >
> > > > >>
> > > > >>
> > > > >> Yes. Only line 1. But its taking too much time after we add new
> line.
> > > > >> Seems, its stuck on 'Saving Data...'
> > > > >>
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > > [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]
I put the loop limit to 100. and tried. Got the error:

Error Detail
============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Table: OrderDtl
Company='' OrderNum='0' OrderLine='0' RowIdent='': ForeignKeyConstraint OrderHedOrderDtl requires the child key values (, 0) to exist in the parent table.


Stack Trace
===========
at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable targetDT)
at Epicor.Mfg.Pro.Convert.ToDataSet(ParameterSet parameters, DataSet ds, Int32 paramPos)
at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()

Inner Exception
===============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Inner Stack Trace
=================
at System.Data.DataSet.FailedEnableConstraints()
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.DataTable.EndLoadData()
at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable targetDT

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

App server log:

[13/06/10@12:10:57.647-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6430) 1
[13/06/10@12:10:57.647-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6434) 2
[13/06/10@12:10:57.647-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6467) 3
[13/06/10@12:10:57.694-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6471) 4
[13/06/10@12:10:57.694-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6478) 5
[13/06/10@12:10:58.303-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6483) 6
[13/06/10@12:10:58.319-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6488) 7
[13/06/10@12:10:58.319-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6494) 8
[13/06/10@12:10:58.334-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6500) 9
[13/06/10@12:10:58.334-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6507) 10
[13/06/10@12:10:58.662-0400] P-007760 T-007396 1 AS -- (Procedure: 'refreshttOrderDtl Server/bo/SalesOrder.p' Line:135265) Source element of a BUFFER-COPY statement has no record. (5365)
[13/06/10@12:10:58.678-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6512) 11
[13/06/10@12:10:58.834-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6517) 12
[13/06/10@12:10:58.834-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6521) 13
[13/06/10@12:10:58.834-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6434) 2
[13/06/10@12:10:58.834-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6467) 3
[13/06/10@12:10:58.912-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6471) 4
[13/06/10@12:10:58.928-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6478) 5
[13/06/10@12:10:59.037-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6483) 6
[13/06/10@12:10:59.053-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6488) 7
[13/06/10@12:10:59.053-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6494) 8
[13/06/10@12:10:59.069-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6500) 9
[13/06/10@12:10:59.069-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6507) 10
[13/06/10@12:10:59.350-0400] P-007760 T-007396 1 AS -- (Procedure: 'refreshttOrderDtl Server/bo/SalesOrder.p' Line:135265) Source element of a BUFFER-COPY statement has no record. (5365)
[13/06/10@12:10:59.365-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6512) 11
[13/06/10@12:10:59.522-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6517) 12
[13/06/10@12:10:59.537-0400] P-007760 T-007396 1 AS -- (Procedure: 'UpdatePost30_A1 bo/SalesOrder.p' Line:6521) 13
[13/06/10@12:11:02.850-0400] P-002948 T-005100 1 AS -- DECRYPT error:0606506D:digital envelope routines:EVP_DecryptFinal:wrong final block length: