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)
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)
- Close all Continuum workstations
- Reset recursive triggers to its default of OFF with the following query using SQL Management Studio
ALTER DATABASE ContinuumDB SET RECURSIVE_TRIGGERS OFF