Data Issues
I was up late again last night. Actually it’s the first time I have stayed up programming past midnight since we returned from vacation. I went to bed after 01:15 and was awake past 02:30.
Why?
I am having a problem with data not updating consistently on the CRM at the office. Everything works fine on my home/dev network (of course). The transactions appears to work correctly on the office network. The app loads. Data is returned and populated into the grid. Items can be editted. The problems start (or don’t) when you click save after making a change to the data. The event appears to work, but the item refresh restores the original values. The main grid (which is visable behind the edit screen) shows the new/updated information. Close the edit screen and click refresh. The original data returns. WTF? Restart the app. The original data is still there. All edits were disgarded. Really? WTF?!?
So what is different? There is a domain at the office, but I’m using SQL Authentication so it shouldn’t matter. That’s it. I’m running a Win2003 SQL 2005 EE VM, which mimics the office setup. All functions are working correctly on the dev environment at home. There are no errors in the Event Viewer or in the SQL logs.
WinForms, C# 3.5, MS SQL 2005 EE
I need to run SQL Profiler to gather more info. Beyond that, I’m clueless. What is really happening? Why does it work in dev and not in prod? I guess it is time to post my question on Stack Overflow.
I setup triggers (insert/update/delete) on the database. Nothing happened. So… The app was not actually sending the update stream to the database. The easiest solution was to role back the install to a previous version. This didn’t help me understand what went wrong but it did get a working version of the app back on to user desktops before Monday at 8am.