With those settings you should not have got the 66 warning. Something somewhere is overriding your settings so it could be on the client side. Are you using the user tool (if you are on an older version of the system) or the mid tier?
If using the user tool, the setting on the user tool can override the server setting. If using the mid-tier, check your preferences saved on the user preference which can also override the server settings. If both these have been checked and you are set for unlimited there as well, try suppressing the ARWARN 66 through the config file (by editing the ar.conf or ar.cfg file depending on whether you are on UNIX or Windows and adding that suppress parameter available for this file), that will suppress the warning. However suppressing may not mean it may return any more than 302 if that is the setting in your client side settings. It will simply not display the warning. But worth giving it a shot and see what it does for you. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of MalviyaSaurabh Sent: Tuesday, July 12, 2016 4:52 AM To: [email protected] Subject: Partial results on Company Field and then ARWARN 66 Hi All, I have been investigating the issue with Company menu where it lists down the partially results and then gives ARWARN66 The back end query which gets fired is SELECT DISTINCT TOP 302 T445.C1000000001, T445.C1000000070, T445.C1000000071 FROM T445 WHERE ((T445.C7 = 1) AND ((T445.C1000000006 LIKE N'%Operating Company%') OR (T445.C1000000006 LIKE N'%Customer%')) AND (T445.C1000000071 LIKE N'The%')) ORDER BY T445.C1000000001 ASC, T445.C1000000070 ASC, T445.C1000000071 ASC The point to be noted is TOP 302 in the query(i.e. it fetches the first 302 records and in total there are 470 qualifiable records with Company name starting with 'The%') I am interested in knowing what config/etc is making it fetching the first 302 records. The server is configured for unlimited entries on get list like shown below Max Entries Returned By GetList : 0 Server Table Field Chunk Size : 0 Also the user preference for me (an administrator) is like shown below Limit Number of Items Returned : No Any pointers to fix it. ITSM 9.0.01 201606230729 Windows Server 2012 R2 6.3 SQL -- SQL Server 2014 - 12.0.4100.1 (X64) Regards, Saurabh -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Partial-results-on-Company- Field-and-then-ARWARN-66-tp124673.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
