Data maintenance – Dynamics 365 Finance and Operations

Data maintenance enables simple scheduling processes that you can run to find or correct data inconsistencies in your environment.

Incorrect data can adversely affect your day-to-day, monthly, and yearly operations. Inconsistencies and errors that come from incorrect data has the potential to halt major events like year-end activities and can even halt your daily revenue streams and affect your organization’s decision-making capabilities.

The Data Maintenance Portal is a tool that lets system administrators schedule and run various actions that will have a direct effect on the data or the system. Some actions can be scheduled to continuously look for opportunities to fix issues, and others can be run on demand to enact some change on the system. Currently there are three basic types of actions: direct, scanning, and fixing.

Some or all of the functionality noted in this topic is available as part of a preview release starting on 10.0.18/PU42

To access the Data Maintenance Portal, administrators can go to System administration > Periodic tasks > Data maintenance.

The recurrence of data maintenance processes are handled by the process automation framework as background processes, for this reason is strongly necessary that you validate that you environment have the “Process automation polling system job” running.

You can initialize this one on System administration > Setup > Initialize background process

Exist three type of actions that you can do:

  • Direct actions can be run on-demand only, and can run tasks directly. Microsoft Support may use direct actions, which could be as simple as clearing a cache without the need for downtime or as complicated as running a reference scanner to aid the support process.
  • Scanning actions will search your data, a few times a day, looking for problems in the data. The problems found will be reported to Microsoft. There are a number of system actions that may not yet have an automated fix, but will provide valuable data to Microsoft to improve the health of your data. Microsoft may reach out to you regarding problems found through this method.
  • Fixing actions runs on the same cadence as a scanning action, but when an opportunity is found, it will schedule a fix to the data. Fixing actions are meant to be data idempotent and may not fix all of the data on the first run. We recommend that a fixing action only fixes a subset of data each time it runs. Over time, the data will reach a clean state without exposing a significant load on the system. This type of action may help facilitate an in-place upgrade of your system.

If the action can be scheduled, there will be a button labeled Schedule available at the bottom of the page. All actions can be run on demand, prior to being run by the automated schedule, by selecting the Run now button. System actions, defined by Microsoft, cannot be disabled or enabled.

You can found the official documentation here!