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

Products

• Deployment Solution

Issue/Introduction

 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)

Cause

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

Resolution

 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