App Management Service for Sharepoint 2013 SP Desinger Workflows

My Application Event log is filled with SharePoint Foundation Error - Event ID 8031, it shows up every 15 minutes… with a big question mark, I turned to internet search engine; some suggested apply the October Cumulative updates for SharePoint 2010 which we already did last year, other suggest rebuild the SharePoint! OMG!

Basically, here is the summary of what you need to do.

1. Copy the long ID from  the event log
2. Search the ID in SharePoint Config DB
3. Retrieve the Column ID
4. Then run stsadm -o deleteconfigurationobject command
5. Done!

Here are the details

1. Copy the long ID from the event 8031, just like the blue highlight in the image above
2. Logon to SQL Server and lunch SQL Management Studio 
3. Navigate to SharePoint_Config database, create a new SQL Query, and enter the following statement
• SELECT ID, Properties FROM [Objects] WHERE [Name] LIKE '%24ca5db5-9a2f-4a3d-9e52-38ab5a1a7ab0_735388cb-9769-4d37-b212-0b17a5db02f8%'
4. Note the id was copied from the screen above.
5. The query result returned with one record found. (screen below) 

• Feel free to look into the XML contents if you are interested.
6. Then I copy the column id from the above image (highlighted in purple)
7. Go back to the Web server and run the following stsadm.
• STSADM -o deleteconfigurationobject -id C8D9F11F-D129-41D7-9248-D54DE43059D2
8. The operation completed successfully, 

You should stop receiving the Event ID 8031 every 15 minutes. You pretty much need to repeat this work every time after you remove a SharePoint Search Application from your farm.

Hope this help!