/
Tyler Deploy Fails Database Deployer Duplicate StateReporting Key

Tyler Deploy Fails Database Deployer Duplicate StateReporting Key

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