txprecom Execute insert tmpchg failed Cannot insert duplicate key row in object error when running Preliminary Commitment Book



Description of Issue

When running the Preliminary Tax Commitment book, the error txprecom Execute insert_tmpchg failed - status -268 Cannot insert duplicate key row in object 'dbo.#tmpchg' with unique index 'tx_tmpchg1' The duplicate key value is (X, XXXXXX) is received. 



Context
  • Property Tax Billing

  • Preliminary Commitment Book (txprecom)



Cause

One or more parcels or properties has a duplicate charge attached to it. 



Resolution

Please contact software support. A script can be run to identify the parcel or property with the duplicate charge attached to it. 



Additional Information

If additional assistance is required, please contact Tax Support for the appropriate region.Â