Boy howdy - that really blows... Issue resolved - thanks to all for your help and suggestions.... The Cause - 4 table views. Lots of records each of the schemas - each schema has a new field - new field blank - each table view was pulling back all record sets. Resolution - update each table qualification to exclude field that is blank.
There is no issue in development because the record sets are smaller... Thanks, Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric Sent: Thursday, December 28, 2006 11:01 AM To: [email protected] Subject: Re: Issues after new schema implementation & enhancements ** I have disable all the workflow - all (new and old). Looked at all of the tables to ensure server name is correct. I have no indexing on the schema. (both the production server and development) I'm starting to pull out my hair here......very frustrating.... Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug Sent: Thursday, December 28, 2006 10:51 AM To: [email protected] Subject: Re: Issues after new schema implementation & enhancements ** 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] <mailto:[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 <http://www.specificintegration.com> 703-376-1249 __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. 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___ __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___ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
