Eric,
Some additional ideas come to mind
1. Could be some funky active links - did you
create/modify AL's for the enhance form? If so disable them
2. I have also seen weird things (like this) happen
if there is a table field on the form that somehow has the fully
qualified server name (instead of short name)
3. Double check the indexing on the enhanced form (rebuild in
needed)
Doug
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric
Sent: Thursday, December 28, 2006 11:26 AM
To: [email protected]
Subject: Re: Issues after new schema implementation & enhancements
If I run the query in Query Analyzer - no there are no more records. I
get the same amount of records back with no hanging come back within a
couple of seconds where as the client takes several minutes....
Something in the API? or defunct workflow?
How do I go about taking this down?
Eric W Dunn
Programmer Analyst III - Remedy/Collaboration
(281)465-1265
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Thursday, December 28, 2006 10:02 AM
To: [email protected]
Subject: Re: Issues after new schema implementation & enhancements
** Does the same thing happen if you run the query directly against the
database (Query Analyzer)?
Are you sure there are only 2500 records?
On 12/28/06, Dunn, Eric <[EMAIL PROTECTED]> wrote:
**
Morning,
I am having an odd issue. I implemented some new functionality today on
my production server. The implementation contains several new forms and
some updates to existing forms. The issue is on one of the existing
forms several new fields have been added. Some of these fields are no
required and do not have data in them. The database holds about 2500
records. The issue is if I run a simple query i.e. = status = active.
It takes several minutes and causes the client to stop responding.
Once the record set comes back, if I attempt to look at another record
the stop responding this happens again. This does not happen on the
development server and only happens on the "enhanced" schema.
There is nothing in the error logs.
I am running ARSystem 5.01.02 on a Windows 2000 server with SQL Server
2000.
Any ideas on how or what might the issue be?
Eric W. Dunn
Programmer Analyst III - Remedy/Collaboration
McLeod USA, Inc. - Network Engineering
8665 New Trails Dr.
The Woodlands, TX 77381
(281)465-1265
(281)465-1951 fax
NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use,
copying or disclosure by any other person is strictly prohibited. If you
have received this transmission in error, please notify the sender via
e-mail.
__20060125_______________________This posting was submitted with HTML in
it___
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer, ITIL Foundation Certified
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted
with HTML in it___
NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use,
copying or disclosure by any other person is strictly prohibited. If you
have received this transmission in error, please notify the sender via
e-mail.
__20060125_______________________This posting was submitted with HTML in
it___
DISCLAIMER Important! This message is intended for the above named person(s)
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient
of this e-mail and have received it in error, please immediately notify the
sender by return email and then delete it from your mailbox. This message may
be protected by the attorney-client privilege and/or work product doctrine.
Accessing, copying, disseminating or re-using any of the information contained
in this e-mail by anyone other than the intended recipient is strictly
prohibited. Finally, you should check this email and any attachments for the
presence of viruses, as the sender accepts no liability for any damage caused
by any virus transmitted by this email. Thank you.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
