Error #11: Record not found or Duplicate key on write PRWUBA 2110

When we try to run Check Register/Update we first get Update Interrupted. Do you want to restart? If you click No nothing happens if you click yes it then gives the Error #11.

Details of error 

Error #11: Record not found or Duplicate key on write

Program PRWUBA       LINE 2110

09020C:\data\Apps\Sage100\MAS90\pr\PRWUBA
02010C:\data\Apps\Sage100\MAS90\soa\SWERRM
07072C:\data\Apps\Sage100\MAS90\Home\lib\_winproc
02100C:\data\Apps\Sage100\MAS90\soa\swerrm

Any help would be greatly appreciated. 

  • 0

    Here's what Sage KB say's: 

    Error 11 PRWUBA 1410, when updating the Payroll Check Register. 

    Cause

    • Repair the Payroll data entry files.
      1. Rebuild the following key files:
        • PR6 (P/R Payroll Data Entry File)
        • PR8 (P/R Payroll Data Entry Tax Summary File)
        • PR9 (P/R Payroll Check Printing Detail File)
        • PRA (P/R Payroll Sort Temporary File)
        • PRD (P/R Payroll Earnings/Deductions Master File)
      2. Analyze and relink the following file:
        • PR7 (P/R Payroll Data Entry Line Detail File)
      3. Rebuild Payroll sort files.
    • If the error still occurs, perform the following:
      1. Restore the ..\Mas90\PRxxx folder from a backup created before the update (xxx = company code).
      2. Rename and manually reinitialize the following files:
        • PR6 (P/R Payroll Data Entry File)
        • PR7 (P/R Payroll Data Entry Line Detail File.)
        • PR8 (P/R Payroll Data Entry Tax Summary File)
        • PR9 (P/R Payroll Check Printing Detail File)
        • PRA (P/R Payroll Sort Temporary File)
      3. Process Payroll data entry again.

  • 0 in reply to Wayne Schulz

    After running the first method of rebuilding keys analyze and re-link rebuild sort files

    it now say's Missing record E24

    File providex.ddf  P/R Earnings/Deduction Master File

    Channel 550

    Key E24

  • 0 in reply to Kev_Lop

    I suggest following the 2nd steps recommended. In my experience even though the program is the same, the line in which the error is occurring on makes it a huge difference. If that doesn't resolve it call support and they can run SYZCON and debug the code.

    1. Restore the ..\Mas90\PRxxx folder from a backup created before the update (xxx = company code).
    2. Rename and manually reinitialize the following files:
      • PR6 (P/R Payroll Data Entry File)
      • PR7 (P/R Payroll Data Entry Line Detail File.)
      • PR8 (P/R Payroll Data Entry Tax Summary File)
      • PR9 (P/R Payroll Check Printing Detail File)
      • PRA (P/R Payroll Sort Temporary File)
    3. Process Payroll data entry again.
  • 0 in reply to Rafael Casas

    What does it mean by Rename?

    Does everyone have to be out of Mas to do this?

    When I manually reinitialize the file what do I put for Type Key Size and Bytes per Record?

    Thank you

  • 0

    Kev_Lop, I would strongly recommend you involve your Sage partner before re-initializing files.  But if you don't, please, please make backups of everything!

  • 0 in reply to Rsmcnamara

    We did not renew our contract for sage support. We are in the process of setting up a different system. We are going away from sage within the next few months. This problem just came out of no where. 

  • 0 in reply to Kev_Lop

    Does earnings code 24 exist?  This error seems to think that the earnings code is used in the pay run on an employee but does not exist in the maintenance program

  • 0 in reply to daburke

    Yes there is a code 24 is called Bonus Plan.

    When doing any of the following should everyone be out of Sage? 

  • 0 in reply to Kev_Lop

    You first have to browse out to the MAS_XXX folder (XXX = Company) and then to the PRXXX folder (PR=Payroll).

    Then add a .x after the .SOA. This will rename the file. Then go to the Manually Reinitialize section as you've already been to and type in PR6xxx in this case PR6ABC and hit the tab button and then proceed and your're done with that file. Do this for all files that are instructed in the instructions.

    Example below:

    C:\Sage\Sage 100 Standard\MAS90\MAS_ABC\PRABC

    Normally, you have to be very careful with this as this clears out any data. However, in this case you are only recreating Payroll Data entry files and nothing historical.