Issue With SQL Server MP Version 6.6.2.0: Log File DW Fills Up…

---

Update October 23th:
Microsoft has pulled this MP and is working hard to solve it. When your SCOM environment is affected by it, go here in order to fix it.

---

As it turns out, the SQL Server MP version 6.6.2.0 has a ‘known issue’.

Because of this issue the log file of the Data Warehouse database starts to fill up, causing these errors to pop up:

1. ‘…Data Warehouse failed to deploy database component. Failed to deploy Data Warehouse component. The operation will be retried…’
2. ‘…Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: ‘[GUID]', Management Pack Version-dependent Id: '[GUID]'; Target: Database, Server name: '[DW Server Name]', Database name: 'OperationsManagerDW'. Batch ordinal: 39; Exception: Sql execution failed. Error 9002, Level 17, State 4, Procedure Microsoft_SQLServer_Visualization_Library_UpdateHierarchy, Line 192, Message: The transaction log for database 'OperationsManagerDW' is full due to 'ACTIVE_TRANSACTION'…’

Cause & Workaround
The suspected culprit is the SQL Server Visualization Management Pack. Remove it and all it’s dependencies.

Aftermath
I notice that some people already complained about this issue with the SQL Server MP version 6.6.0.0. Until now I haven’t seen it for myself. But be careful here.

Credits
A BIG thanks to a regular reader of my blog, John Bradshaw. He pointed this issue out to me. Thanks John!