/
2020-07-27 ESR Applicant Export Failed

2020-07-27 ESR Applicant Export Failed

 

Date

Jul 27, 2020

Authors

@Joseph (Pepe) Kelly

Status

 

Summary

TIS ESR ETL Failed

Impact

N/A

 

  • Root Cause(s)

  • Trigger

  • Resolution

  • Detection

  • Action Items

  • Timeline

Root Cause(s)

  • The call to update the ESR database failed.

  • ESR reported that the ETL was unauthorised (HTTP 401)

Trigger

  • Failed update to ESR service

Resolution

  • Disabled the following notification tis-esr-etl-cron-daily-export job so the applicant export would be able to finish.

  • Restarted esr & profile service on ‘green’ stack.

  • Manually triggered the tis-esr-etl-cron-applicant-export job and then the tis-esr-etl-cron-daily-export job.

  • Checked slack message showing files transferred at 18:00.

Detection

  • Message via. monitoring channel

Action Items

Action Item

Owner

Issue

Action Item

Owner

Issue

Trigger scheduled tasks differently.

 

 

Timeline

  • 16:45 to 17:53 - Message picked up and investigation to re-run the affected jobs

  • Confirmed uploaded files the following day

 

Related content

2020-07-08 TIS ESR App Export Failure
2020-07-08 TIS ESR App Export Failure
More like this
2020-08-05 ESR Applicant Load Failed
2020-08-05 ESR Applicant Load Failed
More like this
2018-10-17 ESR ETL failed
2018-10-17 ESR ETL failed
More like this
2021-08-02 Placements not being exported to ESR
2021-08-02 Placements not being exported to ESR
More like this
2019-05-31 Missing ESR app files for 7th August Starters
2019-05-31 Missing ESR app files for 7th August Starters
More like this
2019-02-22 ESR ETL problems (1 of 5 processes)
2019-02-22 ESR ETL problems (1 of 5 processes)
More like this