Microsoft KB Archive/829838

= Cannot Create Direct Membership Rule on a Site Server That Has User Group Names That Contain More Than 50 DBCS Characters =

Article ID: 829838

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-





SYMPTOMS
When you try to create a direct membership rule on a Microsoft Systems Management Server (SMS) 2003 site server, and the site server has user group names that contain 50 or more Double Byte Character Set (DBCS) characters, the membership rule fails, and the Smsprov.log file logs the following error message:

Unable to update parent collection due to SQL error. SQL Error: [22001][8152][Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.



CAUSE
This issue occurs because Microsoft Systems Management Server (SMS) 2003 has a character limit of 50 DBCS (100 bytes) on direct membership rules. As a result, the SMS 2003 provider cannot insert the rule in the SMS 2003 site database, and therefore the SMS 2003 provider interprets the error as a Microsoft SQL Server error.



STATUS
This behavior is by design.

Keywords: kberrmsg kbnofix kbbug KB829838

-

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

© Microsoft Corporation. All rights reserved.