Date	2017-08-14
Authors	Russell Steel (Unlicensed)
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

TIS21 Confluence Space

2017-08-14 Hicom DR refresh failed

Analytics