Continuum ACCTrace error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

[Product_Support]

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.

Error inserting a row into the object dictionary.
[Microsoft][ODBC SQL Server Driver]Maximum stored procedure,
function, trigger or view nesting level exceeded (limit 32)

Product Line

Andover Continuum

Environment

CyberStation

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 is using 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