My Sharepoint Learnings

The user profile properties values are stored in SSP tables in MOSS 2007. The values can be found in UserProfileValue table in SSP The values are stored for each of the Record ID. Each RecordID corresponds to one user. Also in the table, the values are given for each PropertyID The mapping of PropertyID and its corresponding description can be found in the table PropertyList. Note - it is not advisable to manipulate the SSP DB's.

The above error occurred when trying to set alerts for users in one of site in MOSS 2007. The outgoing email is configured and there were no errors during that time. [Note - the SMTP server was configured months after MOSS was installed and site was up and running in the server] Go to SSP and in User Profile and Properties and select View Import Connections. If no connections are present, create a connection with the ad. Then do a full import. This would solve the issue. The error could still be coming because, the emails are sent based on the email address stored in the UserInfo table and it has not been synced with the email address in the user profile properties in the SSP. Would have to run the stsadm commands to sync the both. Command - stsadm -o sync -synctiming m:3 http://technet.microsoft.com/en-us/library/cc263196(v=office.12 ) If the issue still persists, delete the users from Sharepoint users and groups in the site, and add them again and run the sync job. This wou...