KNOWN ISSUE: Resources filter in Security Role Manager is slow when database contains millions of resources
| Article:TECH201624 | | | Created: 2013-01-14 | | | Updated: 2013-02-27 | | | Article URL http://www.symantec.com/docs/TECH201624 |
| NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made. |
Problem
Customer reported that when trying to open the Permissions section for Security Role Manager is taking too long to load. --Steps to reproduce 1. Open Security Role Manager (under SMP Console>Settings>Security>Permissions) 2. Change the view drop down to "Resources" 3. Left pane takes over 20 seconds to load created at install for its use.
Environment
Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1
Cause
Known issue. Altiris Profiler identifies the following SQL command as almost all of the 20 seconds.
EXECUTE spGetTree3 @Guids=N'fec994ae-1787-44c2-b5ec-e94d210838c9', @MaxDepth=2147483647, @ExcludeResources=0
Analysis of the rows reveled that the results included not only the Items under the Resource Management folder (like filters and OU groups), but also included ALL resources which were all under the "Resources" folder. No resources can have security directly on them anyway, but the QueryItemTreebuild object was retrieving them anyway only to get discarded because the "Resources" folder is a hidden folder so the entire "Resources" branch is removed one node at a time.
Solution
This issue has been reported to Symantec Development team. A fix has been targeted for the next release (current ETA ITMS 7.5).
There is a SQL workaround for 7.1 customers. See attached "Fix for TECH201624.sql" file
Attachments
|
|
| Source | ETrack |
| Value | 3047771 |
Article URL http://www.symantec.com/docs/TECH201624
Terms of use for this information are found in Legal Notices
Thank you.