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
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.
Article Type
Technical Solution


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.


Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1


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.


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


Fix for TECH201624.SQL (661 Bytes)

Supplemental Materials


Article URL

Terms of use for this information are found in Legal Notices