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.
  
  
  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.