"An error occurred while executing operations setup. Processing the error result..." error when adding new operations for VNQM in SolarWinds Platform 2025.2

Improvements have been applied to the SQL sequence for generating IDs for the new operation instances in VNQM 2025.2. 

However, in some instances, this has not been applied correctly, causing an issue when trying to add new operations. 

An error occurred while executing operations setup. Processing the error result...

The following error message may appear in the log:

Error while adding operation instances to database. 1 operation instances are not added System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'VoipOperationInstances_Sequence'.

Symptoms:

• Adding new operations fails with an error

The issue occurs because the SQL sequence object named VoipOperationInstances_Sequence, which is responsible for generating unique IDs for new operation instances in VNQM, was not created as expected. This missing sequence caused errors when trying to add newly discovered operations because the system could not generate the necessary IDs.

To resolve this issue, please upgrade to SolarWinds Platform 2025.4 and above. If you can't upgrade, execute the script below in SQL Server Management Studio as a workaround: 

-- 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.

    DECLARE @StartValue INT = (
      SELECT ISNULL(MAX(VoipOperationInstanceID), 0) 
      FROM VoipOperationInstances
    ) + 1;

    DECLARE @CreateSequenceScript NVARCHAR(MAX) = N'
    CREATE SEQUENCE [dbo].[VoipOperationInstances_Sequence] 
    AS [int]
    START WITH ' + CAST(@StartValue AS NVARCHAR) + N'
    INCREMENT BY 1
    MINVALUE 1
    CACHE';

    EXEC sp_executesql @CreateSequenceScript;

There is no need to restart any services. This creates an SQL Sequence for generating IDs for the new operation instances.