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


The information in this article 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.
Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kberrmsg kbnofix kbBug KB829838 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.