Business rule bug for attribute with NVARCHAR(5) could not set to Blank

Business rule bug for attribute with NVARCHAR(5) could not set to Blank by MSIT Justin Li

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	775855
Opened:	1/5/2013 12:04:02 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When I create a business rule to set an attribute (Say it's 'CFlag') to Blank, if the attribute 'CFlag' type is NVARCHAR(5), it will give error message '245: Conversion failed when converting the nvarchar value '~NULL' to data type int.' while Apply Rules.
While check the background code in the system generated Stored Procedure [mdm].[udp_SYSTEM_5_153_CHILDATTRIBUTES_ProcessRules], it will set the 'CFlag' = '~NULL~', but attribute 'CFlag' only has 5 chars, so it will cut the string to '~NULL'.

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Master Data Services

Windows Server 2012 Datacenter

English

1. Create a new business rule;
2. Set 'CFlag' equals to Blank;
3. Publish the business rule;
4. Apply rules;

Give error message '245: Conversion failed when converting the nvarchar value '~NULL' to data type int.'

Apply rules success.

X64

0 attachments

Posted by Microsoft on 1/10/2013 at 9:11 AM

No, this is really just an unintended consequence of a design choice. The same issue may be encountered when using staging to set values to null when the attribute width is less than 6. I submitted a Community Comment to this doc page: http://msdn.microsoft.com/en-us/library/ff487047.aspx

Posted by MSIT Justin Li on 1/10/2013 at 12:13 AM

Hello, Lynn:
Just want to confirm, is there any online document or product document mentioned the minimum width should be 6 for MDS attribute?
Thanks a lot.
Justin.

Posted by Microsoft on 1/9/2013 at 4:33 PM

Hi Justin,
Thank you for reporting this issue. It's always great to hear from customers, even if it's about a problem they are having. In this case, as you observe, your attribute is not wide enough to hold the intermediate value. The minimum width is 6. We are closing this issue but marking it for consideration in a future release.
Regards,
Lynn