Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Date

01 Apr

Authors

Stan Ewenike (Unlicensed) James Harris

Status

Documenting

Summary

Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTIS21-5196

Impact

Data in some of the TIS reports were stale and reflected what was on TIS from the last successful refresh

...

Detection

Email notifications in James Harris Site Owner’s inbox

...

Resolution

Re-application of missing permisssions on the NDW service account used to refresh data extracts on Tableau Server to re-enable refresh

...

Timeline

BST unless otherwise stated

  • 09:42 James Harris Site Owner raises the alarm on the number of email notifications in own inbox about failed tableau refreshes on TIS PID Data site

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

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

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

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

  • 13:00 - Further analysis to establish scope/coverage of the problem and extent of stale data

  • 07:21 - Requested progress update on permanent fix from Tableau Administrator/Data Service team

  • 07:29 - Updated PO on state of affairs at the time

  • 09:33 - Received confrmation of permanent fix in progres from Tableau Administrator/Data Service team

  • 11:35 - Communication sent out on MS Teams channels to stakeholders

  • 14:23 - Received notification of completion of permanent fix and verified data sources now refreshed

  • 14:38 - Updated stakeholders on MS Teams channels

Root Cause(s)

Modifications made to the permissions on the NDW service account used to refresh data extracts on Tableau Server

...

Action Items

Action Items

Owner

...