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