Sage 100

Client is on Sage 100 Std, version 4.4. Getting Error #81, Program BM_ProductionRegister_upd.pvc, Line 1489 during Production Entry Update (interrupted update). I could not find anything helpful in the Sage KB. I rebuilt all files in BM and IM (except Production Entry files)  Still no love.

Is anyone able to lookup this error and give me some insight as to what it is trying to do?

TIA​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

Greg - The line number didn't match up with my BM_ProductionRegister_upd.pvc from 4.40 PU2 where an Error 81 could occur. Maybe the same was true with Jeff. We don't know which PU you're on so best if you upload the actual BM_ProductionRegister_upd.pvc file. In general an 81 occurs when the columns of data for a table from the dictionary don't match up with the physical table. Notoriously this occurred time to time in the old days where UDF Maintenance would update the table for the current company with a new UDF added but not for all the companies. This is why I mentioned doing UDF Update for BM_BillOptionHeader. The same would be tried if you had just (re)installed a mod that changes the dict but it hadn't been activated for a company. Same if a PU with dict changes is installed but a company isn't converted.

At this point, I'd say make this your plan:
1. See if IM_ItemWarehouse has any UDFs and if so do an Update there.
2. Otherwise, make a copy company, and in the copy, do Option 3 mentioned in this post except substitute "A/P" for "B/M" and after running that, hit the up arrow button on your keyboard and run again for "I/M". Now try the Prod Reg Update  in the copy. If it works. repeat for live company. 
3. Otherwise, upload the program here.



------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 06-21-2022 18:03
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

@Alnoor Cassim thanks for the additional info. ​ BM_BillOptionHeader is empty, will a manual reinit fix it? I will also upload their program for inspection.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-22-2022 11:17
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - The line number didn't match up with my BM_ProductionRegister_upd.pvc from 4.40 PU2 where an Error 81 could occur. Maybe the same was true with Jeff. We don't know which PU you're on so best if you upload the actual BM_ProductionRegister_upd.pvc file. In general an 81 occurs when the columns of data for a table from the dictionary don't match up with the physical table. Notoriously this occurred time to time in the old days where UDF Maintenance would update the table for the current company with a new UDF added but not for all the companies. This is why I mentioned doing UDF Update for BM_BillOptionHeader. The same would be tried if you had just (re)installed a mod that changes the dict but it hadn't been activated for a company. Same if a PU with dict changes is installed but a company isn't converted.

At this point, I'd say make this your plan:
1. See if IM_ItemWarehouse has any UDFs and if so do an Update there.
2. Otherwise, make a copy company, and in the copy, do Option 3 mentioned in this post except substitute "A/P" for "B/M" and after running that, hit the up arrow button on your keyboard and run again for "I/M". Now try the Prod Reg Update  in the copy. If it works. repeat for live company.
3. Otherwise, upload the program here.



------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------


Original Message:
Sent: 06-21-2022 18:03
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

I don't know but did you see my Steps 1 through 3?

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 06-22-2022 12:28
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim thanks for the additional info. ​ BM_BillOptionHeader is empty, will a manual reinit fix it? I will also upload their program for inspection.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-22-2022 11:17
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - The line number didn't match up with my BM_ProductionRegister_upd.pvc from 4.40 PU2 where an Error 81 could occur. Maybe the same was true with Jeff. We don't know which PU you're on so best if you upload the actual BM_ProductionRegister_upd.pvc file. In general an 81 occurs when the columns of data for a table from the dictionary don't match up with the physical table. Notoriously this occurred time to time in the old days where UDF Maintenance would update the table for the current company with a new UDF added but not for all the companies. This is why I mentioned doing UDF Update for BM_BillOptionHeader. The same would be tried if you had just (re)installed a mod that changes the dict but it hadn't been activated for a company. Same if a PU with dict changes is installed but a company isn't converted.

At this point, I'd say make this your plan:
1. See if IM_ItemWarehouse has any UDFs and if so do an Update there.
2. Otherwise, make a copy company, and in the copy, do Option 3 mentioned in this post except substitute "A/P" for "B/M" and after running that, hit the up arrow button on your keyboard and run again for "I/M". Now try the Prod Reg Update  in the copy. If it works. repeat for live company.
3. Otherwise, upload the program here.



------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-21-2022 18:03
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

@Alnoor Cassim yes, I did. I will try it tonight after they all logoff. I was thinking if the table and dictionary aren't aligned a manual reinit would fix that?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-22-2022 12:31
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

I don't know but did you see my Steps 1 through 3?

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------


Original Message:
Sent: 06-22-2022 12:28
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim thanks for the additional info. ​ BM_BillOptionHeader is empty, will a manual reinit fix it? I will also upload their program for inspection.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-22-2022 11:17
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - The line number didn't match up with my BM_ProductionRegister_upd.pvc from 4.40 PU2 where an Error 81 could occur. Maybe the same was true with Jeff. We don't know which PU you're on so best if you upload the actual BM_ProductionRegister_upd.pvc file. In general an 81 occurs when the columns of data for a table from the dictionary don't match up with the physical table. Notoriously this occurred time to time in the old days where UDF Maintenance would update the table for the current company with a new UDF added but not for all the companies. This is why I mentioned doing UDF Update for BM_BillOptionHeader. The same would be tried if you had just (re)installed a mod that changes the dict but it hadn't been activated for a company. Same if a PU with dict changes is installed but a company isn't converted.

At this point, I'd say make this your plan:
1. See if IM_ItemWarehouse has any UDFs and if so do an Update there.
2. Otherwise, make a copy company, and in the copy, do Option 3 mentioned in this post except substitute "A/P" for "B/M" and after running that, hit the up arrow button on your keyboard and run again for "I/M". Now try the Prod Reg Update  in the copy. If it works. repeat for live company.
3. Otherwise, upload the program here.



------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-21-2022 18:03
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

Oh I see. Yes I suppose manual reinit would fix that since it's supposed to delete the file in the o/s and create a new one from the dictionary. Yes start by trying that for BM_BillOptionHeader. But  if it doesn't work, note I mentioned IM_ItemWarehouse too, which would have to be part of the 1 - 3 since you obviously don't want to reinit that.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 06-22-2022 12:34
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim yes, I did. I will try it tonight after they all logoff. I was thinking if the table and dictionary aren't aligned a manual reinit would fix that?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-22-2022 12:31
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

I don't know but did you see my Steps 1 through 3?

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-22-2022 12:28
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim thanks for the additional info. ​ BM_BillOptionHeader is empty, will a manual reinit fix it? I will also upload their program for inspection.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-22-2022 11:17
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - The line number didn't match up with my BM_ProductionRegister_upd.pvc from 4.40 PU2 where an Error 81 could occur. Maybe the same was true with Jeff. We don't know which PU you're on so best if you upload the actual BM_ProductionRegister_upd.pvc file. In general an 81 occurs when the columns of data for a table from the dictionary don't match up with the physical table. Notoriously this occurred time to time in the old days where UDF Maintenance would update the table for the current company with a new UDF added but not for all the companies. This is why I mentioned doing UDF Update for BM_BillOptionHeader. The same would be tried if you had just (re)installed a mod that changes the dict but it hadn't been activated for a company. Same if a PU with dict changes is installed but a company isn't converted.

At this point, I'd say make this your plan:
1. See if IM_ItemWarehouse has any UDFs and if so do an Update there.
2. Otherwise, make a copy company, and in the copy, do Option 3 mentioned in this post except substitute "A/P" for "B/M" and after running that, hit the up arrow button on your keyboard and run again for "I/M". Now try the Prod Reg Update  in the copy. If it works. repeat for live company.
3. Otherwise, upload the program here.



------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-21-2022 18:03
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

@Alnoor Cassim agreed. I will try the suggestions from you and @Kevin Moyes tonight.
Thanks.​​​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-22-2022 12:43
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Oh I see. Yes I suppose manual reinit would fix that since it's supposed to delete the file in the o/s and create a new one from the dictionary. Yes start by trying that for BM_BillOptionHeader. But  if it doesn't work, note I mentioned IM_ItemWarehouse too, which would have to be part of the 1 - 3 since you obviously don't want to reinit that.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------


Original Message:
Sent: 06-22-2022 12:34
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim yes, I did. I will try it tonight after they all logoff. I was thinking if the table and dictionary aren't aligned a manual reinit would fix that?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-22-2022 12:31
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

I don't know but did you see my Steps 1 through 3?

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-22-2022 12:28
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim thanks for the additional info. ​ BM_BillOptionHeader is empty, will a manual reinit fix it? I will also upload their program for inspection.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-22-2022 11:17
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - The line number didn't match up with my BM_ProductionRegister_upd.pvc from 4.40 PU2 where an Error 81 could occur. Maybe the same was true with Jeff. We don't know which PU you're on so best if you upload the actual BM_ProductionRegister_upd.pvc file. In general an 81 occurs when the columns of data for a table from the dictionary don't match up with the physical table. Notoriously this occurred time to time in the old days where UDF Maintenance would update the table for the current company with a new UDF added but not for all the companies. This is why I mentioned doing UDF Update for BM_BillOptionHeader. The same would be tried if you had just (re)installed a mod that changes the dict but it hadn't been activated for a company. Same if a PU with dict changes is installed but a company isn't converted.

At this point, I'd say make this your plan:
1. See if IM_ItemWarehouse has any UDFs and if so do an Update there.
2. Otherwise, make a copy company, and in the copy, do Option 3 mentioned in this post except substitute "A/P" for "B/M" and after running that, hit the up arrow button on your keyboard and run again for "I/M". Now try the Prod Reg Update  in the copy. If it works. repeat for live company.
3. Otherwise, upload the program here.



------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-21-2022 18:03
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Jeff Fiddelman BM_BillOptionHeader rebuilds fine. What am I looking for?​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-21-2022 16:34
From: Jeff Fiddelman
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Hi

Try looking at BM_BillOptionHeader

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 06-21-2022 16:27
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Can anyone else take a crack at this?

Can anyone tell me what the code is doing at that line?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 15:29
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

@Alnoor Cassim no UDF's have been recently added and none exist in BM_BillOptionHeader.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-20-2022 14:59
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Any chance you added a UDF to BM_BillOptionHeader recently? If so, go back to UDF Maintenance, and update it again, for the company code the Production Register Update was tried in. Then restart the Update. Hope that helps.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:

Did you try resetting BM_ProductionRestart (in a test company) to see if that would solve the error?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Kevin - That is a most interesting thought. There's a good chance this whole block of code would get skipped by deleting the restart key but then without it, Update may restart from the beginning key of BM_ProductionHeader and one would risk a lot of duplication of data in target tables. It may help though if just a few entries. Good idea to suggest doing it in a test company.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 06-22-2022 12:47
From: Kevin Moyes
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Did you try resetting BM_ProductionRestart (in a test company) to see if that would solve the error?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Deleting BM_BillOptionHeader.M4T and doing a manual reinitialize did not fix the error.
Deleting the restart record did not fix the error.
Rebuilding the Dictionary using the steps below returned a 0 for B/M and a 1 for I/M and did not fix the error.
oACT = NEW("Sy_Activation_bus",%sys_ss)
? oAct'Activate("B/M","ZCL") 
? oAct'Activate("I/M","ZCL") 

The end user is on 4.40.0.2, BUT, I discovered they have enhancements from IIG. Extended Decimal Places in B/M and unknown Custom Modifications.
I have attached BM_ProductionRegister_upd.pvc from their system.

@Jeff Fiddelman, @Alnoor Cassim & @Kevin Moyes I appreciate your time and I am more than happy to pay you to get this resolved.

​​​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-22-2022 13:21
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Kevin - That is a most interesting thought. There's a good chance this whole block of code would get skipped by deleting the restart key but then without it, Update may restart from the beginning key of BM_ProductionHeader and one would risk a lot of duplication of data in target tables. It may help though if just a few entries. Good idea to suggest doing it in a test company.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------


Original Message:
Sent: 06-22-2022 12:47
From: Kevin Moyes
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Did you try resetting BM_ProductionRestart (in a test company) to see if that would solve the error?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Greg - Sorry I just saw this now. I'll call you in the morning.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 06-22-2022 22:40
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Deleting BM_BillOptionHeader.M4T and doing a manual reinitialize did not fix the error.
Deleting the restart record did not fix the error.
Rebuilding the Dictionary using the steps below returned a 0 for B/M and a 1 for I/M and did not fix the error.
oACT = NEW("Sy_Activation_bus",%sys_ss)
? oAct'Activate("B/M","ZCL")
? oAct'Activate("I/M","ZCL")

The end user is on 4.40.0.2, BUT, I discovered they have enhancements from IIG. Extended Decimal Places in B/M and unknown Custom Modifications.
I have attached BM_ProductionRegister_upd.pvc from their system.

@Jeff Fiddelman, @Alnoor Cassim & @Kevin Moyes I appreciate your time and I am more than happy to pay you to get this resolved.

​​​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-22-2022 13:21
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Kevin - That is a most interesting thought. There's a good chance this whole block of code would get skipped by deleting the restart key but then without it, Update may restart from the beginning key of BM_ProductionHeader and one would risk a lot of duplication of data in target tables. It may help though if just a few entries. Good idea to suggest doing it in a test company.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-22-2022 12:47
From: Kevin Moyes
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Did you try resetting BM_ProductionRestart (in a test company) to see if that would solve the error?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

After Alnoor looked at the modified program, the actual file that was causing the error was BM_ProductionLabelPrint. Since they don't actually print labels we restored a copy of the file from an old backup and they are back up and running again.

Thank you everyone. Really appreciate the extra effort.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 06-22-2022 23:44
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - Sorry I just saw this now. I'll call you in the morning.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------


Original Message:
Sent: 06-22-2022 22:40
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Deleting BM_BillOptionHeader.M4T and doing a manual reinitialize did not fix the error.
Deleting the restart record did not fix the error.
Rebuilding the Dictionary using the steps below returned a 0 for B/M and a 1 for I/M and did not fix the error.
oACT = NEW("Sy_Activation_bus",%sys_ss)
? oAct'Activate("B/M","ZCL")
? oAct'Activate("I/M","ZCL")

The end user is on 4.40.0.2, BUT, I discovered they have enhancements from IIG. Extended Decimal Places in B/M and unknown Custom Modifications.
I have attached BM_ProductionRegister_upd.pvc from their system.

@Jeff Fiddelman, @Alnoor Cassim & @Kevin Moyes I appreciate your time and I am more than happy to pay you to get this resolved.

​​​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-22-2022 13:21
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Kevin - That is a most interesting thought. There's a good chance this whole block of code would get skipped by deleting the restart key but then without it, Update may restart from the beginning key of BM_ProductionHeader and one would risk a lot of duplication of data in target tables. It may help though if just a few entries. Good idea to suggest doing it in a test company.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-22-2022 12:47
From: Kevin Moyes
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Did you try resetting BM_ProductionRestart (in a test company) to see if that would solve the error?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Thanks for the followup.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------

Original Message:
Sent: 06-23-2022 11:41
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

After Alnoor looked at the modified program, the actual file that was causing the error was BM_ProductionLabelPrint. Since they don't actually print labels we restored a copy of the file from an old backup and they are back up and running again.

Thank you everyone. Really appreciate the extra effort.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 06-22-2022 23:44
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Greg - Sorry I just saw this now. I'll call you in the morning.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-22-2022 22:40
From: Greg Stiles
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Deleting BM_BillOptionHeader.M4T and doing a manual reinitialize did not fix the error.
Deleting the restart record did not fix the error.
Rebuilding the Dictionary using the steps below returned a 0 for B/M and a 1 for I/M and did not fix the error.
oACT = NEW("Sy_Activation_bus",%sys_ss)
? oAct'Activate("B/M","ZCL")
? oAct'Activate("I/M","ZCL")

The end user is on 4.40.0.2, BUT, I discovered they have enhancements from IIG. Extended Decimal Places in B/M and unknown Custom Modifications.
I have attached BM_ProductionRegister_upd.pvc from their system.

@Jeff Fiddelman, @Alnoor Cassim & @Kevin Moyes I appreciate your time and I am more than happy to pay you to get this resolved.

​​​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 06-22-2022 13:21
From: Alnoor Cassim
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Kevin - That is a most interesting thought. There's a good chance this whole block of code would get skipped by deleting the restart key but then without it, Update may restart from the beginning key of BM_ProductionHeader and one would risk a lot of duplication of data in target tables. It may help though if just a few entries. Good idea to suggest doing it in a test company.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:


Original Message:
Sent: 06-22-2022 12:47
From: Kevin Moyes
Subject: Sage 100 4.4 - Err 81, Pgm BM_ProductionRegister_upd.pvc, Line 1489 - Can anyone look this up?

Did you try resetting BM_ProductionRestart (in a test company) to see if that would solve the error?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.