2 Replies Latest reply on Aug 13, 2012 1:38 PM by upinya

    changing WSUS server, getting error


      Im trying to have my console reconnect with our WSUS server over SSL, and getting this error:


      Source: Csla

      Exception occurred at 8/8/2012 12:04:20 PM: Violation of PRIMARY KEY constraint 'PK_UpdateServicesServer'. Cannot insert duplicate key in object 'dbo.UpdateServicesServer'. The duplicate key value is (fe1ace3c-93b7-4234-99ec-9fc8eac5b01d).

      The statement has been terminated.

      DataPortal_Insert method call failed

      1. DataPortal.Update failed

      Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

         at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

         at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

         at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

         at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

         at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

         at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

         at EminentWare.BusinessObjectLayer.UpdateServicesServer.Insert(SqlConnection cn)

         at EminentWare.BusinessObjectLayer.UpdateServicesServer.DataPortal_Insert()

         at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)

         at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)

         at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

         at Csla.DataPortal.Update(Object obj)

         at Csla.DataPortal.Update[T](T obj)

         at Csla.BusinessBase`1.Save()

         at EminentWare.BusinessObjectLayer.UpdateServicesServer.Save()

         at EminentWare.UI.Management.DiscoverandConfigureEnterpriseManagedResourcesWizard.wizardPageFinalSummary_FinishButtonClick(Object sender, EventArgs e)

        • Re: changing WSUS server, getting error
          Lawrence Garvin

          The message "Violation of PRIMARY KEY" is an indication that the object already exists. The table 'dbo.UpdateServicesServer' is a Patch Manager table, not a WSUS table. The above error message indicates that you may be attempting to register a WSUS server that is already registered with Patch Manager.


          You say that you are trying to have your console reconnect with WSUS ...  I'm assuming you are talking about the Patch Manager console. If  you select the Update Services node in the Patch Manager console -- is your WSUS server listed in the details pane?

          1 of 1 people found this helpful