When you search for a computer name in the Deployment Console you receive an error message: "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)”.
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
There is a maximum level of folders you can have. Anything greater than 8 levels will cause this error.
Do not go deeper than 8 levels on the folder structure. You can use the following SQL query to find the folders that are more than 8 levels deep.
--Begin SQL query
WITH FolderRecursion(FolderId, ParentFolderId, [Path], [Level]) AS
SELECT cg.[group_id], cg.[parent_id], cg.[name], 1 AS 'Level'
FROM computer_group cg
SELECT f1.[group_id], f1.[parent_id], f1.[name], [Level]+1
FROM computer_group f1
JOIN FolderRecursion ft ON ft.[FolderId] = f1.[parent_id]
SELECT * FROM FolderRecursion WHERE [Level] > 8
--END SQL Query
Deployment Solution 6.9
Login to Subscribe
Please login to set up your subscription.
Get support for your product, with downloads, knowledge base articles, documentation, and more.
Maximize your product competency and validate technical knowledge to gain the most benefit from your IT investments.
Submit a suspected infected file to Symantec.
Report a suspected erroneous detection (false positive).
Set default language
Do you wish to save this as your future site?