Versions Compared

Key

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

Date

Authors

Marcello Fabbri (Unlicensed)

Status

Verifying on Prod

Summary

Bulk upload has stopped working resulting in error messages

Impact

No users can use Bulk Upload

...

Bulk upload of files on HEE Prod failed to upload, displaying an Unknown Server Error, due to the account used by bulk upload being disabled. Once reenabled, bulk upload went through well.

...

Trigger

  • KeyCloak issue - once fixed, Bulk upload appeared to workThe account used by bulk upload being disabled.

...

Detection

  • User notification on Teams.

  • Errors on the Bulk Upload page.

  • Error after successful completion of the upload job, as stated on the Export errors excel file

    Image Removed
Code Block
I/O error on PATCH request for "http://tcs:8093/tcs/api/bulk-people/": {  "timestamp" : "2021-03-18T14:18:03.153+00:00",  "status" : 500,  "error" : "Internal Server Error",  "message" : "",  "path" : "/tcs/api/bulk-people/"}; nested exception is java.io.IOException: {  "timestamp" : "2021-03-18T14:18:03.153+00:00",  "status" : 500,  "error" : "Internal Server Error",  "message" : "",  "path" : "/tcs/api/bulk-people/"}

Resolution

  • User

...

Resolution

  • Disabled user got reenabled in Keycloak.

...

Timeline

  • : ??:?? Users got disabled in usermanagement

  • : 12:52 Mike Richardson reported an issue with Bulk upload on Teams.

  • : 13:47 Got LOG ID of the file from S3 and tried to Tried re-upload the same file, resulting in the same error.

  • : 13:52 User reenabled in keycloadkeycloak, bulk upload went through.

  • : 13:54 Asked users to try and re-upload.

  • : 14:18 Mike Richardson reported an Internal Server Error as Reason for import failure when uploading a file.

...

Root Cause(s)

  • Bulk upload failed to connect to TCS.

  • Bulk upload user was disabled.

  • The bulk upload user was listed in a report of potentially outdated accounts.

  • The bulk upload has a transformuk email address.

  • Email address was never updated.

...

Action Items

Action Items

Owner

Update the email address of all sensible users (in prod and stage)

John Simmons (Deactivated)

Check keycloak to find other users with outdated email addresses and update them (in prod and stage)

Edward Barclay

Lessons Learned

...

Create a slack channel with email accounts associated to it to receive notifications for when passwords need resetting or logins are denied etc.

John Simmons (Deactivated)

...

Lessons Learned