Incorrect Replica Counters in Monthly Cloud Connect License Usage Report

KB ID: 3004
Product: Veeam Cloud Connect
Version: 9.5 Update 4b
Published: 2019-09-20
Last Modified: 2020-08-13
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

Automated monthly license usage reports generated by Veeam Cloud Connect display an unexpected number of replicated VMs and licensed instances. At the same time, Get-VBRCloudTenant -Name "TenantName" PowerShell cmdlet returns proper numbers.

Cause

Miscalculations are caused by a bug in the stored procedure.

Solution

Automatic (with services restart)


DOWNLOAD PRIVATE FIX



MD5 for kb3004.zip: 97dfb14d66959f5cd4ec6279f890bef4
SHA-1 for kb3004.zip: 91b402007992ffe9a0dc2ce34b8954cb01476c1a
 
  1. Download the hotfix.
  2. Check the current version of Veeam Backup & Replication. It must be 9.5.4.2866.
  3. Make sure that no jobs are running, close the console, and stop all Veeam services.
  4. Right-click on the installation file and click "Run as administrator"
  5. Go through the wizard to install private fix.

Manual


DOWNLOAD SCRIPT



MD5 for kb3004_0.zip: 024ba03459d46e3c9be6b59d40066868
SHA-1 for kb3004_0.zip: 302af86b05b6bfc25e532db4f69045e7d6e41732
 
  1. Download archive with u4b_FIX_Licensing.Reporting.CC.GetInstancesInfo.sql file, extract and copy it to the SQL server, which hosts the Veeam Cloud Connect database or any other machine that can connect to the SQL instance in question.
  2. Connect to the SQL instance by using Microsoft SQL Studio. When connecting, please provide valid credentials with full permissions.
  3. Find your Veeam Cloud Connect database (its default name is VeeamBackup). Right-click it and select New Query.
  4. Open file u4b_FIX_Licensing.Reporting.CC.GetInstancesInfo.sql by using the text editor, copy all its content and paste it to the query window from step 3.
  5. Run the query by clicking Execute or pressing F5. Make sure that the query is executed successfully.
  6. The fix is applied immediately, restart of Veeam services is not required.
User-added image

More information

Should you have any questions, contact Veeam Support.
 
Send Article Feedback
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.