Errors in Windows Azure Pack after applying Update 1 to System Center 2012 R2 VMM

After applying the Microsoft update KB, you may see your templates and plans not updating in WAP.

The normal steps to check are to look at the disks and templates. In WAP all templates and disks need to have an Operation System configuration.

After the update no more new templates appear in WAP and adding a subscription to a plan fails to sync. This happens because of an updated store proc in the SQL database.

Checking VMM you will see the following error:


VMM Error report will show the following:

Error = 8144
Index #0
Source: .Net SqlClient Data Provider
Number: 8144
State: 2
Class: 16
Server: SYSSQL01
Message: Procedure or function prc_RBS_UserRoleSharedObjectRelation_Insert has too many arguments specified.
Procedure: prc_RBS_UserRoleSharedObjectRelation_Insert
Line: 0


To fix the issue you need to update the sql store proc with the code from the KB 2904172. Then perform a sync on any user subscription that is not in a sync’ed state.

TSQL code is

use [VirtualManagerDB]

/* script starts here */
ALTER Procedure [dbo].[prc_RBS_UserRoleSharedObjectRelation_Insert]
@ID uniqueidentifier,
@ObjectID uniqueidentifier,
@ObjectType int,
@RoleID uniqueidentifier,
@UserOrGroup varbinary (85),
@ForeignAccount nvarchar (256),
@IsADGroup bit,
@ExistingID uniqueidentifier = NULL OUTPUT
SELECT @ExistingID = [ID] FROM [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
WHERE [ObjectID] = @ObjectID AND [RoleID] = @RoleID
— Select owner OR Select all which matches ForeignAccount or UserOrGroup OR
— both ForeignAccount and UserOrGroup is NULL
(([UserOrGroup] = @UserOrGroup OR [ForeignAccount] = @ForeignAccount) OR
([UserOrGroup] IS NULL AND @UserOrGroup IS NULL AND [ForeignAccount] IS NULL AND @ForeignAccount IS NULL))
/* Ignore duplicate entries */
IF (@ExistingID IS NULL)
INSERT [dbo].[tbl_RBS_UserRoleSharedObjectRelation]
/* script ends here */

Hyper-V did not find virtual machines to import


When doing some export and imports of the VM using Hyper-V I found an issue related to security. When System Centre VMM is used in the environment, a security ID is placed on all VM. This security ID stops you from importing the VM into Hyper-V.

When importing via the GUI you get the following message;


While doing some testing I found the following section inside the virtual machine configuration file.


<sd type=”string”>O:S-1-0-0D:(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-1111)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-1109)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-1107)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-1110)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-1105)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;DA)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-1104)(OA;;CC;5cf72d6e-61d5-4fbe-a05c-1e3c28d742fa;;S-1-5-21-4026737508-1815974660-2349268802-500)</sd>



The quick fix is to remove this security element from the xml configuration file.

I have also found that this happens when you remove a Hyper-V from a domain or VMM structure without first removing the virtual. In this case Hyper-V will report no Virtual Machines found on the Hyper-V server. To correct this, remove the security from the configuration files and refresh Hyper-V manager. The virtual machines will all appear again.

System Center 2012 SP1 CTP2 Virtual Machines

The following Virtual Machines are now available for System Center 2012 SP1 CTP2 evaluation:

App Controller :

Operations Manager :

Orchestrator :

Service Manager :

Virtual Machine Manager :

Microsoft System Center Self-Study Guide Part I – III

A very nice collection of Microsoft System Center Self-Study guides by Scott Rachui. If you are looking at deployment, learning more or the exams check out the following blog posts.

If you need more help with System Center, don’t forget to check out the following blogs and use the forums;

Useful Blogs