locked
OriginalCode Attribute Bug RRS feed

  • Question

  • Hi

    I think I found a bug in SQL MDS 2014.

    To recreate:

    Create a dummy model. Create a dummy entity. Add an attribute to the entity and name it OriginalCode. Attach a business rule to the OriginalCode. (I used an Is Required action). Try validate your model. ...It seems to be in an infinite loop.

    I ran the mdm.udpValidateModel stored procedure and got the following message repeating:

    Msg 2705, Level 16, State 3, Procedure udp_SYSTEM_1008_1110_CHILDATTRIBUTES_ProcessRules, Line 91

    Column names in each table must be unique. Column name 'OriginalCode' in table '#BRMemberData' is specified more than once.

    Workaround:

    I changed it's name to InitialCode and all good.

    Hope this helps anyone else with a similar problem...

    Thursday, June 26, 2014 5:41 AM

Answers