Well, I slept at around 5:00 am, after fighting with repositories and databases. I woke up at around 11:15 am. I checked my work mail, and general stuffs. In a while, the maid servant came in, so I had my breakfast then. After the fight last day, I was determined to move ahead and look into the issues. So, I started working. Most of the mid day was spent understanding their code and structure. There was an issue with one table, which caused a hell lot of problems later on. Anyways, I ate my lunch in between at around 4:30 pm. I didn't have any appetite till then. After that, we had a call at 5:15 pm. In the call, we explained our situation, and came to know that all the action items are to be finished by today. The deadline was ridiculous, and we already knew that it couldn't be met. Anyways, I started working on my action item. I rectified a few things here and there, but the problem with this one table couldn't be rectified. I tried all means, but every time the data failed to load into that particular table. I checked everything in the source xml files, the Informatica mapping, the DT mapping, but couldn't find anything that would cause this problem. This whole time I was trying to figure out the issue, and hence a lot of time was wasted on this. In addition to this, the person on the client side is too inarticulate to explain the issues or solutions. So, everything was haphazard. Ankit was also getting frustrated with his action items. He was facing a version issue. Gotham, the lead on the client side, was calling me regularly to seek updates, and it was a frustrating task to explain a non-technical guy the reasons for the data coming and not coming. Anyways, after lots of debugger sessions, and log search, I finally concluded that the problem is in the final stage where the data gets written to the database table. Meanwhile, I had a quick dinner and it was then that I found out that Mumbai Indians are losing the match against RR by 10 wickets. I was surprised to see the downfall of Mumbai Indians in the recent times. Returning to the work, we had a call with Gil late at night, where he gave us some direction. Using that, I moved on and figured out the root cause. Then, I proceeded step by step and finally reached the horizon - both in reality and in essence of code. It was around 5:30 am, when I mailed them that the problem has been fixed, and it is working now. After that, I slept after watching the CSI:Miami episode. I completed the season 3 today.
