Error received when using 32-bit DS Console when attempting to look for/find a computer: “Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)”.
|Article:TECH195893|||||Created: 2012-08-30|||||Updated: 2012-09-07|||||Article URL http://www.symantec.com/docs/TECH195893|
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)
Deployment Solution 6.9
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
Article URL http://www.symantec.com/docs/TECH195893