/
Print Bills Statements Error executing insert_tmpexems

Print Bills Statements Error executing insert_tmpexems



Description of Issue

Receiving an error when running the Print Bills/Statements program

  • Error executing insert_tmpexems. -268 ISAM -2601

  • Cannot insert duplicate key row in object dbo.tmpexems with unique index tmpexems1



Context
  • GA Property Tax Billing

  • Print Bills Statements



Cause

Customer number is missing from the unique index. Exemptions where the category, year, parcel, exemption code, and bill number, where the Customer number is different between exemptions, will cause a duplicate error to occur like this. 

Parcel cannot have an exemption for two different CID numbers.



Resolution

Install the following release for resolution:

  • MUN-464891 (2019.1.22.2953)

  • MUN-464894 (2021.5.0.1680)

  • MUN-460277 (2021.6.0.1366)

  • MUN-464895 (2021.7.0.1066)

  • MUN-464896 (2021.8.0.752)

  • MUN-464897 (2021.9.0.359)



Additional Information

Contact Enterprise ERP Tax Support for further assistance.











Related content

Posted Abatement Report Error executing select into tmplst
Posted Abatement Report Error executing select into tmplst
More like this
Cannot insert duplicate key row in object error in Preliminary Bill Print
Cannot insert duplicate key row in object error in Preliminary Bill Print
More like this
Print Tax Bills Statements Open getDataForCachingBillState failed error
Print Tax Bills Statements Open getDataForCachingBillState failed error
More like this
Omitted Bills Error creating bill
Omitted Bills Error creating bill
More like this
New York Tax Roll GetAllProperties failed
New York Tax Roll GetAllProperties failed
More like this
Cannot insert duplicate key row in object dbo txspcasm with unique index txspcasm1 The duplicate key value is XXXX XXXX XXXXXXXXX in General Billing Transfer to Tax
Cannot insert duplicate key row in object dbo txspcasm with unique index txspcasm1 The duplicate key value is XXXX XXXX XXXXXXXXX in General Billing Transfer to Tax
More like this