VM Right-Sizing report fails with error "Query execution failed for dataset ‘AnalysisDS’"

KB ID: 1565
Product: Veeam Management Pack for Microsoft System Center
Version: 5.7
Published: 2012-03-19
Last Modified: 2020-08-28
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

VM Right-Sizing report fails with the following error:

Query execution failed for dataset ‘AnalysisDS’. Error converting data type varchar to numeric.

Cause

The error occurs because of unsupported decimal separator format on the Collector machine. A dot (.) is expected as the decimal separator. If a comma (,) is specified as the decimal separator, the collected data cannot be converted to numeric. As a result, the Virtual Machine Right-Sizing report cannot be generated.

Solution

To resolve the issue, either set the English System Locale in Region and Language options or change the decimal separator setting in Region and Language > Formats > Additional settings > Decimal symbol (for Win 2k3: Region and Language Options >  Regional Options > Customize > Decimal Symbol).

Make sure you change the decimal symbol for nworks collector service account.

Next, trigger full topology rebuild in nworks UI > Enterprise Manager > Rebuild Full Topology (available, when the Enterprise Manager node is selected in the left pane). Once the topology is updated, the issue will be resolved.

More information

Note, that once the issue is fixed, the report will work from the day the first portion of valid data was saved to the database. The change of the decimal separator does not affect the data collected earlier.

If you have any questions or problems, please contact Veeam Support at 
http://www.veeam.com/support.html
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.