In Data modeling studio, for monitoring purposes, executed actions are logged.

The main activities for which logging is done are:

  • Deploy: All actions that are executed when you deploy a data model are logged. Each time you deploy a data model, an execution ID is created to which all executed deploy actions are related
  • Data export: All actions that are executed when you export data are logged.
  • Metadata updates: Metadata updates are only logged if on the Data modeling studio parameters, Log metadata updates is 'Yes'.

Note: On deploy or data export, executed SQL statements are only logged if on the Data modeling studio parameters Log executed SQL statements is 'Yes'.

Logging is done on three levels:

  • Summary: Each deploy or data export results in a record in the summary. Each record is identified by the context (data model) and the execution ID.
  • Log: The actions that are executed by the deploy, data export, or metadata update.
  • Processing: The export statistics for each exported business entity (data set or data entity) as defined for the deployed or exported data model.


Standard procedure

1. Go to Data modeling studio > Data modeling studio > Data exchange monitoring.
2. You can choose to show the data exchange history:
- By execution ID. To do so, set the Show all log and processing records field to 'No' and in the Summary section select the desired record.
- For all logged entries. To do so, set the Show all log and processing records field to 'Yes'. Use this option, for example, to view metadata update logging.
  Select Yes in the Show all log and processing records field.
 

Note: Metadata updates are logged without an execution ID. So, you cannot find and select metadata updates in the Summary section. When Show all log and processing records is set to 'Yes', in the Log section, you can find metadata update logs with the 'Metadata caching' context.

3. Sub-task: View history by execution ID.
  3.1 If you want to monitor the data exchange history by execution ID, in the Summary section, select the desired execution record. As a result, in the:
- Log section, you can view the actions that are executed for the selected execution record.
- Processing section, you can view, per business entity, the export statistics.
  In the Summary section, find and select the desired record.

Notes

Field descriptions of the Data exchange monitoring page.

Summary

Field Description
Context In the Summary section, this is the data model name.
Execution Each deploy or data export results in a record in the summary, which is identified by a unique execution ID.
Status The status of the execution. For example, 'Failed' if a Deploy went wrong, 'Succeeded' if a data export went well, or 'Started' if currently a data export is running.
Last updated by The user who started the deploy or data export.
Origin The origin always is 'D365FOE'.
Started The date/time on which the deploy or data export is started.
Ended The date/time on which the deploy or data export is ended.

Log

Field Description
Origin

The origin can be:

  • D365FOE: For all deploy and data export actions.
  • Diagnostics: For metadata updates.
Subject

A short description of the logged action.

Note: On the Data modeling studio parameters, for diagnostics reasons, you can indicate if executed SQL statements must be logged as well. If so, the subject is 'Diagnostics'.

Message A more detailed description of the logged action.
Type Indication of the result of the logged action. If 'Info', the action is executed successfully. Otherwise, possibly, some action is required.
Last updated by The user who started the deploy, data export, or metadata update.
Execution The unique identification of the related deploy, data export, or metadata update.
Last updated The date/time on which the action is logged.
Context

If the logged action is related to:

  • Deploy or data export, the related data model name is shown.
  • Metadata update, the context is 'Metadata caching'.

Processing

Field Description
Object The business entity (data set or data entity) which data is exported.
Group The group 'tag' as defined for the data set.
Origin The origin always is 'D365FOE'.
Action The action always is 'Export'.
Mode

The mode depends on the data selection as defined for the related data set. If the data selection is:

  • 'All data', the mode is 'Full'
  • 'Change tracking', the mode is 'Incremental'.
  • Timestamp, the mode is 'Timestamp'.
Source The number of records in the source table in D365 FO.
Delta

The number of records that are exported by this export action. The number of exported records depends on the:

  • Data selection as defined for data sets.
  • Change tracking setting of the data entity tables.
Started The date/time on which the export is started.
Ended The date/time on which the export is ended.
Result The result of the export action.
Execution The unique identification of the deploy or data export activity to which the export action is related.
Context The name of the data model for which the export action is executed.
Throughput The number of records exported per second.
Duration The number of seconds the export took.
Destination The number of records in the related table on the target database.

Related to Notes

Monitor data exchange

 

Provide feedback