Issue

I have a batch that is marked for posting in Payroll which states checks are currently being printed. How do I unmark the batch?

The following error messages may also occur to indicate the Payroll batch is stuck:

• "Open operation on UPR_Temp_Post2 has incorrect record length"

• "Remove Range Operation on Table ddDeposits has caused known error 2"

• "Batches with zero transactions cannot be marked"

• "Another user is performing a check run"

• "UPR_Work_Post failed accessing SQL data"

• "The employee record cannot be inactivated or deleted Pay run is in progress for this employee"
  
  Also, an Open Operation, Get/Change, or Save Operation error may occur on one of the following files to indicate the Payroll batch is stuck:
  UPR_WORK_MSTR
  UPR_WORK_MSTR_Detail
  UPR_WORK_HDR
  UPR_WORK_Pay_Type
  UPR_WORK_Deduction
  UPR_WORK_Benefit
  UPR_WORK_State_Tax
  UPR_WORK_Local Tax
  UPR_WORK_Check
  UPR_WORK_Post
  UPR_Flat_Tax_Records
  UPR_Account_Cache
  
  
  Resolution - SQL or MSDE  (scroll down for PSQL)   
  
  Perform the following steps to eliminate any of the errors mentioned above:
  
  1. Run the following script in Query Analyzer or the Support Administrator Console on MSDE against the COMPANY database.  Note - The first two lines in the script will delete the contents of the activity files in the Dynamics database and the rest of the files will delete the contents of the work and activity files in the Company database.
  
  Delete DYNAMICS..UPR10300
  Delete DYNAMICS..UPR10304
  Delete UPR10200
  Delete UPR10201
  Delete UPR10202
  Delete UPR10203
  Delete UPR10204
  Delete UPR10205
  Delete UPR10206
  Delete UPR10207
  Delete UPR10208
  Delete UPR10209
  Delete UPR10213
  Delete UPR10301
  Delete UPR19900
  Delete UPR19901
  
  2. Open Windows Explorer and select the Temporary directory (C:\Windows\Temporary). Delete the files in the directory that begin with "TNT" and delete the files that have a "tmp" extension.
  
  3. If you have Direct Deposit, run the following scripts:
  
  Delete DD10100       (Direct Deposit Employee Deposit Work)
  Delete DD10200       (Direct Deposit ACH Copy)
  Delete DD10300       (Direct Deposit ACH Cross Reference)
  Delete DD10400       (Direct Deposit ACH Header) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.)
  Delete DD10500       (Direct Deposit ACH Items) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.)
  Delete DD10600        (Direct Deposit Prenotes Completed)
  Delete DD10700        (Direct Deposit Exceptions)
  
  4. In Dynamics, go to File | Maintenance | Check Links (make sure everyone is logged out).  Choose Payroll for the Series and insert the Payroll Transactions.  Process this.  You will get errors on the error log which you can ignore as the Check Links process is re-attaching the Batch ID to the existing transactions.
  
  5. Build the check file again; all batches will still be there.
  
  Note:
  If you have recurring batches and you delete the UPR10301 above, when you run check links the frequency will default back to single use.  Before posting the batch, you will need to go to Transactions | Payroll | Batches pull up the recurring batch and change the frequency to something other than Single.
  

  
  Resolution - PSQL
  

  Perform the following steps to eliminate any of the errors mentioned above:
  
  1. Rename the Payroll activity files in the System folder: UPR10300 and UPR10304. To rename a file such as UPR10300.btr, rename it to UPR10300.old.
  
  2. Rename the following Payroll check work files in the Payroll folder:

  UPR10200 through UPR10209
  UPR10213
  UPR19900 
  UPR19901

  3. Rename the Batch Header file (do not delete this file):  UPR10301.
  
  4. Open Windows Explorer and select the Temporary directory (C:\Windows\Temporary). Delete the files in the directory that begin with "TNT" and delete the files that have a "tmp" extension.
  
  5. If you have Direct Deposit, rename the following work files located in the Payroll folder.

  DD10100  Direct Deposit Employee Deposit Work
  DD10200  Direct Deposit ACH Copy
  DD10300  Direct Deposit ACH Cross Reference
  DD10400  Direct Deposit ACH Header - If this file is renamed or deleted, you will
  lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file)
  DD10500  Direct Deposit ACH Items - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file)
  DD10600  Direct Deposit Prenotes Completed
  DD10700  Direct Deposit Exceptions
  

  6. In Dynamics, go to File | Maintenance | Check Links.  Choose Payroll for the Series and insert the Payroll Transactions.  Process this.  You will get errors on the error log which you can ignore as the Check Links process is re-attaching the Batch ID to the existing transactions.
  
  7. Build the check file again; all batches will still be there.
  
  Note:
  If you have recurring batches and you delete the UPR10301 above, when you run check links the frequency will default back to single use.  Before posting the batch, you will need to go to Transactions | Payroll | Batches pull up the recurring batch and change the frequency to something other than Single.