Summary

When you perform a records management action on a deeply nested folder, you may receive the following error message:

AttemptedAction: Error executing SQL command
Error executing SQL command [7050]

In addition, the repository error.log file will contain the following error message:

[7050] AttemptedAction failed (tocid=#): Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Cause

Laserfiche Records Management utilizes nested triggers. Microsoft SQL Server contains a nesting limit of 32. For example, if you had a record series that contained 40 levels of nested folders, you would be unable to directly freeze the top level record series, as the limit prevents Laserfiche from recursively freezing all the necessary entries in the subsequent folder levels.