Network Management

When exporting the database we get an error [F5_Device_v] has unresolved reference to object

The user is unable to export a backup of the Orion Database and sees the error message One or more unsupported elements were found in the schema used as part of a data package, ERROR SQL71501:ERROR validating element (DBO).[F5_Device_V]

First published date

9/9/2021 3:01 PM

Last published date

9/9/2021 3:01 PM

Overview

The Legacy F5 view "F5_Device_V" was not deleted after an upgrade and can cause problems when exporting the  DB to Azure.

You will see the following Error 
One or more unsupported elements were found in the schema used as part of a data package, ERROR SQL71501:ERROR validating element (DBO).[F5_Device_V]: View: [DBO].[F5_Device_v] contains an unresolved reference to object [DBO].[F5_Device].

(Screenshots property of Microsoft  ©  2020/11/05 Microsoft )
DB_errror.JPG

Product section

Network Performance Monitor

Cause

This issue is caused by a Bug in the Product, Legacy F5 View/s  were not removed during a previous upgrade. 


 


 

Resolution

  • The user can remove the legacy view/s with the following query.
- 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.


Drop View [dbo.F5_Device_V]