Error executing the SQL statement insertBill when generating AR

Owned by Knowledge Assistant
Last updated: Apr 26, 2023
1 min read



Description of Issue

When trying to run the Generate AR process, receive An error occurred while executing the SQL statement insertBill related to attempted duplicate insert of a bill record.



Context

  • Utility Billing Classic

  • UB Classic

  • Bill Run Process

  • Generate AR

  • AR Rewrite



Cause

A previous Generate AR did not complete successfully and has left partially-processed bill records in the database.



Resolution

Contact support to review the data. 



Additional Information