Microsoft KB Archive/194557

= Custom Import Fails if P&M is Using SQL Server with 850 Char Set =

Article ID: 194557

Article Last Modified on 3/4/2002

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q194557



SYMPTOMS
If the Site Server 3.0 Personalization and Membership database is running on SQL Server with the character set configured for "850 Multilingual," the Custom Import analysis tool will fail to import user data. During step 2 of the user import, Custom Import issues the following error message.

The import process was stopped because an error occurred while importing the users. The database indexes for the Membership Directory are currently inaccessible. The database is currently undergoing maintenance or the indexes are missing. Please wait and try again or contact your Membership Server administrator.



CAUSE
The problem is caused by Dsexport.asp on the Membership server, generating a directory search filter that is invalid if Personalization and Membership uses a "850 Multilingual" SQL Server database.



RESOLUTION
To resolve this problem, apply the latest Site Server 3.0 service pack.



WORKAROUND
To work around this problem, you can modify the line in the GetFilter function in Dspexport.asp on the Personalization and Membership server that Custom Import runs against.

Original line: If g_oDNCheck.ValidDN(iSsync) = False Then Modified line: If g_oDNCheck.ValidDN(iSsync) = False Or iSsync = 8217 Then



STATUS
Microsoft has confirmed this to be a problem in Site Server version 3.0.



MORE INFORMATION
The documentation is contradictory; it will be corrected in the future.

This is currently documented in the following places:


 * Site Server 3.0 Documentation:
 * Getting Results with Microsoft Site Server
 * Installing Site Server 3.0
 * Setting Up Your Platform
 * Installing SQL Server SP4
 * To install Microsoft SQL Server
 * Step 2: Click Sets, verify that ISO Character Set (Default) is selected, and then click OK.

The Site Server documentation also states that when you are creating a Membership directory using a SQL Server database you should remember:   The recommended code page is Multilingual 850. The recommended sort order for code page 850 is Dictionary Order, Case-insensitive.

Additional query words: character set

Keywords: kbbug kbfix kbsiteserv300sp1fix KB194557

-

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

© Microsoft Corporation. All rights reserved.