Configuration Wizard fails with an error "Error while executing script- Database and server triggers on DDL statements CREATE, ALTER and DROP are not supported with memory optimized tables."

6/17/2025 8:29 PM

6/28/2025 9:02 PM

When you upgrade the SolarWinds Platform, the Configuration Wizard fails with an error:

ERROR TaskAdapter - Error running task Orion.ConfigureDatabase SolarWinds Platform Database

SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Database and server triggers on DDL statements CREATE, ALTER and DROP are not supported with memory optimized tables.

Note: This error can occur during a SolarWinds platform upgrade and is not specific to any particular version. It may arise during any upgrade process, regardless of the version being used.

 

Orion Platform

This issue occurs due to the following reasons:

• Cannot create memory optimized tables due to a possible Microsoft SQL Server 2022 bug
• The feature 'EVENT NOTIFICATION' is not supported with memory optimized tables. "Memory-optimized tables and natively compiled stored procedures cannot be created or dropped if there is a server or database event notification for that DDL operation. Remove the server and database event notifications on CREATE TABLE or DROP TABLE and CREATE PROCEDURE or DROP PROCEDURE." For more information, refer to the following document.
• Custom SQL triggers enabled on memory optimized tables. For more information, refer to the following document

 

 

Make sure we have a backup of the Database before executing any scripts:

1. Search for the Tables with Triggers
   

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   SELECT * FROM sys.triggers
   WHERE parent_id = 0 or Name like '%DDL%'
   
   -- or
   
   SELECT * FROM sys.Server_triggers
   WHERE parent_id = 0 or Name like '%DDL%'

2. Run the script below replacing the [TriggerName] with the name of the Trigger
   

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   DISABLE TRIGGER [TriggerName] ON DATABASE;
   

    
3. Run Configuration Wizard again as administrator.