Database Backups to BACPAC fail after upgrade to SolarWinds Platform 2026.2

7/21/2026 3:58 PM

7/21/2026 5:03 PM

After upgrading to SolarWinds Platform 2026.2, you may find that your SolarWinds Observability Self Hosted database backup or export fails with a schema validation error. The error points to two VSAN-related database functions. 

 

This issue is most commonly seen when exporting the database to a .bacpac file — for example, when backing up an Azure SQL database, or when a backup tool (such as Veeam) uses the Azure export/DacFX process.

 

Your backup or export job fails, and the error message mentions one or both of the following functions:

• dbo.NPM_VSANs_ErrorsByDaysFnc

• dbo.NPM_VSANs_TrafficByDaysFnc

 

A typical error looks like this:

The SQL backup failed during the DacFX export process due to schema validation errors (SQL71501).
The database 'SolarWindsOrion' contains unresolved references for specific functions
([dbo].[NPM_VSANs_ErrorsByDaysFnc] and [dbo].[NPM_VSANs_TrafficByDaysFnc]),
causing the schema data package creation to fail.

You may also see the more detailed SQL Server message:

Error SQL71501: Error validating element [dbo].[NPM_VSANs_TrafficByDaysFnc]:
Function: [dbo].[NPM_VSANs_TrafficByDaysFnc] has an unresolved reference to object
[dbo].[NPM_VSANs_Traffic].[DateTime].

Orion Platform

In 2026.2, the VSAN tables were rebuilt using a newer architecture. When this was done, the 'DateTime' column was changed to 'TimeStamp.' The two functions that fail during the backup still use the 'DateTime' column, which is causing the schema error.

 

These two functions are now deprecated after the upgrade, but still remain in the database:

• dbo.NPM_VSANs_ErrorsByDaysFnc

• dbo.NPM_VSANs_TrafficByDaysFnc

 

 

If the system is already running 2026.2, these two functions can be safely removed. DO NOT RUN THESE IF YOUR SYSTEM IS EARLIER THAN 2026.2.

 

If possible, create a snapshot or backup that isn't a BACPAC before running these queries. 

 

1.) Using SQL Management Studio or Database Manager, run these queries against the main SolarWindsOrion database. 

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

-- NPM_VSANs_Errors ByDays function removal
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NPM_VSANs_ErrorsByDaysFnc]') AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT'))
    DROP FUNCTION [dbo].[NPM_VSANs_ErrorsByDaysFnc]

-- NPM_VSANs_Traffic ByDays function removal
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NPM_VSANs_TrafficByDaysFnc]') AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT'))
    DROP FUNCTION [dbo].[NPM_VSANs_TrafficByDaysFnc]

3.) Attempt a new backup of the database. They should now work.