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