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