Do you have any thoughts on how to bypass this issue that Epicor is
indicating is happening in our custom code?
"In Epicor9, we have what is called an One Dirty Row Rule. Basically,
you can only update 1 DB Row at a time.
It is also possible that custom code can produce a Race Condition. That
is, the custom code is trying to update the second Row before the first
Row completes the update."
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Tuesday, July 30, 2013 10:14 AM
To: Vantage
Subject: Re: [Vantage] Code - JobEntry.Update does not allow updating
multiple times
Try removing the RowMod="U" and removing the GetBYID
*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?*
indicating is happening in our custom code?
"In Epicor9, we have what is called an One Dirty Row Rule. Basically,
you can only update 1 DB Row at a time.
It is also possible that custom code can produce a Race Condition. That
is, the custom code is trying to update the second Row before the first
Row completes the update."
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Tuesday, July 30, 2013 10:14 AM
To: Vantage
Subject: Re: [Vantage] Code - JobEntry.Update does not allow updating
multiple times
Try removing the RowMod="U" and removing the GetBYID
*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 Tue, Jul 30, 2013 at 11:10 AM, Chang, Chia <cchang@...> wrote:
> **
>
>
> Yes this is external. I'm not sure what you mean by removing the
> second GetByID...there is only one.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Tuesday, July 30, 2013 10:01 AM
> To: Vantage
> Subject: Re: [Vantage] Code - JobEntry.Update does not allow updating
> multiple times
>
> not if you are doing a Get By ID,
> this is external no?
> Try removing the second get by id
>
> That Epicor Core Security stuff... is that a Library you guys wrote?
> It looks odd.
>
> *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 Tue, Jul 30, 2013 at 10:50 AM, Chang, Chia <cchang@...> wrote:
>
> > **
>
> >
> >
> > There is no BPMs in the JobEntry BO. We have tried it in Epicor with
> > two users having the JobEntry form open in the same job while one
> > saves and the other tries to save a second time but gets the "row
> modified"
> > error message. I'm wondering if the code is doing the same thing
> > here upon the second update.
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Jose Gomez
> > Sent: Tuesday, July 30, 2013 9:41 AM
> > To: Vantage
> > Subject: Re: [Vantage] Code - JobEntry.Update does not allow
> > updating multiple times
> >
> > Ok that code looks good, do you ahve any BPMs in that BO? if so
> > disable them and try aagain.
> >
> > *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 Tue, Jul 30, 2013 at 10:35 AM, Chang, Chia <cchang@...>
wrote:
> >
> > > **
> >
> > >
> > >
> > > Below is the code that we are catching an exception error of "Row
> > > has been modified by other user..." when trying to do a second
> > > JobEntry.Update.
> > >
> > > public static void
> > > CreateJobSubAssembly(Epicor.Mfg.BO.JobEntryDataSet dataSet,
> > > JobAssembly newAssembly, int bomLevel) {
> > > 123Erp.Core.Security.EpicorV2.EpicorSecurity es = new
> > > 123Erp.Core.Security.EpicorV2.EpicorSecurity();
> > > JobAssembly jobAssembly = new JobAssembly(); using
> > > (es.BlConnection())
> >
> > > { int seqNum = newAssembly.Sequence;
> > >
> > > Epicor.Mfg.BO.JobEntry jobEntry = new
> > > Epicor.Mfg.BO.JobEntry(es.BlConnection());
> > >
> > > jobEntry.InsertNewJobAsmbl(dataSet, newAssembly.JobNum, seqNum +
> > > 1, bomLevel, seqNum);
> > >
> > > dataSet.JobAsmbl[seqNum].JobNum = newAssembly.JobNum; //ASSIGN A
> > > BUNCH
> >
> > > OF OTHER VALUES IN HERE...
> > > .
> > > .
> > > .
> > > .
> > >
> > > jobEntry.ChangeJobAsmblPartNum(dataSet);
> > > jobEntry.ChangeJobAsmblEstSplitCosts(dataSet);
> > > dataSet.JobAsmbl[seqNum].EstMtlUnitCost =
> > > newAssembly.EstMtlUnitCost;
> > >
> > > dataSet.JobAsmbl[seqNum].RowMod = "U"; jobEntry.Update(dataSet);
> > > try
>
> > > {
> >
> > > jobEntry.GetByID(newAssembly.JobNum);
> > > dataSet.JobAsmbl[seqNum].EstMtlUnitCost =
> > > newAssembly.EstMtlUnitCost;
> > > jobEntry.ChangeJobAsmblEstSplitCosts(dataSet);
> > >
> > > jobEntry.Update(dataSet);
> > >
> > > }
> > > catch (Exception e)
> > > {
> > > string test = e.ToString();
> > > //THIS THROWS A "MODIFIED BY OTHER USER, PLEASE TRY TO REFRESH"
> > > EXCEPTION
> > >
> > > }
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of Jose Gomez
> > > Sent: Tuesday, July 30, 2013 7:50 AM
> > > To: Vantage
> > > Subject: Re: [Vantage] Code - JobEntry.Update does not allow
> > > updating multiple times
> > >
> > > It might help to see your code.
> > >
> > > *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 Tue, Jul 30, 2013 at 8:47 AM, Ted Koch <tkoch77@...>
wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > You could try oTrans.Refresh
> > > >
> > > > ________________________________
> > > > From: "Chang, Chia" <cchang@...>
> > > > To: vantage@yahoogroups.com
> > > > Sent: Monday, July 29, 2013 5:06 PM
> > > > Subject: RE: [Vantage] Code - JobEntry.Update does not allow
> > > > updating multiple times
> > > >
> > > >
> > > >
> > > > What method is the "refresh" calling? Or GetByID?
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On Behalf Of Jose Gomez
> > > > Sent: Monday, July 29, 2013 4:04 PM
> > > > To: Vantage
> > > > Subject: Re: [Vantage] Code - JobEntry.Update does not allow
> > > > updating multiple times
> > > >
> > > > Not looking at your actual code, run a refresh or get by id
> > > > before
>
> > > > updating 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, Jul 29, 2013 at 4:59 PM, cchang015 <cchang@...>
> wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > When we create a custom code using the JobEntry.Update method,
> > > > > the
> >
> > > > > system returns an error message "The row has been modified..."
> > > > > when we
> > > >
> > > > > try to call the JobEntry.Update method twice in our code. What
> > > > > needs
> > >
> > > > > to be set so that we can run the JobEntry.Update method again
> > > > > in
>
> > > > > our
> > >
> > > > > code without encountering the "The row has been modified..."
> > error.
> > > > >
> > > > > For example, we make a change to the Pull Qty in Job
> > > > > Entry...Update...and then make a change to the Material
> > > Cost...Update.
> > > >
> > > > > It seems like the system is "locked" when doing a second
> > > > > update that
> > >
> > > > > we encounter the error "The row has been modified..." in our
> code.
> > > > > Is there a missing method or business object we are not
> > > > > calling to
> > > > "release" or update it correctly?
> > > > >
> > > > >
> > > > >
> > > >
> > > > [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
> > > >
> > > > [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]
> >
> > ------------------------------------
> >
> > 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]
>
> ------------------------------------
>
> 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]
------------------------------------
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