Continuum ACCTrace shows error... [Microsoft][ODBC SQL Server Driver][SQL Server]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Issue

When sending BACnet devices to database the operation does not return an error but NO objects (or only some objects) are created in the DB.

Inspection of ACCTrace shows the following...

In the case at hand the device had 28 objects which the system identified correctly as seen  below, but trying to add each object to the database resulted in error inserting the object in the dictionary.

Product Line

Andover Continuum

Environment

CyberStataion

Cause

The ContinuumDB's recursive triggers property has somehow been changed to ON (1) from its default of OFF (0)

The following query can be used to determine what the value of the property isusing SQL Management Studio

select DATABASEPROPERTYEX ('ContinuumDB', 'IsRecursiveTriggersEnabled)

Resolution

  1. Close all Continuum workstations
  2. Reset recursive triggers to its default of OFF with the following query using SQL Management Studio

ALTER DATABASE ContinuumDB SET RECURSIVE_TRIGGERS OFF