Hi Math , Issue has been resolved by modifying the ar,cfg with the line below then restart the server
Suppress-warnings: 66 Thanks all for advices On Mon, Aug 11, 2008 at 6:52 PM, Matt Reinfeldt <[EMAIL PROTECTED]>wrote: > Interesting... I started seeing this on our system after applying 7.0.1 > patch008. It definitely was not happening before that. We were at patch004 > before installing patch008. > > Matt > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] > Sent: Monday, August 11, 2008 10:42 AM > To: [email protected] > Subject: Re: ARWARN [66] the query matched more than the maximum number of > entries specified for retrieval > > I believe this is a known bug. Support pointed us to SW00298917 "Push > Field > in Filter generates ARWARN [66] if option "Modify First Matching Request" > is > chosen", details are below. They told us it would be fixed in 7.5 but we > pushed for a patch/hotfix to 7.1 since it's still a supported version. The > defect shows Status = Closed and we were told it's underway, but as for > when > we'll see it... > > 1. DROP/BUILD BUG OCCURS IN (IF PRE-RELEASE) > ARS - 7.1.0 p3 > User and Admin - 7.1.0 p3 > > 2. STEPS TO REPRODUCE: > - Create Filter that does a Push Fields to another form. > - Have the "If Any Requests Match" option set to "Modify First Matching > Request" > - Trigger the filter. > > 3. ACTUAL RESULTS: > A Warning will appear in the User Tool. The record still gets modified, > but > the message shouldn't appear. > > ARWARN [66] The query matched more than the maximum number of entries > specified for retrieval > > 4. EXPECTED RESULTS: > No warning message should appear. The issue doesn't appear to occur with an > Active Link. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook > Sent: Sunday, August 10, 2008 1:03 PM > To: [email protected] > Subject: Re: ARWARN [66] the query matched more than the maximum number of > entries specified for retrieval > > ------=_Part_43924_771237.1218398570905 > Content-Type: text/plain; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > Content-Disposition: inline > > Since it's directly related to Status, could it be related to Status > History? > > Rick > On Sun, Aug 10, 2008 at 11:12 AM, Frank Caruso > <[EMAIL PROTECTED]>wrote: > > > ** Looks like there is a set fields operation that is run on update. Turn > > on SQL,filter and alink logging and see what action is causing the > warning > > > > On Aug 10, 2008, at 11:10 AM, "Ramy S. Ayoub" <[EMAIL PROTECTED]> > wrote: > > > > ** > > > > Dear List, > > > > I get this below warring only when the status is updated > > > > ARWARN [66] the query matched more than the maximum number of entries > > specified for retrieval > > > > When update anything else... Things are going smooth > > > > AR Server 7.1 Patch 4 > > > > Service Desk 7.0.3 Patch 8 > > > > OS windows > > > > Database SQL 2005 > > > > Regards, > > > > Ramy > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ------=_Part_43924_771237.1218398570905 > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > Content-Disposition: inline > > ** > <div dir="ltr"><div>Since it's directly related to Status, could it be > related to Status History?</div> > <div> </div> > <div>Rick<br></div> > <div class="gmail_quote">On Sun, Aug 10, 2008 at 11:12 AM, Frank Caruso > <span dir="ltr"><<a > href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>></span> > wrote:<br> > <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px > 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">** > <div bgcolor="#FFFFFF"> > <div>Looks like there is a set fields operation that is run on update. Turn > on SQL,filter and alink logging and see what action is causing the > warning<br><br>On Aug 10, 2008, at 11:10 AM, "Ramy S. Ayoub" > <<a href="mailto:[EMAIL PROTECTED]" > target="_blank">[EMAIL PROTECTED]</a>> wrote:<br> > <br></div> > <div></div> > <blockquote type="cite"> > <div>** > <div dir="ltr"><font size="2"> > <p>Dear List,</p> > <p>I get this below warring only when the status is updated </p> > <p>ARWARN [66] the query matched more than the maximum number of entries > specified for retrieval</p> > <p>When update anything else... Things are going smooth </p> > <p>AR Server 7.1 Patch 4</p> > <p>Service Desk 7.0.3 Patch 8 </p> > <p>OS windows </p> > <p>Database SQL 2005</p> > <p>Regards,</p> > <p>Ramy</p></font></div>__Platinum Sponsor: <a > href="http://www.rmsportal.com/"; target="_blank">www.rmsportal.com</a> > ARSlist: "Where the Answers Are" html___ > </div></blockquote></div>__Platinum Sponsor: <a > href="http://www.rmsportal.com/"; target="_blank">www.rmsportal.com</a> > ARSlist: "Where the Answers Are" html___</blockquote> > </div><br></div> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > ------=_Part_43924_771237.1218398570905-- > > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
