none
MDS 2016 - tbltransaction table is missing RRS feed

  • Question

  • Hi.

    We have recently upgraded from MDS 2012 to MDS 2016, and notice that tbltransaction table is missing. However I do find that there is table tbl_**_**_TR for each entity that should hold the transaction data for that entity, but I do not see this table for any existing entity in the model. Also I tried creating new entity with Transaction Log Type as Attribute/Member but did not create this table at SQL server.

    I have reports built on tbltransaction to fetch the changes at entity level in a specified period , which fails in MDS 2016. Can anyone suggest any alternative for tbltransaction ? or any other way to set these reports ?

    Thanks

    Monday, October 22, 2018 11:20 AM

All replies

  • tbl_**_**_TR  - wrong way.

    Use

    tbl_MM_TR  or viw_SYSTEM_MM_TRANSACTIONS - (MM=Model ID) for Attribute logging type

    tbl_MM_EE_EN_HS or viw_SYSTEM_MM_EE_CHILDATTRIBUTES_HISTORY  (MM=Model ID, EE -  Entity ID) for Member  logging type

    Wednesday, December 19, 2018 5:52 AM
  • If you have old database backup the restore with old db and copy table data with structure.

    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Wednesday, March 20, 2019 3:00 AM
    Answerer