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"
