The client loads the AL after its enabled if the form(s) that it is attached to is opened. If that AL was for some reason courrupted in its definition, just the opening of the form was enough to load that AL, and maybe that sent a signal of some sort to the server to cause it to hang..
Joe ________________________________ From: "Mayfield, Andy L." <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, November 19, 2008 9:29:35 AM Subject: Re: Server Hangs ** My server guy said he didn’t see any files growing in the temp directory. We did however go ahead and trash the recently created AL’s and so far so good. I am still somewhat perplexed as to how an AL can cause this problem. You didn’t even have to run it; just enabling it would cause the problem to start. 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: Tuesday, November 18, 2008 11:02 PM To: arslist@ARSLIST.ORG Subject: Re: Server Hangs Did you notice any files in your Temp directory that might be growing constantly eventually filling up the entire disk space? I'm assuming no since you said you would check on that.. If you suspect that AL, why not delete it and recreate it? After deleting it check the underlying meta tables like actlink_set, actlink_open, actlink_process to make sure that all references to that AL have been deleted after it is deleted from the Admin tool. Since its a suspect AL, you want to make sure that it doesn't get deleted 'leaving a few traces' behind. I've not seen something like this too often but there is always a first time.. Joe ________________________________ From:"Grooms, Frederick W" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, November 18, 2008 2:50:25 PM Subject: Re: Server Hangs ** 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"