Check the Windows Temp driectory. Check at the time when you perform certain operation if there is a temp file that gets created that keeps growing indefinitely to a point it starts eating out most of your disk space.
If you notice this, yes we are facing a similar problem and I am still in the process of troubleshooting it. For us it turns out that there are some fields that have somehow got corrupted in their definitions on the forms that result in this problem. Using a debug version of the arserverd process, I am in the process of finding which fields are causing this problem and eliminating it by changing the properties of the field and saving it. Joe ________________________________ From: "Mayfield, Andy L." <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, November 17, 2008 5:45:38 PM Subject: Server Hangs 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"
