Hey Everyone,
We recently upgraded from 4.3 to 4.5. Since upgrading, we have experienced interrupted update errors and "107 Keyed file error (Wrong key block addr)" errors. From what I understand, interrupted updates can cause data corruption, which is what may be leading us to the 107 errors. Is that right? We have been able to correct these issues on a case by case basis by working with Sage support, but I wondering why we are seeing this issue in the first place. We never experienced this issue in 4.3.
I have heard users say that updating and running reports is considerably slower in 4.5, but I cannot see why. From what I understand, the errors above are generally caused by system crashes or network issues. Maybe we didn't see these issues before because the processing time was so much faster in 4.3 and therefore minimized the chances of a network issue affecting processing. If we go that route, why is 4.5 so much slower?
Our server is on a virtual Windows 2008 setup with 4 gb of ram and an Intel Xeon 2.9GHz processor. We probably have anywhere from 7-10 users on the system during our busiest hours. We looked at CPU utilization and we average below 10 percent usage with no considerable spikes. There are no issues with our network connection and none of the users who have had this interrupted update issue have reproted MAS200 or their PC crashing. All users are on Windows 7 with 4-8gb of RAM and 8 cores. I have been running ping tests from different client machines to and from the server, experiencing no packet loss and response times are always less than 1ms.
Does anyone have any ideas of what might be causing our issue. The first thing that our reseller asked is what kind of network cards we are using on the client machines. He said that realtek cards have been known to cause this kind of an issue. All of our users are using Intel cards, so this is out.