locked
Upgrading MDS 2008 R2 to MDS 2012: Business Rule Conditions disappearing? RRS feed

  • General discussion

  • Hello Everyone,

    I'm upgrading to MDS 2012 from MDS 2008 R2 and have run into an issue while upgrading in our development environment that I'm hoping someone else has seen.

    If I have any conditions on business rules that refer to specific vales (e.g. Attribute is equal to Y, Attribute is not equal to USA) they are missing after upgrading from 2008 R2 to 2012.

    Example:

    ActualsYN is a DBA attribute.

    2008 R2 Businessrule_RuleConditionSql: ((IsNull(md.[ActualsYN],N'') = N'Y'))

    2012 BusinessRule_RuleConditionSql: ((( (md.[ActualsYN] IS NULL AND N'' IS NULL) OR md.[ActualsYN] = N'' )))

    I can go in and manually correct these if I have to, but I have over a hundred rules that have this issue (across many different entities) and I'm hoping someone has either seen this before or that there's a good way to fix this.

    In the worst case, I think I should be able to correct all the rules in development and then use the new package deployment process to push the updated rules up to the other environments as they're ugpraded?

    Thanks,

    Isaac

    Wednesday, February 19, 2014 8:06 PM