question

SivakamaSundari-0184 avatar image
0 Votes"
SivakamaSundari-0184 asked LeoErlandsson commented

What is the use of stored procedure Sync.clearexport in FIM service Database.Please explain us.

What is the use of stored procedure Sync.clearexport in FIM service Database.Please explain us.

microsoft-identity-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeoErlandsson avatar image
0 Votes"
LeoErlandsson answered LeoErlandsson commented

Hi,

Running this (which you should only do if instructed so by a guide or Microsoft Product support) will clear the pending exports from the Sync engine to the FIM Service DB.

Br,
Leo

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks ! Currently we have an issue with the FULL Sync - the FIM Full Sync was not running and it shows "Stopped - Server error"

So in the below article,
https://social.technet.microsoft.com/wiki/contents/articles/11331.fim-2010-r2-troubleshooting-stopped-server-error-on-the-fim-service-management-agent.aspx

we were asked to run the Sync.clear Export stored procedure. Are we good to do this in the production environment ?

0 Votes 0 ·
LeoErlandsson avatar image LeoErlandsson SivakamaSundari-0184 ·

Hi,

I'd run a backup on all databases before doing that.
Unless instructed by Microsoft Product support, I'd not advise running the procedure.

If you want to take the risk (and have backups), sure, you could run it. If the problem in the article matches your problem, it could solve your problem.

Br,
Leo

0 Votes 0 ·