Actually my Max Entries Returned By GetList = 5000 I’m not sure where the 20k comes from as I did a grep on the server and couldn’t find any place where I have 20k
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, October 20, 2015 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: User tool and Newer AR server ** Fred, Do you have your server properties set to return a maximum of 20K records? -----Original Message----- On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W wrote: We just found another place where a newer AR Server breaks using the User Tool. (Yes I know, we are trying to get users to move off of it) AR Server 8.1.02 201408260235 (RedHat Linux) AR User 7.6.04 SP4 Sep , 6 2012 We have a regular form to hold Zip codes. (42,000 + records) There is a search menu against that form to list the State values (Label Field "State", Value Field "State", Sort on Label, Qualification: 'Status' = "Active") When we were using the menu against a 7.6.04 server everything worked correctly. Now that we have upgraded the server to 8.1.02 the User tool doesn't show the complete list anymore. I went and captured SQL logs. In User tool when opening a menu the selections are not complete. <CLAT> /* Mon Oct 19 2015 16:45:15.6810 */+API call <API > <TID: 3061696832> <RPC ID: 0005665480> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User (protocol 18) at IP address 192.168.101.98 // <SQL > <TID: 3061696832> <RPC ID: 0005665480> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:45:15.6805 */SELECT * FROM ( SELECT T98.C1,C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001 <SQL > <TID: 3061696832> <RPC ID: 0005665480> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:45:15.7677 */OK <SQL > <TID: 3061696832> <RPC ID: 0005665480> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0) <SQL > <TID: 3061696832> <RPC ID: 0005665480> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:45:15.9393 */OK <API > <TID: 3061696832> <RPC ID: 0005665480> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:45:15.9584 */-EXPQRY OK <CLAT> /* Mon Oct 19 2015 16:45:15.9620 */-API call In Mid-Tier we get all the records. <HTTP> /* Mon Oct 19 2015 16:37:37.260 */+HTTP call /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 20) at IP address 192.168.107.150 // /* Mon Oct 19 2015 16:37:37.2817 */SELECT * FROM ( SELECT DISTINCT 'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001 /* Mon Oct 19 2015 16:37:37.3187 */OK /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY OK (ARNOTE 8914) <MTT > /* Mon Oct 19 2015 16:37:37.277 */+MidTier ExpandMenu/20/ZIP:Valid_State_List// <CLAT> /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55 <API > <TID: 3051190592> <RPC ID: 0005664950> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 20) at IP address 192.168.107.150 // <SQL > <TID: 3051190592> <RPC ID: 0005664950> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:37:37.2817 */SELECT * FROM ( SELECT DISTINCT 'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001 <SQL > <TID: 3051190592> <RPC ID: 0005664950> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:37:37.3187 */OK <API > <TID: 3051190592> <RPC ID: 0005664950> <Queue: List > <Client-RPC: 390620 > <USER: MyUserID > <Overlay-Group: 1 > /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY OK <CLAT> /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55 Fred _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
