I received messages about the Export on the FIM MA taking too long and my previous trick of restarting the FIM Service didn’t help.
Looking in the event viewer, I saw this error reported:
Unhandled exception, the CLR will not terminate: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘ReadSynchronizationError’, database ‘FIMService’, schema ‘sync’.
I know better than to change anything in the FIMService database, but I did compare permissions from a working instance for the service accounts and everything seemed to be in order.
After some pondering on the error message, I cleared out the connector spaces and re-initiated the environment. Seems to have worked. Glad this was on a dev server.
Didn’t see anything else posted online about this error, so maybe it’s a one off and it’ll never happen to anyone else again…