User profile information is not updated correctly after you import a user profile from Active Directory to SharePoint Portal Server 2003 (873326)


The information in this article applies to:

  • Microsoft Office SharePoint Portal Server 2003

SYMPTOMS

When you import user profile information from a server that is running the Active Directory directory service to Microsoft Office SharePoint Portal Server 2003, you may find that in certain situations, the user profile information in SharePoint Portal Server 2003 is not updated correctly with the information from Active Directory. You experience these symptoms if you delete the value of a user property in Active Directory. After you import the user profile information of that user to SharePoint Portal Server 2003, the value of that user property still exists for that user profile.

CAUSE

This problem occurs if the following conditions are true, in the order that they are presented:
  1. You import a user profile from Active Directory to SharePoint Portal Server 2003.
  2. In Active Directory, you delete the value of a user property in the user profile.
  3. You re-import the user profile from Active Directory to SharePoint Portal Server 2003.
In this situation, SharePoint Portal Server 2003 does not update the Null value of the user property correctly during the import operation.

RESOLUTION

This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest SharePoint Portal Server 2003 service pack, you do not have to install the hotfix.

Service pack information

This problem is corrected in Microsoft Office SharePoint Portal Server 2003 Service Pack 2.

To resolve this problem, obtain the latest service pack for SharePoint Portal Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

889380 How to obtain the latest service pack for SharePoint Portal Server 2003

Hotfix information

How to obtain the hotfix

This issue is fixed in the SharePoint Portal Server 2003 post-Service Pack 1 Hotfix Package that is dated September 17, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

883919 Description of the Office SharePoint Portal Server 2003 post-Service Pack 1 hotfix package: September 17, 2004

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SharePoint Portal Server 2003 Service Pack 2.

MORE INFORMATION

Installation instructions

There are two parts to the installation of this hotfix.
  • SharePoint Portal Server 2003 Update
  • Microsoft SQL Server Stored Procedure Update

SharePoint Portal Server 2003 Update

This part of the hotfix prevents the problems discussed in this article from occurring in any new portal sites created in SharePoint Portal Server 2003. To update SharePoint Portal Server 2003, follow these steps:
  1. Run the self-extracting package, and extract the files to the folder that you specify.
  2. Double-click the SPS2003-KB873326-Server-GBL.EXE file to start the installation.
  3. If you are prompted to insert your original Microsoft SharePoint Portal Server 2003 CD disc, insert it, and then click OK.
  4. Follow the steps on the screen to install the update.

Microsoft SQL Server Stored Procedure Update

This part of the hotfix will make sure that your SharePoint Portal Server 2003 has all of the fixes contained in this patch applied to each existing portal site. You must run these steps on each existing portal site. To do this, follow these steps:
  1. Run the self-extracting package, and extract the files to the folder that you specify.
  2. For the SQL query file 12575.SQL that is extracted to the temporary folder that you indicated in step 1, follow the following instructions:
    If you are using Microsoft SQL Server as the back end for SharePoint Portal Server,
    1. Start SQL Query Analyzer and connect to the instance of SQL Server specified in your configuration.
    2. In the database drop-down box, select the <portal_name>1_PROF database where <portal_name> is the name of the existing portal.
    3. On the File menu, click Open and navigate to the 12575.SQL file (located in the temporary folder specified in step 1), and then click Open.
    4. On the Query menu, click Execute.
    5. When the query is finished executing, on the File menu, click Exit.
    If you are using Microsoft MSDE as the back end for SharePoint Portal Server,
    1. Click Start, and then click Run.
    2. In the Open box, type cmd, and then click OK.
    3. At the command prompt, type osql -S <machineName>\SHAREPOINTPORTAL -d <portal_name>1_PROF -n -E -i <temporary_folder_path>\12575.SQL where <machineName> is the computer name and <temporary_folder_path> is the temporary folder specified in step 1.
    4. When the query is finished executing, at the command prompt, type exit, and then press ENTER.
Modification Type:MajorLast Reviewed:7/27/2006
Keywords:kbSharePtPortalSvr2003SP2fix kbQFE KBHotfixServer kbSharePtPortalSvr2003preSP2fix kbImport kbfix kbBug KB873326 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.