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
UNION ALL
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
Applies To
Deployment Solution 6.9