Microsoft KB Archive/873326

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

Article ID: 873326

Article Last Modified on 7/27/2006

-

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

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 &quot;Applies to&quot; section. This problem was first corrected in SharePoint Portal Server 2003 Service Pack 2.



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:  Run the self-extracting package, and extract the files to the folder that you specify. 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,  Start SQL Query Analyzer and connect to the instance of SQL Server specified in your configuration. In the database drop-down box, select the 1_PROF database where   is the name of the existing portal. 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.</li> On the Query menu, click Execute.</li> When the query is finished executing, on the File menu, click Exit.</li></ol>

If you are using Microsoft MSDE as the back end for SharePoint Portal Server, <ol style="list-style-type: lower-alpha;"> Click Start, and then click Run.</li> In the Open box, type cmd, and then click OK.</li> At the command prompt, type osql -S \SHAREPOINTPORTAL -d <portal_name>1_PROF -n -E -i  \12575.SQL where   is the computer name and   is the temporary folder specified in step 1.</li> When the query is finished executing, at the command prompt, type exit, and then press ENTER.</li></ol> </li></ol>

Additional query words: sps

Keywords: kbshareptportalsvr2003sp2fix kbqfe kbhotfixserver kbshareptportalsvr2003presp2fix kbimport kbfix kbbug KB873326

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.