FIX: A Connected Services Framework Server 2.5-based application truncates the ServiceContext parameter value to 255 Unicode characters (916594)

SYMPTOMS

In a Microsoft Connected Services Framework (CSF) Server 2.5-based application, the ServiceContext parameter for user to service mapping in Profile Manager is stored in the ServiceContext column of the UserServiceMapping table. When you try to store a ServiceContext parameter value that is larger than 255 Unicode characters of the nvarchar data type, the application truncates the ServiceContext parameter value to 255 Unicode characters.

CAUSE

This problem occurs because the application can only retrieve 255 Unicode characters from the ServiceContext column. The ServiceContext column is defined as the nvarchar(255) data type. For example, the nvarchar(255) data type can only store strings up to 255 Unicode characters or 512 bytes.

RESOLUTION

Hotfix information

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

File name	File size	Date	Time
Qfe28_fix.sql	13,305	10-Mar-2006	03:04

MORE INFORMATION

This hotfix increases the size of the ServiceContext column of the UserServiceMapping table in the CSFDB database. After you apply this hotfix, the ServiceContext column is defined as the nvarchar(1024) data type. The complete fix is confined to changing the table schema and the corresponding stored procedures. No change is required in any other part of the application.

To apply this hotfix, follow these steps:

Start SQL Query Analyzer on the instance of Microsoft SQL Server that is hosting the CSFDB database. To do this, click Start, click Programs, click Microsoft SQL Server, and then click Query Analyzer.
On the Query menu, click Change Database.
In the Select Database dialog box, click CSFDB, and then click OK.
On the File menu, click Open, locate the Qfe28_fix.sql script, and then click Open.
On the Query menu, click Execute.
To restart Microsoft Internet Information Services on the server that hosts the Profile Manager Web service, run the following command at a command prompt:
IISReset

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates