Microsoft KB Archive/916594

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

Article ID: 916594

Article Last Modified on 11/15/2007

-

APPLIES TO


 * Microsoft Connected Services Framework Server 2.5

-





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.



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

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

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

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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



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.</li> 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

</li></ol>

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

Additional query words: ServiceContext UserToServiceMapping

Keywords: kbqfe kbpubtypekc kbhotfixserver KB916594

-

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

© Microsoft Corporation. All rights reserved.