Error Deletion Service Failed To Clean Up
Contents |
360 games PC games failed to clean project failed to delete Windows games Windows phone games Entertainment All Entertainment
Failed To Clean Project Failed To Delete Surefire
Movies & TV Music Business & Education Business Students & educators
Failed To Clean Project Failed To Delete Maven
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Failed To Clean Project Failed To Delete Target
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
NoneEvent ID: 16387Date: DateTime: TimeAM User: N/AComputer: Computer_NameDescription:Error: Deletion Service failed to clean up some tables.Microsoft has a solution for this message. See http://support.microsoft.com/kb/921391/EN-US/ for their solution.Personally I don't feel comfortable with the solution they give. They are removing the enforced relationships for the tables which cause the issue. This will leave you with orphaned records in your database and probably the same issue when you upgrade to the upcoming titan release. Here are my steps to correctly fix this issue (partly copied from the MS solution) :To identify the table where the Deletion Service is failing, follow https://support.microsoft.com/en-us/kb/921391 these steps:1. On the Microsoft Dynamics CRM server, click Start, click Run, type cmd, and then click OK.2. At the command prompt, locate the system drive, locate the program files, locate Microsoft Dynamics CRM, locate the server, locate the bin, type crmdeletionservice.exe -runonce, and then press ENTER. You then receive a message that resembles the following message:Can't clean up the following tables: CampaignNote The table that is returned in the http://ronaldlemmen.blogspot.com/2006/10/error-deletion-service-failed-to-clean.html message is the table for which the Deletion Service failed.The following example demonstrates how to resolve this problem for the Campaign table.To resolve the problem for the Campaign table, follow these steps:1. Run a statement in Microsoft SQL Query Analyzer. To do this, follow these steps:a. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.b. Run the following query against the Organization Name_MSCRM database.delete from Campaign where DeletionStateCode = 2This query returns a message that resembles the following message:DELETE statement conflicted with COLUMN REFERENCE constraint 'campaign_leads'.2. Run two queries agains the Organization Name_MSCRM database.delete from [table name in message] where [column name in message] in (select campaignid from Campaign where DeletionStateCode = 2)delete from Campaign where DeletionStateCode = 2By doing this, you do delete the associated records as well. Keep in mind that once deleted, you cannot get the data back. Therefore always make a backup first! Labels: error, sqlserver, unsupported 16 comments: Anonymous said... worked for me. this is indeed a better solution than the one from MS.thank you very much! November 22, 2006 8:25 AM Anonymous said... thanks alot for this article! it worked for me alright January 18, 2007 3:47 PM Anonymous said... Hi Ronal
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
Forum RulesUser Blogs Gallery Community Community Links Social Groups Pictures & Albums Members List Go to Page... MSCRMDeletion Service | Deletion service failed to clean up some t Microsoft Dynamics CRM Page 1 of 2 1 2 > View First Unread Thread Tools Display Modes 28-11-2007, 10:02 AM #1 Pat Birkeland Guest Posts: n/a MSCRMDeletion Service | Deletion service failed to clean up some t I was researching an error which has popped up on our CRM server (MSCRMDeletionService | Deletions service failed to clean up some tables) and came accross Microsoft KB921391 (http://support.microsoft.com/kb/921391). I ran through the solution and actually found that the error was in the ActivityPointer and therefore I wasn’t able to successfully run the accompanying SQL script as the subsequent step. Has anyone run across this issue before? Sponsored Links 28-11-2007, 10:03 AM #2 Mike Guest Posts: n/a RE: MSCRMDeletion Service | Deletion service failed to clean up some t Hi and thanks for the post. According to the kb article, the next step: 2. Correct the records that are causing the constraint conflict by using a statement that resembles the following statement. However, Note:: The table and the fields that you use in the statement depend on the message that you received in step 1b earlier in this section. Each of the queries will need to be edited according to the results of the previous query. Sometimes that can go on for a while until the most deeply related record is found. Once that most deeply related record is removed, then the layer above that can be removed, and so on. until the query returns no records at all. I hope that this will get you going. Kind regards, Mike Microsoft Online Partner Support ================================================== ==== PLEASE NOTE: Th