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.
  • 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'.


DMS Administrator DMS Administrator Start Start View data exchange history View data exchange history 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. 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. 4. 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. Troubleshoot  data export? Troubleshoot  data export? Troubleshoot data export

Troubleshoot data export

Data modeling studio has several options to troubleshoot data exports.

Clean up  data exchange  history? Clean up  data exchange  history? Refresh data exchange history Refresh data exchange history The deploy and export history is logged. Over time, the number of logged records grows. To limit the number of logged records in the database, you can refresh the history. If you refresh the history, the retention settings of these Data modeling studio parameters are applied: Log record retention (days): On refresh, only the log records are kept that are within the number of defined retention days. Processing record retention (days): On refresh, only the processing records are kept that are within the number of defined retention days. Example: Number of retention days is 7. Today you Refresh. As a result, all logged records are deleted that are older than a week. Procedure 1. Go to Data modeling studio > Data modeling studio > Data exchange monitoring. 2. Click Refresh. End End Yes No Yes No

Activities

Name Responsible Description

View data exchange history

DMS Administrator

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.

Troubleshoot data export

DMS Administrator

Data modeling studio has several options to troubleshoot data exports.

Refresh data exchange history

DMS Administrator

The deploy and export history is logged. Over time, the number of logged records grows. To limit the number of logged records in the database, you can refresh the history. If you refresh the history, the retention settings of these Data modeling studio parameters are applied:

  • Log record retention (days): On refresh, only the log records are kept that are within the number of defined retention days.
  • Processing record retention (days): On refresh, only the processing records are kept that are within the number of defined retention days.

Example: Number of retention days is 7. Today you Refresh. As a result, all logged records are deleted that are older than a week.

Provide feedback