SharePoint Error – Stale URI Endpoint

Got the following error in Event Viewer:

An exception occurred while addresses for connected app.

StaleURI#1

In this case, it was because I removed a Service Application that did not remove itself cleanly.

The easiest way to clean up this error is to log onto the database server and remove it from the Configuration database.

NP – Use the GUID from the error message and insert it into the GUID where statement below:

SELECT *
FROM dbo.FARM_CONFIG_DB
WHERE GUID LIKE ‘%81293e27%’
GO

DELETE
FROM dbo.FARM_CONFIG_DB
WHERE GUID LIKE ‘%81293e27%’
GO

SELECT *
FROM dbo.FARM_CONFIG_DB
WHERE GUID LIKE ‘%81293e27%’
GO