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
On October 20, 2015 10:06:32 AM "Grooms, Frederick W"
<frederick.w.gro...@xo.com> 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: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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
