SCOM Workflow is throwing error :Microsoft.SQLServer.2008.DBFile.S paceFreeMegabytes.Collection

Hi Team,

Greetings for the day.

Getting the below error,please let me know the update/solution for this error.

Details:

Module was unable to convert parameter to a double value
Original parameter: '$Data/Property[@Name='FreeSpaceMB']$'
Parameter after $Data replacement: ''
Error: 0x80020005
Details: Type mismatch.
One or more workflows were affected by this.
Workflow name: Microsoft.SQLServer.2008.DBFile.SpaceFreeMegabytes.Collection
Instance name: DTPlat_Stg_Code
Instance ID: {107777CB-B70A-075F-4F60-388F798DDD8C}
Management group: SNA

Thanks.

Regards,

Subhani Shaik

September 10th, 2015 3:50pm

May be you need update your SQL MP to its latest version

pl. chk this article

https://social.technet.microsoft.com/Forums/systemcenter/en-US/d2a4fff0-038e-4970-9eff-d1fa48c94a34/sql-server-mp-6400-operations-manager-failed-to-convert-performance-data

Free Windows Admin Tool Kit Click here and download it now
September 10th, 2015 4:22pm

Thanks Faizan.....
September 10th, 2015 6:40pm

1) Please refer to DAN Myhre's Blog:
https://danmyhre.wordpress.com/2012/12/18/generic-performance-mapper-module-failed-execution/
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.

2) You may try to refer to Faizan suggestion, update SQL Mp into most updated version,http://www.microsoft.com/en-us/download/details.aspx?id=10631 . However, i does not think that this is must help in solving your issue except your present MP version is 6.3.173.0 or below.
https://social.technet.microsoft.com/Forums/systemcenter/en-US/d2a4fff0-038e-4970-9eff-d1fa48c94a34/sql-server-mp-6400-operations-manager-failed-to-convert-performance-data
The above post is solving the bug of  CPU Utilization Monitor but you issue is about DB file Free Space.
Roger

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 12:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics