locked
A bug in populating mdm.tblTransaction by MDS? RRS feed

  • General discussion

  • Hi,  I discover a bug (I think) on the process that populates the mdm.tblTransaction table.  If you have a date attribute in your leaf member, change the value, and check the values in columns OldValueand NewValue, you would notice that the date format used to store the date as strings are different.

    For example,  I have athe following values being stored (as strings) in a record in the table mdm.tblTransaction, after I changed the date attribute value from 27/02/2013 to 27/2/2014   :

    Old Value: '2013-02-27 00:00:00.000'  

    New Value:  '02/27/2014 00:00:00'

    Is this a set up /configuration issue, or is this a bug?

    Monday, April 2, 2012 12:53 AM

All replies

  • Hi,  I discover a bug (I think) on the process that populates the mdm.tblTransaction table.  If you have a date attribute in your leaf member, change the value, and check the values in columns OldValueand NewValue, you would notice that the date format used to store the date as strings are different.

    For example,  I have athe following values being stored (as strings) in a record in the table mdm.tblTransaction, after I changed the date attribute value from 27/02/2013 to 27/2/2014   :

    Old Value: '2013-02-27 00:00:00.000'  

    New Value:  '02/27/2014 00:00:00'

    Is this a set up /configuration issue, or is this a bug?

    • Merged by Challen Fu Tuesday, April 3, 2012 7:38 AM duplicated thread
    Monday, April 2, 2012 12:47 AM