Good day,

i am facing a strange issue with Sccm 2012 sp1 it was successfully downloading updates a few days ago but now i am receiving consecutive errors when it attempts to synchronize new updates after skipping the updates it already has it  fails as shown in the below  it is using a SQL2012 database

error 14: SQL Error Message Failed to generate documents:A .NET Framework error occurred during execution of user-defined routine or aggregate "fnGenerateLanternDocumentsTable": ~~System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. ---> System.MethodAccessException: Attempt by method 'System.Configuration.TypeUtil.CreateInstanceRestricted(System.Type, System.Type)' to access method 'System.Diagnostics.SwitchElementsCollection..ctor()' failed. ---> System.Security.SecurityException: Request failed.~~System.Security.SecurityException: ~~   at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(RuntimeAssembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandleInternal rmh, SecurityAction action, Object demand, IPermission permThatFailed)~~   at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandleInternal rmh, Object assemblyOrString, SecurityAction action, Boolean throwException)~~   at System.Security.PermissionListSet.CheckSetDemandWithModification(PermissionSet pset, PermissionSet& alteredDemandSet, RuntimeMethodHandleInternal rmh)~~   at System.Security.PermissionListSet.CheckSetDemand(PermissionSet pset, RuntimeMethodHandleInternal rmh)~~   at System.Security.PermissionListSet.DemandFlagsOrGrantSet(Int32 flags, PermissionSet grantSet)~~   at System.Security.CodeAccessSecuri~~	...~~System.TypeInitializationException: ~~   at System.Data.SqlClient.SqlConnection..ctor()~~   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManage..., Digest:<DesiredConfigurationDigest xmlns="http://schemas.microsoft.com/SystemsCenterConfigurationManager/2009/07/10/DesiredConfiguration"><SoftwareUpdate AuthoringScopeId="Site_D33C1F2A-0FAB-4021-BC9B-6669D8586AE9" LogicalName="SUM_1e142388-5374-4072-9a46-b4879bab2d8b" Version="203"><Annotation xmlns="http://schemas.microsoft.com/SystemsCenterConfigurationManager/2009/06/14/Rules"><DisplayName Text=""/><Description Text=""/></Annotation><ConfigurationMetadata SmsUniqueIdentity="1e142388-5374-4072-9a46-b4879bab2d8b" Version="203"><Provider SourceType="default"><Operation Name="Detect"><Parameter Name="ScanTool"><Property Name="ScanToolId" Value="{D33C1F2A-0FAB-4021-BC9B-6669D8586AE9}"/><Property Name="MinCatalogVersion" Value="30"/></Parameter></Operation><Operation Name="Install"><Content ContentId="1e142388-5374-4072-9a46-b4879bab2d8b" Version="1"><FileContent Name="windows8-rt-kb2840633-x86.cab" Size="258495" Signed="true" Hash="B391C0EBF1123E10B79405200BD5B357D6DE52C6" HashAlgorithm="SHA1" SourceURL="http://wsus.ds.download.windowsupdate.com/msdownload/update/software/secu/2013/06/windows8-rt-kb2840633-x86_b391c0ebf1123e10b79405200bd5b357d6de52c6.cab"/></Content><Parameter Name="CommandLine"><Property Name="CommandLine" Value="/WUSInstaller /UpdateID:1e142388-5374-4072-9a46-b4879bab2d8b"/></Parameter><Parameter Name="RequiresExclusiveHandling"><Property Name="RequiresExclusiveHandling" Value="False"/></Parameter></Operation></Provider></ConfigurationMetadata></SoftwareUpdate></DesiredConfigurationDigest>

Failed to sync update 15bf7ab8-bd08-4e9d-8889-6cf2fc5ca368. Error: Failed to save update 5fc243d8-948e-4b33-8b43-ed7789fac191. CCISource error: 14. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate

I could not find much info has anyone run into this before?

Thanks

Try to remove this update KB2840628 It seems that this update breaks sccm 2012 sp1 with mssql 2012. It also makes creating new software iimpossible.
Remove it from the sql server if it is remote.

Try to remove this update KB2840628 It seems that this update breaks sccm 2012 sp1 with mssql 2012. It also makes creating new software iimpossible.
Remove it from the sql server if it is remote.

Try to remove this update KB2840628 It seems that this update breaks sccm 2012 sp1 with mssql 2012. It also makes creating new software iimpossible.
Remove it from the sql server if it is remote.

Thank you, thank you, Ravnda! Setup SUP and out of habit ran all updates including KB2840628. Would not download updates. Same error as OP. Tried removing SUP role and uninstalling WSUS. Reinstalled WSUS and added SUP back. No joy. Removing KB2840628 fixed it. Again, a very big thank you!

Workarounds at: http://blogs.technet.com/b/configmgrteam/archive/2013/07/17/issues-reported-with-ms13-052-kb2840628-and-configmgr.aspx

Rather than uninstall. Just an FYI :)

Workarounds at: 

Rather than uninstall. Just an FYI :)

Following the steps in this Technet post resolved the issue for me, thank you for sharing.

I assume that we should make sure to follow up on this and undo these changes after the revised .NET Framework 4 security update is released.

Better solution: http://support.microsoft.com/kb/2872041/en-us (compared to workarounds, uninstalling the hotfix or tweaking settings manu