2017-07-04 Hicom UAT DR Refresh Failed

Date2017-07-04
AuthorsGraham O'Regan (Unlicensed)
StatusComplete
SummaryThe UAT DR refresh failed which was being used to populate the Revalidation data for HEWTV and HESWT
ImpactRevalidation was unavailable in HEWTV, HESW wasn't live at that point.

Root Cause

Hicom's refresh failed so the ETLs couldn't load any data

Trigger

Nightly refresh of data

Resolution

Hicom reran the refresh and we reran the ETLs for those teams.

Detection

Email from Hicom

Action Items

Action ItemTypeOwnerIssue
We added monitoring to check that the DRs and mirror matchmitigateGraham O'Regan (Unlicensed)

Timeline

9:23 Yvonne emailed us to let us know

11:00 We reran the ETLs

Supporting Information

Email from Yvonne to Ben and Graham O'Regan (Unlicensed)

The UAT DR failed to run last night. This was due to the additional views we have added for 10.90 structure. We have resolved these issues and are re-running it now.

Please can you inform the relevant parties in the South.

Graham, once the UAT DR has completed its run I will re-enable your system account for access.

The Live DR and HEE DR are unaffected.