Classification: UNCLASSIFIED
Caveats: NONE
Norm,
To prevent certain Advanced Query searches, you can drop the Reserved
Field (1005) on the form and use and AL to inspect the value (On
Search). Throw an error if the value contains the diary field name
('DIARYNAME'). This will allow you to exclude certain fields from being
used and even prevent use of LIKE statements.
Christopher Michaud
Remedy System Administrator/Developer
US Army Medical Information Technology Center (USAMITC)
Core Technology Division - Systems Engineering Branch
Office: 210.295.3589
DSN: 421-3589
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
No...can't do that. Thanks for the suggestion, but that won't work.
Users still need to construct advanced searches. I just need to block
them from skirting my AL that blocks them from searching the worklog.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C.
Sent: Monday, November 24, 2008 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Just turn off the advanced search option from the Form -> Current View -
> Properties -> Menu Access menu.
-Matt
Matthew C. Gayford
Application Developer & Remedy Administrator
University of North Carolina Wilmington
(910) 962-7177
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
How do you block searches done on the Advanced Query Bar?
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge
Sent: Monday, November 24, 2008 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.
HTH,
Rootuja
_____________________________________________
Rootuja Ghatge
Senior Application Developer
CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com
________________________________________
This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please
contact the sender and delete all copies.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance
OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets. I was able to reproduce the behavior multiple times by doing a
diary search myself.
So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Norm,
You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?
Christopher Michaud
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance
**
Hi everyone:
This problem has me perplexed.
At a site I support, the Remedy server inexplicably stops responding to
requests. It's very intermittent. It runs fine for awhile, then
seemingly without warning, it just hangs. Users attempting to log on
get stuck at the "Setting server port" dialog, which eventually times
out.
Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.
To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.
Any ideas what might be causing this?
- I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization
- Network utilization is flat-lined whenever this occurs (i.e.,
no spike)
- Memory utilization appears normal
- CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)
Any thoughts are greatly appreciated.
The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.
Norm
Remedy ARS 6.3
Microsoft SQL 2000 SP4
Microsoft Windows 2000 SP2
100% Custom Apps - No ITSM
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
Classification: UNCLASSIFIED
Caveats: NONE
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Classification: UNCLASSIFIED
Caveats: NONE
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
