Skip to Content
author's profile photo Former Member
Former Member

MDM Change tracking not working

We are on MDM 5.5 SP4.

We turned on the change tracking in MDM console for the main table. we turned on only the modify and delete tracking. However, it is not capturing the changes in the A2I_CM_HISTORY table under any of the <repo name>_Z00x user names. There are 4 user names Z001 thro 4 and none of them have recorded the change data.

Have any of you experienced such a problem and any suggestions?

Thanks,

Deepak

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 01:51 AM

    Hi,

    Change tracking can be defined via the MDM Console (see the link http://help.sap.com/saphelp_mdm550/helpdata/en/42/e965b4f7f23ee5e10000000a1553f7/frameset.htm).

    Changes are written to a separate database on the same DB server which hosts the MDM repository.

    At present, the MDM API's do not provide functionality for retrieving change tracking information, but MDM provides a Web-based application for viewing change-tracking records, which can be used in standalone mode, or configured for use with the other MDM iViews, or even used as a Web pane in the MDM Data Manager.

    Click this http://help.sap.com/saphelp_mdm550/helpdata/en/45/c7b20339ee570ae10000000a114a6b/frameset.htm

    to view the configuration and usage guide for the MDM Change Tracker

    Regards

    Hari

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Please understand my question. I am not asking help on how to enable change tracking. I have described a very specific problem in change tracking and checking if anyone have come across such a problem.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 01:57 AM

    Hi

    Deepak Just check this once

    The Change Tracking table is an MDM system table with a predefined set of fields, and records that are not directly visible in either the MDM Console or the MDM Client.

    Each record is created automatically by MDM when the value of any field that you are tracking is changed, providing an audit log of changes within the system.

    The Create Stamp, Time Stamp, and User Stamp field types provide a

    basic “change tracking” capability. All three field types are read-only and

    are automatically updated by MDM as follows:

    • Create Stamp. Set with the date and time when a record is first

    created.

    • Time Stamp. Set with the date and time each time any of the fields

    being tracked are updated.

    • User Stamp. Set with the name of the user who makes the change

    when any of the fields being tracked are updated.

    when user select the data type as create stamp,time stamp it asks the user for the fields for which the user wants to track the records.

    Note : the fields with data type as only for change tracking and are not syndicatable

    Also u cannot map these fields in the import manager.

    regards

    Hari

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2007 at 07:11 AM

    Hi Deepak,

    you should check this on your database. Changes are written into specific databases! Usually you should see and additional database with <repo name>_Z00X on your database server. This datadase contains the changes. A2i_CM_HISTORY is only an overview about active change trackings, the real change data is stored in additional databases as described above.

    BR Michael

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.