Avatar of telliot79
telliot79
 asked on

sharepoint 2013 can't delete BDC service application

experts,

I recently tried to patch my farm with the 2017 CU and noticed it failed at the end when trying to update my BDC database. We don't use the BDC service application and it looks like the database for that service app has been inadvertently deleted. I've tried to delete the service application using Central Admin and Powershell, but it times out. Is there a way I can manually remove this so I can successfully patch my farm?

Many thanks,

Tom
Microsoft SharePoint

Avatar of undefined
Last Comment
Walter Curtis

8/22/2022 - Mon
Walter Curtis

If you aren't using it, them maybe provision the service, patch your farm, then remove the service. A bad way to do things, but might make the update happy enough to complete successfully.

Good luck...
telliot79

ASKER
Thanks Walter Curtis,

what do you mean by provision the service? I can't actually do anything with it. I've tried deleting it, changing the database name associated with it (hoping that it would create a new database), and also deleting it but unfortunately nothing's worked. It's now stuck in the stopping state, and anything I attempt to perform on the service app just times out after a while.
Walter Curtis

I must have overlooked the part about it being stuck and you being unable to remove it. As you mention, powershell should remove it. This may require and IIS restart, or at least an app pool recycle, however you shouldn't do that on a production system during business hours.

Good luck...
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
telliot79

ASKER
yea, powershell didn't remove it. it timed out. So I'm a bit stuck now. any other suggestions?
Walter Curtis

I'm sure this is what you followed, but just in case you didn't find this, here is a good article about removing service applications:

https://technet.microsoft.com/en-us/library/ee704553.aspx


...
telliot79

ASKER
yes, that's exactly what I've followed. no joy unfortunately. just times out.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Walter Curtis

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
telliot79

ASKER
yea, I see the service. tried iis reset and reboots. no joy.
telliot79

ASKER
shamefully, one of my servers in the farm was waiting for a reboot. once I rebooted, by BDC service app came online and I was able to delete it.

Thanks for your persistence.
Walter Curtis

Great, glad you got it fixed and I could help a little.

Thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61