Maximum stored procedure, function, trigger, or view nesting level exceeded

Message: System.Data.SqlClient.SqlException (0x80131904): Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at DotNetNuke.Common.Lists.ListController.FillListInfoDictionary(IDataReader dr) in \06.02.03_Source\Community\Library\Common\Lists\ListController.cs:line 86

The error occues after i delete one my Custom List in Lists.

I think have problem with function dbo.[GetListParentKey]

Anybody met this the same error!??

---

https://www.onednn.com

I found the source problem, error in data Lists table, Have a list entry with not exist ParentID. Why?
i think when DNN deleting my custom Listname, it not delete all childs of item in it.

I think this is important error, because Lists is core extension.

---

https://www.onednn.com

I write sql script to fix Entries having invalid ParentID, script bellow:

Declare @entryID int, @parentID int
Declare c Cursor For Select EntryID, ParentID From dbo.Lists as L0 WHERE L0.ParentID > 0
Open c

Fetch next From c into @entryID, @parentID

While @@Fetch_Status=0
Begin
--Print 'EntryID: ' + CONVERT(nvarchar(50),@entryID) + ' ParentID:' + CONVERT(nvarchar(50),@parentID)
If (@parentID > 0)
begin
IF NOT EXISTS(SELECT EntryID FROM dbo.Lists as L1 WHERE L1.EntryID = @parentID)
Begin
Print '==> Error in EntryID: ' + CONVERT(nvarchar(50),@entryID) + ', not exist ParentID: ' + CONVERT(nvarchar(50),@parentID)
--Delete from dbo.Lists where EntryID = @entryID
End
end
Fetch next From c into @entryID, @parentID
End
Close c
Deallocate c
-- UnComment the row Delete from... if you want clear all invalid entries

---

https://www.onednn.com