Do it as a data directive....
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov@...>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of David Beberman
Sent: Monday, June 25, 2012 9:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
Marco,
I did the equivalent to the BPM code you gave using the BL tester (Business Logic tester).
The row refuses to allow updating - and gives a 4GL stop only on this labordtl row.
Thank you so much for your effort,
Dave
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: Monday, June 25, 2012 11:41 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
How about... create a BPM that will uncheck the active transaction issue
From the part.update methos:
For each ttpart no-lock:
Find first labordtl where
Labordtl.company = cur-comp and
Labordtl.employeenum = "ABC" and
Labordtl.jobnum = "123" and
Labordtl.oprseq = 10 and
Labordtl.activetrans = true and
Labordtl.payrolldate = 6/15/12 exclusive-lock no-error.
If avail labordtl then do:
Assign labordtl.activetrans = false.
End.
End.
This should open the labor transaction for you to delete in time and expense... try it in the training database first.
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of David Beberman
Sent: Monday, June 25, 2012 8:37 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
Marco,
Thank you for the reply.
Your suggestion is not the case - we do not have any BPM's attached to any Labor-involved tables.
-Dave
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: Monday, June 25, 2012 11:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
We usually get the 4GL stop error when it's a BPM not running properly...
Try turning off your BPMs and then deleting the transactions.
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of davidbeberman
Sent: Monday, June 25, 2012 7:33 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Issue with LaborDtl table corruption
System is Epicor 9.05.606
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov@...>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of David Beberman
Sent: Monday, June 25, 2012 9:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
Marco,
I did the equivalent to the BPM code you gave using the BL tester (Business Logic tester).
The row refuses to allow updating - and gives a 4GL stop only on this labordtl row.
Thank you so much for your effort,
Dave
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: Monday, June 25, 2012 11:41 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
How about... create a BPM that will uncheck the active transaction issue
From the part.update methos:
For each ttpart no-lock:
Find first labordtl where
Labordtl.company = cur-comp and
Labordtl.employeenum = "ABC" and
Labordtl.jobnum = "123" and
Labordtl.oprseq = 10 and
Labordtl.activetrans = true and
Labordtl.payrolldate = 6/15/12 exclusive-lock no-error.
If avail labordtl then do:
Assign labordtl.activetrans = false.
End.
End.
This should open the labor transaction for you to delete in time and expense... try it in the training database first.
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of David Beberman
Sent: Monday, June 25, 2012 8:37 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
Marco,
Thank you for the reply.
Your suggestion is not the case - we do not have any BPM's attached to any Labor-involved tables.
-Dave
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: Monday, June 25, 2012 11:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Issue with LaborDtl table corruption
We usually get the 4GL stop error when it's a BPM not running properly...
Try turning off your BPMs and then deleting the transactions.
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of davidbeberman
Sent: Monday, June 25, 2012 7:33 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Issue with LaborDtl table corruption
System is Epicor 9.05.606
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, David Beberman <dbeberman@...<mailto:dbeberman@...<mailto:dbeberman@...%3cmailto:dbeberman@...<mailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...<mailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...<mailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...%3cmailto:dbeberman@...>>>>>> wrote:
>
> Hi all,
>
> I have 2 labor detail transactions from 5 days ago that are "stuck".
>
> I cant delete the transactions (using Time and Expense) or Delete via BO code.
>
> I get a 4GL stop on LaborAdapter.Delete.
>
> It appears to be a data corruption within the table.
>
> Epicor has asked that I run the 8920/8930 admin programs to clear things out
> - all this has done is allow the employee to clock in on another day into other jobs.
>
> The original job remains "stuck".
>
> Does anyone know any techniques to attack this kind of issue ?
>
> Thank you,
> Dave Beberman
> ERP Mgr
> Ferguson Perforating
> dbeberman@...
>
>
>
> [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]
[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]