Looks like something crashed your server when it made the query. Check your arerror.log and arthread.log and see if you find more details on that.
Chad Hall (501) 342-2650 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Friday, November 09, 2007 1:28 AM To: arslist@ARSLIST.ORG Subject: Re: Problem with MS SQL Server 2005 I try to attach log files with this mail. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, November 09, 2007 9:48 AM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 Try an API log. That will give you which API is failing.. Is there anything that is written on to the arerror.log at the time of failure? I'm assuming you know how to read API logs after you generate them.. If you do not know, send them in either on the list or directly to me, and I could have a peep. Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Friday, November 09, 2007 1:21 AM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005 ** No logs is created by SQL. It seems remedy suspend and SQL do not get query from remedy. I think It's Remedy bug. I tried on version 7.0.01 patch 004 and 7.1. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, November 09, 2007 12:42 AM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Have you seen what is the query it runs against the database? Run an SQL log and see what you get.. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 12:26 PM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 ** There's two regular form. For example: rf1 and rf2, add into rf1 form four character fields with name ch1, ch2, ch4 and ch5; into rf2 form -> ch1, ch2, ch3. Create join form jf1: join two forms rf1 with rf2 (inner), add into join form fields ch[1-5]. Join criteria: ch1 -> ch1, ch2 -> ch2. Create next join jf2: join form jf1 with itselt (outer), add into join form fields ch[1-5], criteria is ch3 -> ch4. Create regular form rf3 with character field ch5. Create join form jf3: join jf2 with rf3 (outer) , add into join form fields ch[1-5], criteria is ch5 -> ch5. Add data in regular forms in that way it meet the criteria. Open Remedy User, open form 'jf3' and press F5. It work. Change data in that way it don't meet the criteria, it don't work (only mssql server 2005). ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:37 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 What's your join criteria? Try removing that criteria, SAVE the join, then put the criteria back again and SAVE it again.. Maybe for some reason your join definition has got corrupted and recreating the join as described might fix it. Have you seen the query it runs on the SQL server when you perform a search? Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005 ** Each regular form have 1 record. All join form joined as outer. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:10 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Let me guess.. large tables in the join, unindexed join criteria? Resulting in a table scan - it will eventually show the results if you do not press Stop, but your solution is check the join criteria and make sure that the fields in that criteria are indexed from the AR System. A DB level index will not help the AR System to interpret the index. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 9:32 AM To: arslist@ARSLIST.ORG Subject: Problem with MS SQL Server 2005 ** I have a serious problem with MS SQL Server 2005. I create some join forms and I get data from last join on MS SQL Server 2000. When I try create the same join forms and retrieve data from its I contemplate this massage "Performing Search". It last until I press button "Stop Search". Anybody confronted with this problem? I attached sample where join "6" do not work on MS SQL Server 2005, but successfully work on MS SQL Server 2000. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ************************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"