Tyler Deploy Fails Database Deployer Duplicate StateReporting Key

Owned by Knowledge Assistant
Sept 19, 2024
1 min read
Description of Issue

When running an update to Enterprise ERP production, it is failing with the following error from the output log:

2024-09-11 11:02:12.69402: Exception Occured During Processing:
System.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'StateReporting.TXTSDSSSAMaintenance' and the index name 'IX_TXTSDSSSAMaintenance_Unique'. The duplicate key value is (XX, XXXXXX, <NULL>).

Context

  • Enterprise ERP

  • Tyler Deploy

  • Updates

  • Database

Cause

Update needed.

Resolution

This issue has been resolved with a MUN. Please install the MUN corresponding to the version being ran or upgrade:

2021.10 - MUN-492622
2021.11 - MUN-492631
2021.12 - MUN-492632
2024.1 - MUN-492633
2024.2 - MUN-492634

Additional Information