BeyondERP.Newsletter
Menu

Page · System administration

Data set cache

An inquiry page that lists the data sets held in the data cache, with the time each was last updated, its filter values and its value.

Used by
Information technology manager
Business process
Administer system features
Menu item
SysDataSetCache
Main table
SysDataCacheContextTable
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 isAn inquiry page that lists the data sets held in the data cache, with the time each was last updated, its filter values and its value.
What you do hereUse this page to see when each data set in the data cache was last updated and the filter values it was cached with.
ExampleFor example, a workspace list built on a slow query is cached as a data set, and when users say the list misses a record created a few minutes ago, Last update here shows that the cache hasn't refreshed yet.
Data set cache 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 › Inquiries › Data cache › Data set cache
Set up firstData set cache configuration Microsoft Learn
Used next byData cache parameters Microsoft Learn
Related pagesSystem administration workspace 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.

Setup steps on this page

Check how fresh the list cache is

Use this page to see when each cached list was last refreshed and which value it holds.

Steps from Microsoft

  1. Go to System administration > Inquiries > Data cache > Data set cache.
  2. Use the Filter box to find the list you are checking.
  3. Read Last update to see when the cached value was refreshed, and Filter values to see which filter it was cached for.
  4. Compare Value with what the workspace shows; to change how often entries refresh, open Data set cache configuration.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Last updateWhen the cached entry was last refreshed.Checked in Dynamics 365Today at 09:40
Filter valuesThe filter values the entry was cached for, such as a workspace filter.Checked in Dynamics 365
ValueThe cached result that the workspace shows.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
A workspace shows an out-of-date listThe value comes from the cache and is refreshed only at the cache's refresh frequency. Check Last update here, and shorten the refresh frequency on Data set cache configuration only where the query is fast enough. Microsoft Learn

Test checklist

  1. Open a workspace that uses the cache and note the value it shows.
  2. Open Data set cache and find the matching entry.
  3. Check that Value matches the workspace and that Last update is within the refresh frequency.
  4. Change the underlying data, wait for the refresh frequency to pass, and check that Last update and Value change.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check how fresh the list cache isCheck Last update and Filter values of the list's data set before you report a workspace list as wrongWorkspace data comes from a cache that is refreshed at a set frequency, so a value can be older than the source data by up to that interval.How fresh must the list data be?Expecting a cached list to show a record the moment it is saved. Cached lists refresh at the data set's frequency unless the code forces a refresh.Test: The cached value refreshes within the refresh frequency

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. Administrators use it to check how fresh workspace data is. 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 undoneReversible: The inquiry changes no data. Microsoft Learn
If you change it laterReading the cache changes nothing. How often entries are refreshed is set by the cache's refresh frequency, which administrators can change at run time on the cache configuration pages. Microsoft Learn
Technical architect

6Technical

Menu itemSysDataSetCache Checked in Dynamics 365
FormSysDataCache Checked in Dynamics 365
TableSysDataCacheContextTableShown as “Cache context” in Record infoChecked in Dynamics 365
Who can open itPrivilegesData cache inquiry SysDataCacheInquiryDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo use 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, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SysDataSetCache
Data migrationLoad order: Data set cache has no data entity in Data management, so it can't be loaded from a file or a configuration template. The cache is rebuilt by the system from the source data in each environment, so there is nothing to move.Checked in Dynamics 365
Table definitionSysDataCacheContextTable columns and relations Microsoft data model
Everyone

8Sources