MDM Change tracking not working

[Former Member]

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

[michael_theis]

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

[Former Member]

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

[Former Member]

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

[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.