Fred, Do you have your server properties set to return a maximum of 20K records?
On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> 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 > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
