I do admire people with guts. Early this week I received a copy of an e-mail between Frank and Chris. It was regarding an issue of ‘unexpected moved objects’ from a production to the historic database. This was apparent a major issue, since I overheard my colleagues talking about it to several angry end users.
Frank: I see no issue on your list (see e-mail last week) concerning the moved 20.000 object to the historic database to bring them back to the production database. Please send us an update of the status of this issue? I already expected a Patch.
Chris: A patch will be provided today or tomorrow, we are preparing the delivery.
Frank: What do you advise to test this patch? How did you test this on your side?
Chris: We will deliver a little tool; there is no change on the application. The tool will create extended logs, showing which objects were successfully restored, and which not. The tool will be provided with some instructions how to use it. We tested the tool with current database backups, and it worked. We also verified that all data is restored. Some objects won’t be restored, since related objects could be deleted in the meantime. We do not restore inconsistent data, meaning if the related data cannot be found anymore, this particular object is not restored. All information is presented in the logs, so you can make a match of the objects that should be restored and the objects that are actually restored. In my point of view, you should run it and make some spot tests and compare the data before and after restoring.
Okay so what is happening here? We somehow lost data from the production database, which is causing trouble for end users (duh!). We should fix that issue of course, asking a patch is justified here. Then a very good question: asking advice how to test the patch. Then the guts comes into play. Don’t you just love phrases like; “A little tool, some instructions, some objects, inconsistent data, just run the tool, do some spot tests.”
Great example of the use of lullaby language! It will take serious guts to run this tool based on this story.