Generic Performance Mapper Module Failed Execution

Symptoms

SQL servers will raise alerts stating that the file space monitors that are part of the SQL Server management pack failed execution.

Example

Source: <ServerName>

Alert: Generic Performance Mapper Module Failed Execution

Alert Description:

Module was unable to convert parameter to a double value

Original parameter: ‘$Data/Property[@Name=’FreeSpacePercent’]$’

Parameter after $Data replacement: ”

Error: 0x80020005

Details: Type mismatch.

One or more workflows were affected by this.

Workflow name: Microsoft.SQLServer.2008.Monitoring.DBFileSpaceMonitor

Instance name: InstanceName_Data_0

Instance ID: {9C16EFCB-182C-876D-0182-9CA3C0113D98}

Management group: MgmtGroup

Cause

This is caused by a known issue with Windows Server 2008 R2 (Pre-SP1) that causes WMI to leak memory.

Solution

Install either SP1 on the server, or apply the following patch.  Unfortunately this requires a reboot.

http://support.microsoft.com/kb/981314

Advertisements

3 thoughts on “Generic Performance Mapper Module Failed Execution

  1. Igor

    Hi Dan,

    I’m facing with the same issue on my environment. I haven’t tried to install Windows Server update yet – I’ll try to do it soon and hope this will help.

    But how did you correlate that the SQL workflow issue is related to leaking WMI?

    Sincerely yours,
    Igor Savchenko

    Reply
  2. danmyhre Post author

    This was a known issue that the SCOM support team knew about. I don’t think it was published externally, but the support team knew right away to do this. I have applied the patch on at least 5 servers and it has worked on all of them.

    Reply
  3. felymich

    Hello,
    I have Windows Server 2008 R2 Enterprise SP1 installed and still seeing the issue with the
    ======================================================================
    Module was unable to convert parameter to a double value
    Original parameter: ‘$Data/Property[@Name=’PageFileSize’]$’
    Parameter after $Data replacement: ”
    Error: 0x80020005
    Details: Type mismatch.

    One or more workflows were affected by this.

    Workflow name: MomUIGeneratedRule19a7867fc70549768a4062f62e07274a
    Instance name: Microsoft Windows Server 2008 R2 Enterprise
    Instance ID: {61F32BC1-F880-52B3-D5D0-28DC8E2FBFDC}
    Management group: SCOM-MED
    =====================================================================
    Not sure what to do next !!!

    Thanks,
    Dom

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s