Veeam ONE compatibility patch for Veeam Backup & Replication 9.5 Update 4

KB ID: 2832
Product: Veeam ONE
Version: 9.5 Update 3
Published: 2018-12-20
Last Modified: 2021-06-14
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.

Cheers for trusting us with the spot in your mailbox!

Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest

error icon

Oops! Something went wrong.

Please try again later.

Challenge

After upgrading Veeam Backup & Replication servers to version 9.5 Update 4, Veeam Cloud Connect monitoring and reporting in Veeam ONE 9.5 Update 3 will stop working.

Cause

This issue is caused by incompatibility of Veeam Backup & Replication 9.5 Update 4 and Veeam ONE 9.5 Update 3. To resolve this issue, confirm you are running Veeam ONE version 9.5.0.3801 prior to installing this compatibility patch.

NOTE: For those who are not using Cloud Connect, there is no need to apply the compatibility patch as there are no issues monitoring Veeam Backup & Replication 9.5 Update 4 with Veeam ONE 9.5 Update 3.

Solution

There are several ways of applying the hotfix:

Using SQL Server Management Studio
 

  1. Open Veeam ONE Monitor client and check the lower part of the window for the SQL instance name and the database name.
User-added image


Alternatively, check the same via Veeam ONE Settings Utility (C:\Program Files\Common Files\Veeam\Veeam ONE Settings).
 

  1. Open Microsoft SQL Server Management Studio with the Administrator permissions.
  2. Connect to the ServerName\Instance of the server that has the Veeam ONE database.
  3. Expand the Databases tree and select "VeeamOne" database (default name). 
  4. Right-click on the database > New Query.
User-added image
  1. Copy the following query and run it against the database:
IF OBJECT_ID('monitor.[ENUM_CTVI_PV]', 'C') IS NOT NULL
  ALTER TABLE monitor.BpCloudTenantVersionInfo
   DROP CONSTRAINT [ENUM_CTVI_PV];​​
  1. If the query was performed correctly, you will get the following status in the SQL Server Management Studio: Commands completed successfully.


Using SQL command line

In case you do not have the Management Studio installed, run the hotfix against the Veeam ONE database using the SQLCMD utility:
 

  1. Open Veeam ONE Monitor client and check the lower part of the window for the SQL instance name and the database name.
User-added image


Alternatively, check the same via Veeam ONE Settings Utility (C:\Program Files\Common Files\Veeam\Veeam ONE Settings).
 

  1. Open Windows command line or PowerShell prompt using the Veeam ONE Service account and run the hotfix against the Veeam ONE database:

for default instances (change the database name in the query if it differs from yours):
 
sqlcmd -S SqlServerName -q "USE VeeamOne IF OBJECT_ID('monitor.[ENUM_CTVI_PV]', 'C') IS NOT NULL ALTER TABLE monitor.BpCloudTenantVersionInfo DROP CONSTRAINT [ENUM_CTVI_PV];"

for named instances (change the database name in the query if it differs from yours):
 
sqlcmd -S SqlServerName\SqlInstanceName -q "USE VeeamOne IF OBJECT_ID('monitor.[ENUM_CTVI_PV]', 'C') IS NOT NULL ALTER TABLE monitor.BpCloudTenantVersionInfo DROP CONSTRAINT [ENUM_CTVI_PV];"
In case you have SQL server authentication enabled you may define username and password (change the database name in the query if it differs from yours):
 
sqlcmd -S SqlServerName\SqlInstanceName -U username -P password -q "USE VeeamOne IF OBJECT_ID('monitor.[ENUM_CTVI_PV]', 'C') IS NOT NULL ALTER TABLE monitor.BpCloudTenantVersionInfo DROP CONSTRAINT [ENUM_CTVI_PV];"

More information

Should have any questions, contact Veeam Support.
Click here to send feedback regarding this KB, or suggest content for a new KB.
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.

Spelling error in text

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case

By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Verify your email to continue your product download
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please try again later.