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

Product(s)

Issue



 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)”.


Error



Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)


Environment



 Deployment Solution 6.9


Cause



 There is a maximum level of folders you can have.  Anything greater than 8 levels will cause this error.


Solution



 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




Article URL http://www.symantec.com/docs/TECH195893


Terms of use for this information are found in Legal Notices