In my defence, I didn't put it together originally .... But it is querying group_x; you're right - it doesn't need the select distinct, and it doesn't really need to be done as SQL at all - the query definition can easily be done in a regular search on the set fields.
Have a look at the SQL logs then! Ta Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: 09 November 2007 14:05 To: [email protected] Subject: Re: ARERR 9278 Well, I'm sure it's just a typo when you wrote up this message, but the view name is group_x, not groups_x. Have you turned on the SQL logs and examined them? And I think this begs the question: Why use direct SQL for this? Why not just use a Remedy search menu? And why are you selecting DISTINCT? Aren't your group names already unique? Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Barber, Dave Sent: Friday, November 09, 2007 7:55 AM To: [email protected] Subject: ARERR 9278 ** All, On ARS 5.1.2 (Win2k), mid tier 6.3. No problems with the applications via the user tool, but with one user, when they try to select an entry from a drop down menu, an ARERR 9278 is presented. The AL that fires of that does a SQL SELECT DISTINCT from the groups_x form to present a list of available groups, so the user can then select which ones open tickets to view. Any suggestions? I cannot figure out why the workflow is failing - the mid tier error log is pretty useless (it just shows True action: action 0 ... then nothing). The only possible course of action i can think of is to create a new account with the same access, although i'd love to get to the root cause of this problem. Regards Dave Barber Please consider the environment before printing this e-mail or its attachments. ________________________________ This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> . The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd. unless otherwise expressly stated. NTT Europe Limited is a company registered in England and Wales with company number 2307625. Registered Address: NTT Europe Ltd. 3rd Floor, Devon house, 58-60 St. Katharine's Way, London, E1W 1LB, UK. Telephone +44-20-7977-1000. Facsimile +44-20-7977-1001. Website Link: http://www.ntteurope.com <http://www.ntteurope.com/> __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Please consider the environment before printing this e-mail or its attachments. -------------------------------------------------------- This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [EMAIL PROTECTED] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd. unless otherwise expressly stated. NTT Europe Limited is a company registered in England and Wales with company number 2307625. Registered Address: NTT Europe Ltd. 3rd Floor, Devon house, 58-60 St. Katharine's Way, London, E1W 1LB, UK. Telephone +44-20-7977-1000. Facsimile +44-20-7977-1001. Website Link: http://www.ntteurope.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
