FIM MA run profile stuck with stopped-database-connection-lost

FIM 2010 RTM (4.0.2592.0)
Demo system up and running.
But in the Run history a initialization run profile of the FIM MA got stuck in the interface. (FI + FS + Export + DI + FS steps)
Run profile status = in-progress.
2nd step (FS, Full sync) says : stopped-database-connection-error.
Manually running the same run profile again is running fine.
Right-click on the run profile, then selecting stop, results in an error: The operation failed because the management agent is not running.
Have rebooted the system a few times (due to additional component installs..).
Restarted the FIM services.
Cleaning the run profile history does not help, the run profile stays put.

Any suggestions, except for direct manipulation of the FIM sync DB?

Kind regards,
Peter
 

May 5th, 2010 1:51am

To me, this sounds like a bug - a PSS issue.

Cheers,
Markus

Free Windows Admin Tool Kit Click here and download it now
May 5th, 2010 2:30am

It's a small bug in the "Clear Runs" command. It can't remove runs that don't have a valid End Date.

You can run a very simple SQL command to set the end date to a valid value:

UPDATE [mms_run_history]
SET end_date = start_date
WHERE
run_result = 'in-progress' AND is_run_complete = 1

Next, do another "Clear Runs" in the FIM console.

Kind Regards,

Kevin Reeuwijk
Getronics Consulting

February 10th, 2011 6:47pm

Hi,



All the issues get when you have to Run USER Profile Services  So Please Check the Below point which has to be consider first.

1 : Permission :-AD / FIM / Network Services (for 1004,1015 etc. Read and exc. in /14 folder)

2: Account :- User Profile Synchronization Service / create and Configure Accounts and Permissions

3: SharePoint 2010 Version + Leatest Cumulative Updates (CU).

4: AD Permission Replicate Directory Changes Permission Must.

5 : My site Plan 

6: NetBios Name - for My site and FIM Server where install on Same as CA or Apps .

7 : check for FIM Status (The FIM Client is located at C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe)

8: http://www.harbar.net/articles/sp2010ups.aspx   : Please following This Harbar.net step by step.

9: For Error Event ID 1001 1004 1015  :- http://support.microsoft.com/kb/2473430

------------------------Network Service account read access---------------------------------------------------
Grant the Network Service account read access to the %programfiles%\Microsoft Office Servers\14.0 folder

The Network Service account does not have rights to the %programfiles%\Microsoft Office Servers\14.0 folder.
RESOLUTION
Grant the Network Service account read access to the %programfiles%\Microsoft Office Servers\14.0 folder.
---------------------------------------------use  link--------------------------------------------------------------------
http://www.harbar.net/archive/2010/10/30/avoiding-the-default-schema-issue-when-creating-the-user-profile.aspx
http://technet.microsoft.com/en-us/library/hh296982(v=office.14).aspx
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=300
http://blogs.technet.com/b/wbaer/archive/2009/12/11/common-microsoft-sharepoint-server-2010-installation-issues-and-resolutions.aspx
http://blogs.technet.com/b/steve_chen/archive/2010/09/20/user-profile-sync-sharepoint-2010.aspx
---------------------------------------------------------------------------------------------------------------
 SharePoint profile synch stopped-database-connection-lost

Disabled "MySite Cleanup job"

Please check one small OU Add and Run Test All The Process get success. 

then Edit Connection Add next OU and then run incremental , one by one add all the OU

 Enable "MySite Cleanup job"
http://blogs.msdn.com/b/russmax/archive/2010/03/20/sharepoint-2010-provisioning-user-profile-synchronization.aspx
http://blogs.msdn.com/b/russmax/archive/2010/03/20/sharepoint-2010-provisioning-user-profile-synchronization.aspx

http://technet.microsoft.com/en-us/library/gg750257(v=office.14).aspx
http://sharepointgeorge.com/2010/configuring-the-user-profile-service-in-sharepoint-2010/
http://blogs.msdn.com/b/spses/archive/2010/12/02/guide-to-user-profile-service-application-upa-part-2-setting-up-the-user-profile-service-application.aspx
http://blogs.msdn.com/b/spses/archive/2010/11/28/guide-to-user-profile-service-application.aspx
---------------------------------------------------------------------------------------------------------------
Event Id 6801
http://support.microsoft.com/kb/2520394?wa=wsignin1.0
http://support.microsoft.com/kb/2520394
------------------For NetBios----------
http://iedaddy.com/2012/01/wrong-domain-name-in-accountname-after-user-profile-sync/

To check the status of that setting, use the PowerShell below, substituting the GUID of your UPS for mine:

(Get-SPServiceApplication 1ceb9eca-78b0-47c2-ab2b-b041e0d3902a).NetBIOSDomainNamesEnabled
You'll get back either True or False.
http://tremblayse.wordpress.com/2011/10/17/ups-and-netbios-domain-name-different-then-fqdn-domain-name/

--For --configuring-the-user-profile-service-in-sharepoint-2010-------------------------

http://www.c-sharpcorner.com/uploadfile/anavijai/how-to-schedule-user-profile-incremental-synchronization-in-sharepoint-2010-using-power-shell/
http://www.harbar.net/articles/sp2010ups.aspx

http://www.windowsclever.com/sharepoint/how-to-setup-user-profile-service-sharepoint-2010.html
http://sharepointgeorge.com/2010/configuring-the-user-profile-service-in-sharepoint-2010/
http://technet.microsoft.com/en-us/library/ee721049(v=office.14).aspx#NetBIOSProc
http://social.msdn.microsoft.com/Forums/sharepoint/en-US/398f3553-5de7-456b-b935-4e22cee26b2f/sharepoint-2010-communities-faq


Also  Consider The Plan For UPS , and My site first of the steps. IISREST, Server Reboot and data lost in My site will consider if when Upgrade... Thanks.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2013 1:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics