Vntg 5.2: Bad record in data collection

Yahoo Archive
1
Darren,



Check the files on the yahoo group. I wouldn't be surprised if someone
left a copy of the endact.r program for your version. If you haven't
already.







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Thursday, January 27, 2011 10:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection





We aren't on maintenance so Epicors help isn't an option. But thank
you.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian Roberts
Sent: Thursday, January 27, 2011 10:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection

We've run into variations of the bad labour detail record a few times.
In Vantage 6.1 we have to call Epicor for assistance & they've sent us a
tiny program that fixes it.

Brian.

________________________________

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 Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vntg 5.2: Bad record in data collection

I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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

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

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3406 - Release Date: 01/27/11

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3406 - Release Date: 01/27/11

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





[Non-text portions of this message have been removed]
2
I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.


Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222


[Non-text portions of this message have been removed]
3
In vantage admin tools, there is a conversion program to run. I believe the
number is 8920, at least it is in vantage 8.0. Just type in his employee
number and the transaction should show up. Then change the active column to
show "no". Should be your fix.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vntg 5.2: Bad record in data collection





I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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





[Non-text portions of this message have been removed]
4
Just now noticed that you are on 5.2, not sure if anything I just said has
any meaning to you at all.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brad Ebright
Sent: Thursday, January 27, 2011 11:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection





In vantage admin tools, there is a conversion program to run. I believe the
number is 8920, at least it is in vantage 8.0. Just type in his employee
number and the transaction should show up. Then change the active column to
show "no". Should be your fix.

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vntg 5.2: Bad record in data collection

I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

[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]
5
Call Epicor, version 5.2 didn't have that conversion Brad talked about!











Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brad Ebright
Sent: Thursday, January 27, 2011 10:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection





In vantage admin tools, there is a conversion program to run. I believe
the
number is 8920, at least it is in vantage 8.0. Just type in his employee
number and the transaction should show up. Then change the active column
to
show "no". Should be your fix.

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vntg 5.2: Bad record in data collection

I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

[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]
6
We've run into variations of the bad labour detail record a few times.
In Vantage 6.1 we have to call Epicor for assistance & they've sent us a
tiny program that fixes it.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vntg 5.2: Bad record in data collection





I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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





[Non-text portions of this message have been removed]
7
We aren't on maintenance so Epicors help isn't an option. But thank
you.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Roberts
Sent: Thursday, January 27, 2011 10:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection




We've run into variations of the bad labour detail record a few times.
In Vantage 6.1 we have to call Epicor for assistance & they've sent us a
tiny program that fixes it.

Brian.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vntg 5.2: Bad record in data collection

I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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

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




________________________________


No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3406 - Release Date: 01/27/11

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3406 - Release Date: 01/27/11



[Non-text portions of this message have been removed]
8
Can you write the progress program to modify the rouge record and
populate the null/missing fields with some sort of data?



Michael Podlin
Network Administrator

V-S Industries, Inc.
900 S. Chaddick Dr.
Wheeling, IL 60090
847-520-1800 x207
Fax 847-520-0269
Michael.Podlin@...




Please consider the environment.
Do you really need to print this email?
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Thursday, January 27, 2011 10:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection




We aren't on maintenance so Epicors help isn't an option. But thank
you.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian Roberts
Sent: Thursday, January 27, 2011 10:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection

We've run into variations of the bad labour detail record a few times.
In Vantage 6.1 we have to call Epicor for assistance & they've sent us a
tiny program that fixes it.

Brian.

________________________________

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 Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vntg 5.2: Bad record in data collection

I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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

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

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3406 - Release Date: 01/27/11

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3406 - Release Date: 01/27/11

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








[Non-text portions of this message have been removed]
9
In Vantage 6.1.540 you can run data conversion 7428 - End Activity on
labor detail transaction and do the same as with their endact.r program.



Jim Moore



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Roberts
Sent: Thursday, January 27, 2011 10:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vntg 5.2: Bad record in data collection





We've run into variations of the bad labour detail record a few times.
In Vantage 6.1 we have to call Epicor for assistance & they've sent us a
tiny program that fixes it.

Brian.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Darren Mann
Sent: Thursday, January 27, 2011 11:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vntg 5.2: Bad record in data collection

I'm not having a very good week so I can hope you all can help. Our
email server went down Monday when the symantec software corrupted both
the new and old drives in a conversion so we were down for a day fixing
that. Then yesterday I came in to a locked vantage server. On reboot
both drives in the RAID failed. So I was here until midnight last night
restoring that server. We lost one days data due to corrupted backups.

Soooo that's how my week has been!! My question is related to the data
collection portion of vantage. I have one employee that shows a labor
detail in data collection without a work center code or job number. It
won't allow me to log him out. I tried writing a program to delete that
record though progress but it ran all last night and locked up. Any
other ideas how to clear this rouge record from data collection??

thanks in advance.

Darren Mann
IT Manager/Purchasing/Quality Assurance
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

[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]
10
Do you have ODBC setup? I know data writes through ODBC are not sanctioned but might work. Of course, try it on your test db first. Worth a shot anyway...

Chris

--- In vantage@yahoogroups.com, "Darren Mann" <dmann@...> wrote:
>
> I'm not having a very good week so I can hope you all can help. Our
> email server went down Monday when the symantec software corrupted both
> the new and old drives in a conversion so we were down for a day fixing
> that. Then yesterday I came in to a locked vantage server. On reboot
> both drives in the RAID failed. So I was here until midnight last night
> restoring that server. We lost one days data due to corrupted backups.
>
>
> Soooo that's how my week has been!! My question is related to the data
> collection portion of vantage. I have one employee that shows a labor
> detail in data collection without a work center code or job number. It
> won't allow me to log him out. I tried writing a program to delete that
> record though progress but it ran all last night and locked up. Any
> other ideas how to clear this rouge record from data collection??
>
> thanks in advance.
>
> Darren Mann
> IT Manager/Purchasing/Quality Assurance
> Miller Products Co.
> 1015 N. Main St.
> Osceola, IA 50213
> Ph. 641-342-2103
> Fax 641-342-3222
>
>
> [Non-text portions of this message have been removed]
>