BeyondERP.Newsletter
Menu

Setup page · System administration

Database log parameters

A setup page that holds the database logging options, which currently show one setting, Track all values for array fields.

Used by
Information technology manager
Business process
Administer system features
Menu item
DatabaseLogParameters
Main table
DatabaseLogParameters
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page that holds the database logging options, which currently show one setting, Track all values for array fields.
What you do hereUse this page to choose whether database logging tracks all values for array fields.
ExampleFor example, before BEAT turns on logging for a table whose fields hold several values each (array fields), the administrator decides here whether the database log should track all values of those fields.
Database log parameters page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Setup › Database log › Database log parameters
Set up firstDatabase log setup Microsoft Learn
Used next byDatabase Log Microsoft Learn
Related pagesDatabase log cleanup Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Database log parameters1 screen
  1. Screen 1

    Review the database log parameters

    Go to System administration > Setup > Database log > Database log parameters

    1. Review the database logging options
    2. Select Edit if needed and choose whether to track all values for array fields
    3. Select Save
    Review the database log parameters (zoomed on the outlined fields)
    Show the full screenReview the database log parameters
    page title tab to open what to set or check

How to use it

  1. Go to System administration > Setup > Database log > Database log parameters.
  2. On the General tab, set Track all values for array fields to Yes or No.
  3. Select Save.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExample
Track all values for array fieldsSets whether database logging tracks all values for array fields (field DatabaseLogArrayFields).Microsoft data model No

Common errors and fixes

MessageWhat to do
The database log grows quickly and long processes slow downLog specific fields instead of whole tables, plan how long logs are kept, and schedule Clean up log per company. Microsoft Learn

Test checklist

  1. In Database log setup, use the wizard to log updates on one sensitive field (for example the vendor bank account number).
  2. Change that field on a vendor.
  3. Open System administration > Inquiries > Database > Database log and check the change is listed with user and time.
  4. Schedule Clean up log per company and check old entries are removed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Database log parametersDecide Track all values for array fields before you set up logging, and log specific fields rather than whole tablesLearn recommends limiting log entries by logging specific fields; the database log is meant for individual changes to sensitive data, and every extra value logged makes the log table larger.Should all values of array fields be tracked?Treating the database log as a general audit trail: it is designed for individual changes, not for automated transactions run in batch jobs.Test: Database logging records a change

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneHard to reverse: Logging setup can be changed at any time, but log records removed by the cleanup are deleted for good, and changes made while a table was not logged can't be recovered later. Microsoft Learn
If you change it laterThe setting is shared and applies to all database logging in the environment. Logging itself turns set-based operations into row-based ones and makes the log table grow, so keep the logged tables and fields few. Microsoft Learn
Technical architect

6Technical

Menu itemDatabaseLogParameters Checked in Dynamics 365
FormDatabaseLogParameters Checked in Dynamics 365
TableDatabaseLogParametersChecked in Dynamics 365
Who can open itPrivileges DatabaseLogParametersMaintainDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=DatabaseLogParameters
Data migrationLoad order: Database log parameters has no data entity in Data management, so it can't be loaded from a file or a configuration template. Set the option by hand in each environment.Checked in Dynamics 365
Table definitionDatabaseLogParameters columns and relations Microsoft data model
Everyone

8Sources