| 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. |
| Table of Contents |
|---|
Root Cause
...
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
...