[Solved] Issue deleting products

Topics: Misc.
Sep 5, 2014 at 5:23 PM
Edited Sep 5, 2014 at 5:40 PM
When I try to delete a product, WPP crashes, the SQL server runs a task for a while after this, and then when it's done, there's a new declined update under the product called "Delete Me !", and the product is never actually deleted. I'm not certain if this is specific to my environment, or if it's an issue with WPP.

This occurs whether the product being deleted is the only product listed for the publisher or if there are other products listed for the publisher that will remain after the product is deleted.

All of the following conditions are met from: https://wsuspackagepublisher.codeplex.com/discussions/471290
  • Run WPP locally on the Wsus server.
  • Product folder must be empty.
  • Product mustn't have been publish by Microsoft.
  • Product can't be the "Locally Published Packages" folder
  • Option to make newly published update visible in Wsus Console, must be different from "Never".
I'm not sure how to troubleshoot this, or else I'd give more details.
Coordinator
Sep 13, 2014 at 7:15 PM
Try to delete an empty product. When WPP failed, go to %temp% folder. Look for the file 'Wpp-guid.log'. Send me this file at package.publisher@free.fr with a reference to this thread.
Marked as answer by austinian on 9/15/2014 at 6:21 AM
Sep 15, 2014 at 1:21 PM
Alright, based on that log, I think that the issue is being caused by DB corruption. I've been planning on moving to a new DB soon, so that should fix this issue.
9/15/2014 8:58:29 AM    Selecting Java SE Runtime Environment 8 (0)
9/15/2014 8:58:30 AM    Entering Void ctxMnuTreeview_ItemClicked(System.Object, System.Windows.Forms.ToolStripItemClickedEventArgs)
9/15/2014 8:58:30 AM    Delete Product.
9/15/2014 8:58:30 AM    Entering EmptyProductDeleterResult DeleteProduct(System.Guid) : 991751d3-b928-448b-d313-f690b05130a5
9/15/2014 8:58:30 AM    Entering Void StartWaitingForm(System.String)
9/15/2014 8:58:30 AM    Entering Microsoft.UpdateServices.Administration.IUpdate PublishUpdate(Microsoft.UpdateServices.Administration.IUpdateCategory, Microsoft.UpdateServices.Administration.IUpdateCategory) : Product to Delete : Java SE Runtime Environment 8 and Vendor to delete : Oracle Corporation
9/15/2014 8:58:30 AM    Entering System.String GetTempFolder()
9/15/2014 8:58:30 AM    Returning : C:\Users\ADMINI~1.COM\AppData\Local\Temp\2\Wsus Package Publisher\
9/15/2014 8:58:39 AM    Successfuly publish ProductKiller
9/15/2014 8:58:39 AM    Entering Boolean MakeLocallyPublished(Microsoft.UpdateServices.Administration.IUpdateCategory, Microsoft.UpdateServices.Administration.IUpdateCategory) : Product to Delete : Java SE Runtime Environment 8 and Vendor to delete : Oracle Corporation
9/15/2014 8:58:39 AM    Entering Boolean MakeLocallyPublished(Microsoft.UpdateServices.Administration.IUpdateCategory, Microsoft.UpdateServices.Administration.IUpdateCategory)
9/15/2014 8:58:39 AM    Entering Void .ctor()
9/15/2014 8:58:39 AM    Entering System.String GetServerName()
9/15/2014 8:58:39 AM    IsUsingWindowsInternalDatabase : True
9/15/2014 8:58:39 AM    Major Version : 3
9/15/2014 8:58:39 AM    Entering Boolean Connect(System.String, System.String)
9/15/2014 8:58:39 AM    \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query : SUSDB
9/15/2014 8:58:39 AM    Connected to SQL !
9/15/2014 8:58:39 AM    Connected to SQL
9/15/2014 8:58:39 AM    ProductToDelete UpdateSource = MicrosoftUpdate
9/15/2014 8:58:39 AM    Entering Boolean MakeLocallyPublished(Microsoft.UpdateServices.Administration.IUpdateCategory, Microsoft.UpdateServices.Administration.IUpdateCategory)
9/15/2014 8:58:39 AM    Entering Void QuerySql(System.Collections.Generic.List`1[System.Guid], Int32)
9/15/2014 8:58:39 AM    UPDATE [SUSDB].[dbo].[tbUpdate] SET [IsLocallyPublished] = 1 WHERE [UpdateID] = '991751d3-b928-448b-d313-f690b05130a5'
9/15/2014 8:58:39 AM    Entering Void Disconnect()
9/15/2014 8:58:39 AM    End of SQL session
9/15/2014 8:58:39 AM    Successfuly made LocallyPublished
9/15/2014 8:58:39 AM    Entering Void DeclineUpdate(Microsoft.UpdateServices.Administration.IUpdate) : Delete Me !
9/15/2014 8:58:39 AM    Entering EmptyProductDeleterResult DeleteProduct(System.Guid)
9/15/2014 8:59:15 AM    ThreadException. Something Went Wrong
9/15/2014 8:59:15 AM    **** SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x56832d48; actual: 0x56832d98). It occurred during a read of page (1:450529) in database ID 5 at offset 0x000000dbfc2000 in file 'd:\WSUS\\UpdateServicesDbFiles\SUSDB.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
9/15/2014 8:59:15 AM    Entering Void .ctor() : FrmSendDebugInfo
Dec 10, 2014 at 7:11 AM
I'm having the exact same issue. I'll send the logfile to you...