locked
Update the UserInfo table of the content database RRS feed

  • Question

  • Hi,

    Recently a user has her name changed, as a result, the login name changed as well. So I used the migrateuser command to migrate her user profile, however, in the userinfo table of the content database, the tp_title  and tp_Email remain the same, they are still populated with her old information. Is there a way to change these 2 fields without modifying the DB directly?

    Please advice. Thanks in advance.

    Wednesday, January 5, 2011 3:31 PM

Answers

  • Hi You can try

    stsadm -o sync command to sync user profiles in user info table in content DB

    If you believe that information is not synced between the user profiles and the user information lists in one or more sites you can request a list of content databases that have not been synchronized for x number of days by using the following stsadm sync command.

    stsadm -o sync -listolddatabases <x number of days>

    If one or more content databases show up in this list you can clean up the sync list so they can be added to the list again.

    stsadm -o sync -deleteolddatabases <x number of days>

    For manula update you can refer

    http://blogs.msdn.com/b/varun_malhotra/archive/2008/07/26/how-to-update-tp-title-field-of-the-userinfo-table-of-the-sharepoint-s-content-database-from-the-om-code.aspx

    Hope this will be helpful


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Seven M Thursday, January 13, 2011 8:50 AM
    Wednesday, January 5, 2011 3:58 PM

All replies

  • Hi You can try

    stsadm -o sync command to sync user profiles in user info table in content DB

    If you believe that information is not synced between the user profiles and the user information lists in one or more sites you can request a list of content databases that have not been synchronized for x number of days by using the following stsadm sync command.

    stsadm -o sync -listolddatabases <x number of days>

    If one or more content databases show up in this list you can clean up the sync list so they can be added to the list again.

    stsadm -o sync -deleteolddatabases <x number of days>

    For manula update you can refer

    http://blogs.msdn.com/b/varun_malhotra/archive/2008/07/26/how-to-update-tp-title-field-of-the-userinfo-table-of-the-sharepoint-s-content-database-from-the-om-code.aspx

    Hope this will be helpful


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Seven M Thursday, January 13, 2011 8:50 AM
    Wednesday, January 5, 2011 3:58 PM
  • I tried this but I could not get the synchronization working.

    I used a (little bit dirty) workaround.

     
    delete 
    FROM [WSS_Content].[dbo].[UserInfo]
    This empties the Sharepoint cache table. The next time a user logs in, the AD is queried to get the latest full display name.
    • Proposed as answer by FranzGreeff Monday, August 4, 2014 3:06 PM
    Friday, February 24, 2012 2:44 PM
  • Didn't even think along this route - thanks for your help, saved me.
    Monday, August 4, 2014 3:07 PM
  • hello,

    don't you lose the permissions that have been set for this user in the site when you delete them or does it just sync it back in and keep all permissions and settings

    I have the same issue and tried all supported scenarios already
    since I have this for all users, really deleting and recreating users is no option since I would need to reset all permissions for every user

    Wednesday, June 20, 2018 9:20 AM