Date of Incident: 05/22/2019
Time/Date Incident Started: 05/22/2019, 9:41 pm EST
Time/Date Stability Restored: 05/22/2019, 10:59 pm EST
Time/Date Incident Resolved: 05/22/2019, 1:25 pm EST
Users Impacted: Active users
Incident description: Performance issues impacting the ability for Providers to view the Proposals page.
Root Cause Analysis:
Transient errors occurred during a deployment. These errors left the database in an inconsistent state and impacted the proposals module.
Identified the missing database changes.
Restored the database changes and stored procedures.
Modified the filters on the SQL compare process which reduces the risk of all SQL updates during deployments.