{"id":69,"date":"2009-06-16T20:45:36","date_gmt":"2009-06-16T18:45:36","guid":{"rendered":"http:\/\/jsiegmund.wordpress.com\/?p=69"},"modified":"2013-04-18T18:51:09","modified_gmt":"2013-04-18T17:51:09","slug":"sharepoint-profiles-not-synchronizing","status":"publish","type":"post","link":"http:\/\/blog.repsaj.nl\/index.php\/2009\/06\/sharepoint-profiles-not-synchronizing\/","title":{"rendered":"SharePoint profiles not synchronizing"},"content":{"rendered":"<p>A while ago, a colleague asked me why her contact details weren&#8217;t updated on SharePoint. She got married and thus her name changed. The AD was updated but the changed weren&#8217;t pushed to SharePoint for some reason.<\/p>\n<p><!--more-->After some searching, I found out her MySite profile was updated correctly (you can check those profiles via SSP admin), but the information showed on our normal SharePoint portal wasn&#8217;t correct. So somewhere in between there was somekind of synchronisation error.<\/p>\n<p>I started googling and found some sites stating that the stsadm command &#8216;sync&#8217; (stsadm -o sync) should do the trick forcing to synchronize the profiles between sites. Unfortunately, nothing happend. Searching some more I found out that you should check the old sync databases and delete them if found (stsadm -o sync -listolddatabases). But again: nothing.<\/p>\n<p>Then I found out there is a flag &#8216;Moving&#8217; in the SSP database,\u00a0check the\u00a0SiteSynch table. That flag is set by the command &#8216;preparetomove&#8217; (also an stsadm command) which apparantly shouldn&#8217;t be used after installing SP1 (do some searching for more info). I don&#8217;t know wether I did or did not use that command, but I do know all the Moving flags were set to &#8216;True&#8217; in my SSP database.<\/p>\n<p>Allright, so now what? The command &#8216;stsadm -o preparetomove -undo -contentdb dbname&#8217; should reset the flag. I tried executing the command, but the flags wouldn&#8217;t go. Hmmm&#8230; then I created a little .bat file to execute the same command for every content database (if it doesn&#8217;t help, it doesn&#8217;t hurt&#8230; right?). Whoah! The entire SiteSynch database emptied in front of my eyes. Having no idea whether this was a good or a bad thing; I searched some more&#8230; A couple of forum posts (MSDN) stated that you should start a search crawl after a full profile import. So I first started the profile import and then the search crawl and voila: there were the SiteSynch records again!<\/p>\n<p>Being confident, I checked the profiles and there were all the changed being nicely synced! I don&#8217;t know whether this is going to last, if it doesn&#8217;t I&#8217;ll update the post with more info. But untill now, it seems to work properly again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A while ago, a colleague asked me why her contact details weren&#8217;t updated on SharePoint. She got married and thus her name changed. The AD was updated but the changed weren&#8217;t pushed to SharePoint for some reason.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[34],"tags":[7,23,24],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3KFR1-17","_links":{"self":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/69"}],"collection":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":0,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}