Print Bills Statements Error executing insert_tmpexems

Owned by Knowledge Assistant
Last updated: Aug 10, 2023
1 min read



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.