Unable to delete web application - sharepoint administrative framework error
All, I have a web application - no site collections, no content databases. I've tried time and time again to delete it and every time I receive the following error in Central Admin: An object in the SharePoint administrative framework, "SPWebApplication Name=SharePoint - Estate Portal Parent=SPWebService", could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(Guid id) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(SPPersistedObject obj) at Microsoft.SharePoint.Administration.SPPersistedObject.Delete() at Microsoft.SharePoint.Administration.SPWebApplication.Delete() at Microsoft.SharePoint.ApplicationPages.DeleteWebApplicationPage.BtnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) I also get this logged in Event Viewer on the WFE: Log Name: Application Source: Windows SharePoint Services 3 Date: 08/07/2011 14:15:35 Event ID: 5586 Task Category: Database Level: Error Keywords: Classic User: N/A Computer: Description: Unknown SQL Exception 547 occured. Additional error information from SQL Server is included below. The DELETE statement conflicted with the REFERENCE constraint "FK_SiteMap_Application". The conflict occurred in database "SharePoint_Config", table "dbo.SiteMap", column 'ApplicationId'. The statement has been terminated. I have so far, tried: Removing it via Central Admin Removing it via STSADM Associating it with a different SSP than all the other Web apps Re-creating a new site collection and content DB for it, and then re-deleting it Restarting the Timer service I guess I just don't understand what it is that's preventing the deletion? Clearly there is something somewhere that depends on this web app - so that's why it can't be deleted, but how can I identify it? Thanks in advance Duncan
July 8th, 2011 4:23pm

Hi Duncan, Very odd issue...just curious whehter you tried to run PSCONFIG wizard and see if there were any update pending at the database level? Probably worth a try. Thank you!BlueSky2010
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 10:11pm

Can you confirm that no modification was done to SP databases manually? It seems that there is a duplicate webapplication ID in siteMap table for this. You can run a select query on config database's siteMap table to find that out.
July 9th, 2011 8:16am

Hi Duncan , You can check if there are any solutions deployed on the web application or any timer jobs on the web application . 1. Go to Central Administration>Operations>Solution Management .Here you can check whether there are any solutions deployed on the web application. 2. Go to Central Administration>Operations>Timer Job Definitions .To see if there are any timer jobs on the web application . For more information, please refer to this site: Cannot delete web application: http://www.surfray.com/ontolica/178-cannot-delete-web-application.html Thanks, Entan Ming
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2011 8:32am

Hi All Thanks very much for your replies to date. BlueSky2010 - Can you please provide me with the appropriate command so I can use PSCONFIG to check for pending updates? Soumyadev - I can confirm NO updates or changes to the DB have been made, assuming there is a duplicate entry in the DB for it, I'm very hesitant to delete the entry or change the DB Entan Ming - I've checked all Timer jobs - nothing, and the solution list contains mostly solutions that have been "Globally Deployed", and s few that have been deployed to specific web applications (though none of them are the "problem" web app). Thanks Duncan
July 12th, 2011 11:13am

Hi , Have you tried to extend the web application to another IIS website from Central Administration -> Application Management -> Create or Extend Web Application -> Extend Web Application to another IIS Web Site ? The above process adds a new content db with the web application . And then try deleting the old web application .Will it work now? Or try to create a new config db using SharePoint Products and Technologies Configuration Wizard. Then delete the web application . Thanks, Entan Ming
Free Windows Admin Tool Kit Click here and download it now
July 14th, 2011 12:13pm

Hi Entan Ok, this is what I did: Extended the Web app to the Internet Zone - succesfully done (although oddly it returned me back to the Central Admin homepage, when it normally sends you to a screen where it asks you to create a Site Collection...?) Anyway, the newly extended site is visible in IIS. Attempted to delete the original web app but it still fails: An object in the SharePoint administrative framework, "SPWebApplication Name=SharePoint - Estate Portal Parent=SPWebService", could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(Guid id) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(SPPersistedObject obj) at Microsoft.SharePoint.Administration.SPPersistedObject.Delete() at Microsoft.SharePoint.Administration.SPWebApplication.Delete() at Microsoft.SharePoint.ApplicationPages.DeleteWebApplicationPage.BtnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Regarding creating a new Config database, I'm nervous about doing this at a farm level, as all the other web apps are working perfectly? Duncan
July 14th, 2011 12:25pm

Ok - so an update everyone, I managed to remove IIS from both the Intranet and Internet Zones for this Web App, and I can confirm it has no Content DB associated with it. I've also confirmed that there are no Timer Jobs waiting for it, and there are no deployed features to it. Is this looking like an edit of the config Database? I realise this isn't supported (and completely agree as to WHY!) but I'm not sure there are many options left. Is there are Query I can run aganist the DB that might show what the problem is? There seems to be a concensus that there may be a duplicate Web App ID in the "SiteMap" table - any suggestions on how to proceed? Thanks Duncan
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2011 12:08pm

Very strange.... I have the exact same issue right now with one of my Web Applications. All content databases are removed All Zones are removed All custom solutions are retracted and uninstalled Not sure what is holding onto the web application. This is the event viewer error: Unknown SQL Exception 547 occurred. Additional error information from SQL Server is included below. The DELETE statement conflicted with the REFERENCE constraint "FK_SiteMap_Application". The conflict occurred in database "SharePoint_Config", table "dbo.SiteMap", column 'ApplicationId'. The statement has been terminated. this is the powershell output: Remove-SPWebApplication : An object in the SharePoint administrative framework, "SPWebApplication Name=SharePoint - 80", could not be deleted because other ob jects depend on it. Update all of these dependants to point to null or differe nt objects and retry this operation. The dependant objects are as follows: At line:1 char:24 + Remove-SPWebApplication <<<< -Identity http://pigpen + CategoryInfo : InvalidData: (Microsoft.Share...PWebApplication: SPCmdletRemoveSPWebApplication) [Remove-SPWebApplication], InvalidOperatio nException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSP WebApplication Any thoughts as to what is going on?
July 16th, 2011 6:07am

Okay, I was able to delete the Web Application by manually deleting rows in the database... Now I know I violated all warranties -but manually deleting two rows in the SiteMap table using SQL Server Management Studio solved my issue. Luckily, this is a development SharePoint system and have no real "support" to worry about. Not sure how SharePoint got into this state. In any event, once the two orphaned rows were deleted -I was able to remove the Web Application via Central Administration. Hope this helps someone, Dan
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2011 6:42am

Hi Duncan, Try to run psconfig on your farm, then clear sharepoint cache and restart timer services on all servers in your farm and then try removing webapp. Follow the steps written here http://technet.microsoft.com/en-us/library/cc288561(office.12).aspx Running select SQL query with nolock attribute on your sharepoint database is supported, but msft doesn't support a SP database where insert/update/delete statement is fired without MSFT engineers knowledge. I strictly recomend not to run any such SQL statement on SP database, but a select query would be ok to execute. You will find all web application entries in objects table under config DB. Thanks, Soumyadev
July 17th, 2011 9:01pm

I have the same issue on a 2010 installation any further thoughts. There is a 2010 forum post stating the same thing http://social.technet.microsoft.com/Forums/da/sharepoint2010setup/thread/e07b1230-207e-4b91-9a8b-5e199c58c2f9 I would suspect that it is the same resolution, but I don't see any resolutions yet. Thoughts? Eric
Free Windows Admin Tool Kit Click here and download it now
May 1st, 2012 1:35pm

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

Other recent topics Other recent topics