locked
WSUS SYNC Issue RRS feed

  • Question

  • Downstream server unable to synchronize from upstream server. When we checked event id it is showing 10022 "The last catalog synchronization attempt was unsuccessful."

    Below is the error we got :

    SqlException: Cannot insert the value NULL into column 'UpdateType', table 'SUSDB.dbo.tbDeployment'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
       at Microsoft.UpdateServices.Internal.DataAccess.HideUpdatesForReplicaSync(String xmlHiddenUpdateIds, String xmlAllUpdatesIds)
       at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ProcessHiddenUpdates(Guid[] hiddenUpdates, UpdateIdentity[] allUpdates)

       at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ReplicaSync()
       at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ExecuteSyncProtocol(Boolean allowRedirect)

    I have tried database reindexing also, still persisting the same issue. 

    Thanks,

    Narayan. N

    Monday, March 30, 2020 5:51 AM

All replies

  • SqlException: Cannot insert the value NULL into column 'UpdateType', table 'SUSDB.dbo.tbDeployment'; column does not allow nulls. INSERT fails.

    Hi Narayan,
       

    This appears to be some problem with the SUSDB data of the upstream WSUS server, causing synchronization issues between the downstream server and the upstream server. My suggestion is:
       

    1. The first is the index reconstruction of WSUS data through the following script: "Re-index the WSUS Database".
         
    2. This issue has been observed to happen after a database collation change in SQL server, this article suggests some ways to deal with such issues: "Cannot insert the value NULL into column 'ID', table 'xxxxx'; column does not allow nulls. INSERT fails".
          
      * PLEASE NOTE: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
         
    3. If there is no better way to repair the SUSDB database, consider re-establishing the WSUS role will be a quick solution. You can refer to the steps mentioned in this thread to completely clean up the current WSUS role and related components:"How to completely remove old wsus settings".
         

    Since the above steps will involve some database operations, please carefully consider the feasibility of the recommendations.
    Hope the above can help you.
       

    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, March 30, 2020 9:17 AM
  • Hi Narayan,
     

    Any update is welcome here.
    If the issue is resolved, share your solution or find the helpful response "Mark as Answer" to help other community members find the answer.
     

    Thank you for your cooperation, as always.
     

    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, April 6, 2020 1:17 AM
  • Hi,
       

    Since this thread has not progressed for a long time, the following summary is now provided for reference during later follow-up:
       

    • Issue Symptom
      WSUS data synchronization error, located on the downstream server.
      Related error message: SqlException: Cannot insert the value NULL into column 'UpdateType', table 'SUSDB.dbo.tbDeployment'; column does not allow nulls. INSERT fails.
         
    • Possible Cause
      SUSDB database related issues.
         
    • Troubleshooting Steps so far
      Suggestions for repairing related databases have been provided.
         
    • Next Step
      Confirm the maintenance results to confirm whether it is a database problem.
         
    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, May 12, 2020 7:52 AM