| Date | 2017-08-14 |
| Authors | |
| Status | Complete |
| Summary | Hicom's DR refresh failed so the TIS ETLs only had access to the previous day's data. |
| Impact | Revalidation nationally had stale data. |
Root Cause
Hicom have a changed the following;
HEELIVE.vwPerson we got error today because the datatype of column DisabilityDetails is TEXT in mirror but in DR its varchar(max), I will change the column datatype in mirror
HEELIVE.vwLeaveExpense the datatype of column Comments has TEXT in mirror but in DR its varchar(max)
Trigger
Their nightly scheduled update.
Resolution
Updated Mirror table definations
Detection
Ran daily row count checks between DR and Mirror and noted the following differences;
| owner | tab_name | rc | distinc_rc | Vlookup Mirror RC | RC Diff | Duplicates exist in DR | |
| HEELIVE | vwCourseAttendanceStaff | 38448 | 38448 | 38430 | -18 | No | |
| HEELIVE | vwLeaveExpense | 157747 | 157747 | 157684 | -63 | No | |
| HEELIVE | vwPerson | 57494 | 57494 | 57493 | -1 | No | |
Action Items
| Action Item | Type | Owner | Issue |
|---|---|---|---|
| mitigate/prevent |
Timeline
Supporting Information
e.g. monitoring dashboards
0 Comments