If the Active Link is corrupted in the meta tables somewhere it could cause this.
Also I believe Active Links write to the log after they complete running Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 18, 2008 1:41 PM To: arslist@ARSLIST.ORG Subject: Re: Server Hangs ** Help............ I believe we may have found the culprit of our server hang ups. I believe we've traced it to an Active Link (which really confuses me) and I'm hoping that someone might have a clue as to why. The strangest thing is that the server seemed to hang as soon as the Active Link was enabled, without even firing. Is this even possible? I'm not 100% sure this is the problem, but it's really starting to look like that might be it. I can attach the def file for the Active Link if anyone wants to see, but below are the actions it performs. I have the Active Link performing 4 actions and being triggered by a button press. Action 1: Set Fields = Sets a value to a display only field with the change flag disabled. (the path for the report generated in action 2) Action 2: Open Window = Open the report form and runs a predefined report and saves as .csv on local machine. Action 3: Run Process = C:\Program Files\Microsoft MapPoint\mappoint.exe /U "C:\SOC Apps\SOC_MapIt.ptm" (This updates the map file which is linked to the csv file created in action 2. Action 4: Open Window = Opens a confirmation box window. (I have another separate active link that fires after this one that closes the confirmation window... I know........I have no idea why I did it this way. Anyone have any ideas? I am thoroughly confused. Windows Sever 2003 MSSQL 2000 SP3 ARS 7.0.01 Patch1 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 17, 2008 5:08 PM To: arslist@ARSLIST.ORG Subject: Re: Server Hangs 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: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
