TA Upgrade failed to v2023.3.1 on Wait for EAR Deployment

Description of Issue

Upgrade to v2023.3.1 failed in Tyler Deploy

The following error was found in the Time and Attendance application log:

Caused by: liquibase.exception.DatabaseException: The DELETE statement conflicted with the REFERENCE constraint "f_event_rule_2". The conflict occurred in database "ET_test", table "dbo.event_rule", column 'event_id'. [Failed SQL: (547) DELETE FROM event WHERE event_id = 7]

Context
  • Upgrade

  • T&A

  • ExecuTime

  • v2023.3.1 only

Cause

Caused by a dependent key constraint in the database

Resolution

Create case with Time and Attendance TSM Team for further assistance

Additional Information