That is cause the Web log shows SELECT DISTINCT 'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC versus the User tool log showing SELECT T98.C1,C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC
The DISTINCT ‘no C1’ will only bring back from the database the 50 some records of the States (much more efficient than doing the distinct inside the AR Server process) Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Tuesday, October 20, 2015 1:47 PM To: [email protected] Subject: Re: User tool and Newer AR server ** hmmm...not sure how 20K is breaking down....but the interesting thing for me is that both the log for user and web both show 20k, but you say the web is working but user isn't.... On Tue, Oct 20, 2015 at 11:54 AM, Grooms, Frederick W <[email protected]<mailto:[email protected]>> wrote: ** 1000 From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of LJ LongWing Sent: Tuesday, October 20, 2015 11:31 AM To: [email protected]<mailto:[email protected]> Subject: Re: User tool and Newer AR server ** I've seen that be the server side table chunk size too, what's that set to? Sent with AquaMail for Android http://www.aqua-mail.com -----Original Message----- On October 20, 2015 10:06:32 AM "Grooms, Frederick W" wrote: ** 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:[email protected]] On Behalf Of LJ LongWing Sent: Tuesday, October 20, 2015 10:46 AM To: [email protected]<mailto:[email protected]> 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 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "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"
