asked on
SharePoint and Active Directory Sync Issues
In our environment we have a SharePoint server (SharePoint 2007) that synchronizes with the Active Directory (Windows Server 2003) nightly. Unfortunately, while attempting to set up alerts for one user (and strangely this sole user), we ran into a bit of a problem by way of email addresses. This user’s email is correct in the Active Directory, but incorrect in SharePoint. Stranger still is that it is only incorrect in the alerts section; in all other information listings it is correct.
We have tried updating the Active Directory profile with the correct email several times, manually editing SharePoint (which has yielded no results and has proven ridiculously difficult), and forcing SharePoint to manually synchronize with the Active Directory, all to no avail.
Both of these servers are completely updated and neither alone have problems. Any ideas (short of deleting this user’s profile completely and recreating it) as to why this is happening and how to fix it?
We have tried updating the Active Directory profile with the correct email several times, manually editing SharePoint (which has yielded no results and has proven ridiculously difficult), and forcing SharePoint to manually synchronize with the Active Directory, all to no avail.
Both of these servers are completely updated and neither alone have problems. Any ideas (short of deleting this user’s profile completely and recreating it) as to why this is happening and how to fix it?
Windows Server 2003Microsoft SharePointActive Directory
Last Comment
CUBSIT01
ASKER
Unfortunately, this is one of the first things tried and it doesn't solve the issue. In the AD it's correct, which means in the field is being randomly populated by some piece of incorrect data, but we can;t for the life of us determine where this is being kept.
Is there any email address set in the code?
Check the the users exchange settings in exchange does he have more than one email address?
The incorrect email address where do you think it has come from, a Migration for example.
Check the the users exchange settings in exchange does he have more than one email address?
The incorrect email address where do you think it has come from, a Migration for example.
ASKER
Let me be more clear: When this user's account was originally synchronized to the SharePoint Server from the AD, the incorrect email was listed in the user profile. It has since been corrected, and updated multiple times, however, this one field refuses to update.
On our domain we do not have an exchange server, so this isn't the problem.
On our domain we do not have an exchange server, so this isn't the problem.
Ok does sharepoint use SQL or a DB?
The updated manually in there?
The updated manually in there?
ASKER
I'm sorry, I don't quite understand your question, but it is a local instance of SQL, not a central server.
you should be able to use SQL Studio to open the database tables then edit the email within the database for this .
Is sharepoint service packs fully up to date ?
Have a look at this..
http://sharepointinsight.wordpress.com/2009/05/25/
Is sharepoint service packs fully up to date ?
Have a look at this..
http://sharepointinsight.wordpress.com/2009/05/25/
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Just for your information. Have you tried SharePoint AD Sync?
ASKER
Unfortunately, none of the suggestions have worked...even diving into the SQL and finding the correct tables and updating them did nothing. It seems that there is a part of SharePoint that simply refuses to update.
The way we get to this seemingly unupdatable table is as follows. From the user's "My Site," (where the email is correctly displayed) there is a tab labeled "View Tech Support User Info". This tab brings you to a page that is simply called "User information: [user's name] - [network\user name]". This is the only place in the entire Portal I can find that holds this faulty field, and for the life of me I cannot figure out how to change this. The few other fields that are populated on this page are correctly done so.
The way we get to this seemingly unupdatable table is as follows. From the user's "My Site," (where the email is correctly displayed) there is a tab labeled "View Tech Support User Info". This tab brings you to a page that is simply called "User information: [user's name] - [network\user name]". This is the only place in the entire Portal I can find that holds this faulty field, and for the life of me I cannot figure out how to change this. The few other fields that are populated on this page are correctly done so.
whats the URL of the page that holds the dodgy address ?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yes, but that doesn't give access to all the fields...only if the user is currently in or out. And if you remove the force=1 from the URL it simply redirects you to the user's "My Site"...weird stuff.
you dont get email ? if you go into site settings on the peaople.aspx page where you navigated from does the field you want to change appear in there ?
ASKER
Nope. That's why this is so perplexing. From what I can tell that field is nearly uneditable...which makes no sense...
Somehow it's linked to an incorrect part of the AD that doesn't exist...or just refuses to update or let anyone edit this one field.
Somehow it's linked to an incorrect part of the AD that doesn't exist...or just refuses to update or let anyone edit this one field.
ok bear with me, this is MOSS not WSS3.0 isn't it. I aint got access to a MOSS server here at home,
My thoughts are that the list is configured to not display the field in anything other than view mode. If thats the case then it may be possible to make the change using a package called SharePoint Manager 2007.
This wicked little tool allows access to all sorts of properties. If you download it you can access every object in your site collection as well as their properties.
Just taking alook on my text server WSS3, i can drill down through into my site collection -> rootsite --> users to my admin user (only one in there) and into the properties whare i can change the email.
Give it a go and let me know how you get on, i will take a look tomorrow on my moss server when i get to work.
My thoughts are that the list is configured to not display the field in anything other than view mode. If thats the case then it may be possible to make the change using a package called SharePoint Manager 2007.
This wicked little tool allows access to all sorts of properties. If you download it you can access every object in your site collection as well as their properties.
Just taking alook on my text server WSS3, i can drill down through into my site collection -> rootsite --> users to my admin user (only one in there) and into the properties whare i can change the email.
Give it a go and let me know how you get on, i will take a look tomorrow on my moss server when i get to work.
also, although i would not advocate messing with the backend database, have you checked out the userInfo table for the content database on that site, and for the admin content database in case its pulling fromt here for some reason.
sorry if i am going over old ground but did you try stsadm -o sync yet ? I managed to replicate your issue and it worked on mine
ASKER
Sorry about the delay in response time; things have been rather hectic here over the last week. I still have no had a chance to try your last suggestion, though editing the backend didn't work either. I'll let you know when I've tried the sync...read: in the next few days or so.
Yeh i trawled the back end on our server and couldn't sort it. took me about 3 hours to go through them all :)
ASKER
It's definitely not an easy task.
So now we have a bit of a dilemma...after patches were applied and the machine rebooted (probably should have been doing that after all attempts, eh?), the user is now receiving alerts. Unfortunately, we have no way of knowing which person helped us...due to the fact that all results seemed unsuccessful shortly after implementation.
So now the question is: how do we award points to those who helped? Split it evenly...or? Any ideas?
So now we have a bit of a dilemma...after patches were applied and the machine rebooted (probably should have been doing that after all attempts, eh?), the user is now receiving alerts. Unfortunately, we have no way of knowing which person helped us...due to the fact that all results seemed unsuccessful shortly after implementation.
So now the question is: how do we award points to those who helped? Split it evenly...or? Any ideas?
Split em :) Fairest way if you're not sure
ASKER
Alrighty. Awarded. Thank you for all the help.
Shared Services Administration: SharedServices > User Profile and Properties . maybe a simple refresh would work here, i haven't really had much to do with this part of sharepoint, but this is where i would start.
I think you can also configure which profile fields are mapped to what in here etc...