locked
Cannot delete package - Primary Key contraint violation RRS feed

  • Question

  • Hi,

    I have a software deployment package that I've had a problem with deleting, I get the following error. Any help will be appreciated, thanks.

    Date: 21/04/2010 12:59:34
    Application: System Center Essentials
    Application Version: 6.0.1885.0
    Severity: Error
    Message: Violation of PRIMARY KEY constraint 'PK__tbFileForRevisio__2042BE37'. Cannot insert duplicate key in object 'dbo.tbFileForRevision'.
    invalid file information in XML
    The statement has been terminated.

    System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__tbFileForRevisio__2042BE37'. Cannot insert duplicate key in object 'dbo.tbFileForRevision'.
    invalid file information in XML
    The statement has been terminated.
       at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ImportUpdateForPublishing(String susXml, String uspXml, ServerSyncUrlData[] urlData, Boolean sdpOnly)
       at Microsoft.UpdateServices.Internal.BaseApi.Publisher.VerifyAndPublishPackage()
       at Microsoft.UpdateServices.Internal.BaseApi.Publisher.RevisePackage()
       at Microsoft.UpdateServices.Internal.BaseApi.Update.ExpirePackage()
       at Microsoft.EnterpriseManagement.SCE.Internal.UI.SoftwarePackagesView.DeletePackageProgressForm.DeleteItemsBackgroundWorkerDoWork(Object sender, DoWorkEventArgs e)
       at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
       at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

    Wednesday, April 21, 2010 12:16 PM

All replies