Unable to delete package
Hi, I packaged my download folder by accident now I am unable to delete it. Can someone please help me error message: Date: 8/23/2010 9:44:03 AM Application: System Center Essentials Application Version: 6.0.1885.0 Severity: Error Message: Violation of PRIMARY KEY constraint 'PK__tbFileForRevisio__7B313519'. 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__7B313519'. 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)
August 23rd, 2010 7:53pm

Hello m450, You can recreate the package with a same GUID, and try delete the package from the SCE console. To do it, follow the steps below: 1. Right click the software package in SCE console, and choose delete. When the error occurs, it wrote an entry to "C:\Program Files\Update Services\LogFiles\SoftwareDistribution.log": VerifyandPublishPackage: Failed to verify signature for file: <complete path to cab file> For example,a complete path could be: \\computer name\UpdateservicesPackages\12345\6789_1.cab 2. Go to UpdateServicesPackages folder, create the sub folder, and rename it as the same as the old one, in my example, it should be 12345 3. Create a folder under this new created folder(12345) and rename it as 6789, copy the original installation file into it(under 12345\6789\ ). 4. Create a new txt file and rename it as 6789_1.cab under 12345 folder, copy the original installation file into it(under 12345\6789_1.cab\ ). 5.Open SCE console, repeat the step 1 to delete it. Hope it helps,Yog Li -- Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2010 2:02pm

Hi Yog, Thanks for the quick reply. However, I am still getting the same error. Is there another method to delete a package manually?
August 24th, 2010 7:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics