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

__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"

Reply via email to