Capacity Planner : 'Type mismatch' Error 2

Opening Data Manager in Capacity Planner displays an error when using Non-English regional settings

Details

• When attempting to open the Data Manager, an error occurs.
• A dialog appears stating that MDAC 2.71 or above is required .Note: This error appears despite the fact that MDAC 2.71 or higher is installed.
• A database error from MSJET is seen containing a syntax error.
• You see one or more of the following errors:
  • ERROR: An unexpected error occurred!
    Module = vcpPerformance Function = UpdateTask:16 Source = Microsoft
    JET Database Engine Error = Syntax error in UPDATE
    statement.(-2147217900:0:5003144)
  • ERROR: An unexpected error occurred! Module = vcpSysPerf Function = CollectSystemPerformance: Source = vcpSysPerf Error = Type mismatch(13:0:1000013)

Solution

Set the "Standards and formats" setting to "English (United States)" in "Regional and Language Settings" while the Collector service is stopped.

To make this configuration change:

1. Click Start > Control Panel > Administrative Tools > Services.
2. Find the service "VMware Capacity Planner Service" and ensure that the Status is Stopped.
3. Open the Regional and Language Options from the Control Panel.
4. Click Regional Options. Select English (United States) from Standards and formats.
5. Return to the Services window and start the VMware Capacity Planner Service.

Tags

capacity-planner data-collector install-data-collector install-data-collector-fails