Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

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

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)

Find more posts tagged with

Accepted answers

All comments

LGarvin

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?

upinya

Thanks. I was trying to delete the WSUS with a port 80 connection and readd the same one with a SSL connection, and was having this issue. I had to poke around and finally found where to remove the server, as it was not entirely clear.

Thanks!