Access Control page loading time increases disproportionate the more Shared Mailboxes entries are configured (might hit timeout)

Versions / Builds Affected

20150218 (but potentially any)

Status

Open

TT / JIRAID

3010

How to Identify

It appears that the more Shared Mailboxes entries are defined under [Configuration > Access Control] the page loading time of this page increases disproportionate. For example, the customer on which this article / TT was based had 61 Shared Mailboxes entries configured. It tool 10min to load the page. Analyzing the loading times of the group via ASPNET/UI/WebHelper.log showed that the first few entries loaded within a few seconds (2sec each), but each further entry took longer to load (the last few took about 20sec to load). Here is an example: 2015-08-26,09:23:22 - opening the page ... * resolving UserMap entries for 25sec, then loading of SharedMailboxes entries begins * ... 2015-08-26,09:23:47,689,1,"#000008BC","#00000009","info ","WebHelper","Looking for Group: 2a03d5f86ac722438eb1e9baff866b54" 2015-08-26,09:23:47,894,1,"#000008BC","#00000009","info ","WebHelper","Group found in ADA: GFISharedAffiliatesMailbox" 2015-08-26,09:23:48,747,1,"#000008BC","#00000009","info ","WebHelper","INFO: Looking for user: 4f570c078a0fc54aa30287fb0b55abf4" 2015-08-26,09:23:49,033,1,"#000008BC","#00000009","info ","WebHelper","INFO: User found in ADA: Affiliates" 2015-08-26,09:23:49,962,1,"#000008BC","#00000009","info ","WebHelper","Looking for Group: ca7748e4d5913444b6c754a42cba6678" 2015-08-26,09:23:50,110,1,"#000008BC","#00000009","info ","WebHelper","Group found in ADA: GFISharedBack2BaseMailbox" 2015-08-26,09:23:50,796,1,"#000008BC","#00000009","info ","WebHelper","INFO: Looking for user: b78bc0115583d84a9a0e3e5b155fe8b9" 2015-08-26,09:23:50,981,1,"#000008BC","#00000009","info ","WebHelper","INFO: User found in ADA: Back to Base" 2015-08-26,09:23:51,956,1,"#000008BC","#00000009","info ","WebHelper","Looking for Group: ee5bfd1347f5f946aeddaa35b2d279b7" 2015-08-26,09:23:52,166,1,"#000008BC","#00000009","info ","WebHelper","Group found in ADA: GFISharedBrightonStoreMailbox" 2015-08-26,09:23:53,109,1,"#000008BC","#00000009","info ","WebHelper","INFO: Looking for user: 1eb23b45ddf69743b58d7ee9eec1ca53" 2015-08-26,09:23:53,368,1,"#000008BC","#00000009","info ","WebHelper","INFO: User found in ADA: Brighton Store Mailbox" ... * above shows the first 3 groups being loaded, each taking only 2 seconds * ... 2015-08-26,09:33:23,750,1,"#000008BC","#00000009","info ","WebHelper","Looking for Group: 48c169a4a23f274bada7169977f59dbb" 2015-08-26,09:33:23,928,1,"#000008BC","#00000009","info ","WebHelper","Group found in ADA: GFISharedweberrors" 2015-08-26,09:33:33,024,1,"#000008BC","#00000009","info ","WebHelper","INFO: Looking for user: bc296a8eadf1ae46ba72fcd260a787ec" 2015-08-26,09:33:33,506,1,"#000008BC","#00000009","info ","WebHelper","INFO: User found in ADA: weberrors" 2015-08-26,09:33:42,828,1,"#000008BC","#00000009","info ","WebHelper","Looking for Group: d9d80d78d15c5049a370b5aa6992a080" 2015-08-26,09:33:43,317,1,"#000008BC","#00000009","info ","WebHelper","Group found in ADA: GFISharedWebOrderSpainMailbox" 2015-08-26,09:33:51,753,1,"#000008BC","#00000009","info ","WebHelper","INFO: Looking for user: 71acb4a1cbff7040ad9580742ab20d6d" 2015-08-26,09:33:51,980,1,"#000008BC","#00000009","info ","WebHelper","INFO: User found in ADA: WebOrderSpainMailbox" 2015-08-26,09:33:59,998,1,"#000008BC","#00000009","info ","WebHelper","Looking for Group: c4f8594d1060bb47aeef77781829c7e3" 2015-08-26,09:34:00,166,1,"#000008BC","#00000009","info ","WebHelper","Group found in ADA: GFISharedWhiteLabelWebSupport" 2015-08-26,09:34:08,371,1,"#000008BC","#00000009","info ","WebHelper","INFO: Looking for user: a9fc1d4f4369bf478e3111b81e8f7d47" 2015-08-26,09:34:08,617,1,"#000008BC","#00000009","info ","WebHelper","INFO: User found in ADA: Web Support" ... * about 10min later the last 3 groups are taking 17-20sec each * ...

Workaround / Fix Details

#1 Increase timeouts to a high value. This is will not speed up the loading to the page itself, but it will stop the default timeout of 5min being hit. How to extend / increase the Microsoft SQL Server and WCF timeout values in GFI Archiver (INTERNAL ONLY) https://na8.salesforce.com/articles/SkyNet_Article/How-to-extend-increase-the-SQL-timeout-value-in-MailArchiver812234 #2 Review any entries and remove any which are not needed

Required Actions

1. Communicate / implement the workaround to get the customer to use the Access Control page again (it will still be slow, but it should work) 2. Escalate the case