- Knowledge Base Listing Page
- VM Right-Sizing report fails with error "Query execution failed for dataset ‘AnalysisDS’"
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
Challenge
VM Right-Sizing report fails with the following error:
Query execution failed for dataset ‘AnalysisDS’. Error converting data type varchar to numeric.
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.
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
If you have any questions or problems, please contact Veeam Support at http://www.veeam.com/support.html
Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
Spelling error in text
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
Verify your email to continue your product download
We've sent a verification code to:
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
Start using Veeam:
Download the product
&
Activate the license key
Thank you!
Your feedback has been received and will be reviewed.