You carried out an emergency maintenance on a key system and this resulted in an issue with the system Write a letter to the head of your data team. In your letter: - Provide an update on what happened - Explain what you're going to do about it - Say what you would like to him to do

Dear Mr Mondor, I am writing to notify you about an issue that took place during emergency maintenance on one of our key systems. Emergency maintenance was carried out on the biller management database during the wee hours of today.

This

resulted in a faulty operation in the data store,

hence

, customers were debited but their requests were not fulfilled successfully.

As a result

of

this

, about seventeen thousand requests were not fulfilled successfully. Owing to

this

, we have agreed to manually process affected transactions by doing the following.

Firstly

, identify transactions where the debit was successful or has a response code of "00" in the database.

Secondly

, update their posting status on the "transaction history" table to "00".

Thirdly

, change their "transaction status" to "failed" and "has been reversed" to "true".

Lastly

, finance credits affected customers manually using nerve ui.

In addition

to the procedure above, I have attached the necessary query to be used to query the datastore.

Also

, please note that the "kuda reference" is used as an instrument number by the biller management system. We implore that a team member from the data team is assigned to assist us with

this

request.

Moreover

, we can set up a call for

further

explanation as

this

is very urgent and customers are waiting for their reversals. Yours sincerely, Obumneme Odoh