Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 829838 - Last Review: October 27, 2006 - Revision: 1.2
Cannot Create Direct Membership Rule on a Site Server That Has User Group Names That Contain More Than 50 DBCS Characters
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.
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.
This behavior is by design.
APPLIES TO
- Microsoft Systems Management Server 2003
| kberrmsg kbnofix kbbug KB829838 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate