/
2020-07-08 TIS NDW Failure

2020-07-08 TIS NDW Failure

Owned by Joseph (Pepe) Kelly
Last updated: 08 Jul 2020
1 min read

Date

Jul 8, 2020

Authors

@Joseph (Pepe) Kelly

Status

 

Summary

TIS NDW ETL Failed

Impact

Delay in information available to NDW

https://hee-tis.atlassian.net/browse/TISNEW-4951

Root Cause(s)

  • Unable to get connection to MySQL

Trigger

  • Dropped/Unhealthy connection

Resolution

  • Ran tis-ndw-etl-parameterized job which stopped the existing ‘spinning’ job.

  • Informed NDW team in tis_ndw_etl channel.

Detection

  • Slack monitoring

 

Timeline

  • 04:22 - Slack Alert

  • 07:45 - re-running ETL

  • 08:10 - ETL finished

  • 11:14 - NDW team scripts completed

Related content

2020-05-21 TIS NDW Failure
2020-05-21 TIS NDW Failure
TIS21 Confluence Space
More like this
2018-07-02 TIS-NDW ETL failed to run Sat/Sun/Mon morning
2018-07-02 TIS-NDW ETL failed to run Sat/Sun/Mon morning
TIS21 Confluence Space
More like this
2023-04-11 ndw-etl-prod task was not run
2023-04-11 ndw-etl-prod task was not run
TIS21 Confluence Space
More like this
2021-07-23 NIMDTA TIS-NDW ETL failure
2021-07-23 NIMDTA TIS-NDW ETL failure
TIS21 Confluence Space
More like this
2023-11-06 NDW update failed to finish by the normal time
2023-11-06 NDW update failed to finish by the normal time
TIS21 Confluence Space
More like this
2021-03-10 The NDW ETL failed and didn't recover for PROD & STAGE
2021-03-10 The NDW ETL failed and didn't recover for PROD & STAGE
TIS21 Confluence Space
More like this

Slack: https://hee-nhs-tis.slack.com/
Jira issues: https://hee-tis.atlassian.net/issues/?filter=14213