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
Did this article resolve your issue?
Did this article save you the trouble of contacting technical support?
How can we make this article more helpful?
Email Address (Optional)
Login to Subscribe
Please login to set up your subscription.
Create and manage cases, manage licensing and renewals, submit threats, and enroll with Symantec Rewards.
Customer and Technical Support phone numbers and hours of operation.
User-to-user forums, blogs, videos, and other community resources on Symantec Connect.
Set default language
Do you wish to save this as your future site?