PROFILE SYNC TROUBLESHOOTING STEPS
Issue Event id 5553
"failure trying to synch site"
We may notice that the Profile Sync is not working on a specific Site Collection. There is a way to disable synching of a specific Site Collection. Running stsadm -o preparetomove -sitewould set a flag in the
SSP database to not sync this Site Collection. When that is run (for whatever
reason), the Site is prepared to be moved and certain features are stopped from
taking place, Profile Syncs being one of them. When Moving is set to 1 for a
Site Collection, the Profile Sync will not occur.
We can run an SQL query to find out what Site Collection are set to not sync:
use SSPdatabase
select * from sitesynch (nolock) where moving=1
You will see list with contentDB id's,
Running stsadm -o preparetomove -site-undo will undo
that flag, allowing that site collection to sync with the next Profile Sync job.
This command will set Moving=0 for that Site Collection.
Make a note of these contentDB id's,
Some times difficult to find the individual site collections, so run the below SQL Query against config database.
Example Query:
Select * from dbo.objects (nolock) where id in ( 'id of ContentDB in the event viwer', 'id of synch site in event log ')
This gives you the Database names,
Then Ran the below commands:
stsadm -o preparetomove -undo -contentdb sqlcdb01: Name of the db from above cmd
There is also a way to force all Profiles to be imported, regardless or whether they are marked as Active in a Site Collection.
To set sync to ignore the isActive and sync all:
stsadm -o sync -ignoreisactive 1
stsadm -o sync -deleteolddatabases 0
After running the above commands, Wait for the next profile Sync or If you can't wait, then run the below command.
stsadm -o sync -synctiming m:1
Once you are sure that the profiles are sync, change the sync timing back to hour.
stsadm -o sync -synctiming h:1
Wait for 10 to 15 minutes, then your are done. :)
Issue Event id 5553
"failure trying to synch site"
We may notice that the Profile Sync is not working on a specific Site Collection. There is a way to disable synching of a specific Site Collection. Running stsadm -o preparetomove -site
We can run an SQL query to find out what Site Collection are set to not sync:
use SSPdatabase
select * from sitesynch (nolock) where moving=1
You will see list with contentDB id's,
Running stsadm -o preparetomove -site
Make a note of these contentDB id's,
Some times difficult to find the individual site collections, so run the below SQL Query against config database.
Example Query:
Select * from dbo.objects (nolock) where id in ( 'id of ContentDB in the event viwer', 'id of synch site in event log ')
This gives you the Database names,
Then Ran the below commands:
stsadm -o preparetomove -undo -contentdb sqlcdb01: Name of the db from above cmd
There is also a way to force all Profiles to be imported, regardless or whether they are marked as Active in a Site Collection.
To set sync to ignore the isActive and sync all:
stsadm -o sync -ignoreisactive 1
stsadm -o sync -deleteolddatabases 0
After running the above commands, Wait for the next profile Sync or If you can't wait, then run the below command.
stsadm -o sync -synctiming m:1
Once you are sure that the profiles are sync, change the sync timing back to hour.
stsadm -o sync -synctiming h:1
Wait for 10 to 15 minutes, then your are done. :)
No comments:
Post a Comment