Configmgr 2012 CU2 can not create secondary sites after installing hotfix

There is a known bug with installing ConfigMgr 2012 CU2 which can prevent the creation of a secondary sites after installing the hotfix.

ConfigMgrSetup.log

INFO: Configuring database replication tables…
*** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]Object ‘PullDPResponse’ does not exist : spConfigureReplication
ERROR: Failed to execute dbo.spConfigureReplication.
ERROR: Failed to configure SQL Server replication tables.
~Setup cannot create the required database tables. Contact your SQL administrator.
~Setup has encountered fatal errors during database initialization. Contact your SQL administrator.

The bug has been fixed and will most likely be rolled out in the next CU.

This issue does not affect upgrades of existing secondary sites, or any other aspects of the Configuration Manager hierarchy.

Problem Description and Symptoms
1.You installed System Center 2012 Configuration Manager SP1.
2.You applied the Cumulative Update 2 (KB2854009) in the hierarchy.
3.You installed a new secondary site or tried to recover an old secondary site using the Installation Source Files option: “Copy installation source files over the network from the parent site server”.

The ConfigMgrSetup.log file will contain errors similar to the following after an installation attempt:

//

INFO: SQL Server Script: Creating object spupdatemessageactivity~

INFO: Configuring database replication tables..

*** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]Object ‘PullDPResponse’ does not exist : spConfigureReplication

ERROR: Failed to execute dbo.spConfigureReplication.

ERROR: Failed to configure SQL Server replication tables.

//

Workarounds

You can use either of the following workarounds to install a secondary site.

1.Using the Create Secondary Site Wizard, change the Installation Source Files setting to another location, instead of the parent primary site.
a.Create a shared folder with the System Center 2012 Configuration Manager SP1 CD and Redist folders. Download the prerequisite distributable files for the Configuration Manager installation and copy them to \SMSSETUP\Redist\. For additional instructions see http://technet.microsoft.com/en-us/library/gg712320.aspx#BKMK_InstallSecondarySite.
b.Run the Create Secondary Site Wizard to install a secondary site.
c.On the page Installation Source Files, choose “Use the source files at the following network location”, and specify the CD share folder.

Or
2.Replace the ReplicationConfiguration.xml file on the primary site with the original one from the SP1 CD.
a.Find ReplicationConfiguration.xml on the SP1 CD, and overwrite the file on your primary site (\bin\x64) with the version from the SP1 CD. WARNING: DO NOT EDIT THIS FILE as editing will change the timestamp and prevent future servicing updates to the file.
b.Restart the SMS_EXECUTIVE service.

You should be able to deploy the secondary site on a clean machine now.

If the secondary site installation has failed, you will need to manually clean up the following before you attempt to reinstall. To do this:
•Delete the SMS registry key on the secondary site machine – HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS
•Delete the database created on the secondary site machine.

Note: you still need to apply the Cumulative Update 2 on your secondary site after the installation.

Advertisements

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