Non-technical Description

An issue was discovered (on 11th Oct 2023) where TIS Data Extracts' refresh were failing since the 2 days prior. The impact of this was the data Data in some of the TIS reports were stale and reflected what was on TIS from the last successful refresh.

Trigger

Detection

Email notifications in James Harris inbox

Resolution

Timeline

BST unless otherwise stated

• 11 Oct 2023 09:42 James Harris Raises the alarm on the number of email notifications in own inbox about failed tableau refreshes on TIS PID Data site

• 11 Oct 2023 10:15 - PO and team informed. Brief team discussion on priority and problem resolution delegation

• 11 Oct 2023 11:00 - Quick analysis of number of data sources with failed refreshes and dates of last successful refresh established

• 11 Aug 2023 11:56 - Tableau Administrator/Data Service team got notified

• 11 Oct 2023 14:09 - Tableau Administrator/Data Service team confirms identification of the root cause of the problem

• 11 Oct 2023 13:00 - Commenced further analysis to establish scope/coverage of the problem and identify extent of stale data

• 12 Oct 2023 07:21 -

• 12 Oct 2023 07:29 -

• 12 Oct 2023 11:35 -

• 12 Oct 2023 14:23 -

• 12 Oct 2023 14:38 -

Root Cause(s)

Action Items

Lessons Learned

• We were fortunate that the Site Owner was working.