We've begun having a strange problem. Our server has begun to hang making searching or creating records on most forms impossible. It will still allow you to log in and work with some of our smaller forms (6 or so fields), but it makes our Trouble Report form hang.
The error message you get after a few minutes states: "ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation :" You have to either restart the services or totally reboot the server to recover. Below I've listed a couple of symptoms that seem odd to me. 1. You can search for a specific ticket number and get the results just fine, but if you search something that will return multiple results it hangs. 2. As stated above, searching for multiple results causes it to hang, but it will populate tables with multiple results with no problems and will allow you to refresh them with no issues at all. Windows Server 2003 MS SQL 2000 SP3 Windows XP Pro Clients with WUT 7.0.01 P5 (some users may still have older versions) Has anyone seen anything like this before? Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"