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]> wrote: > ** > > 1000 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *LJ LongWing > *Sent:* Tuesday, October 20, 2015 11:31 AM > *To:* [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] <[email protected]>] *On Behalf Of *LJ > LongWing > *Sent:* Tuesday, October 20, 2015 10:46 AM > *To:* [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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
