What to do if rebuilding the cache of a datasource takes very long?
FIRST CREATED ON 20 Feb 2024 I AUTHOR Emma Camacho
If
the App is very big and/or has many sheets and objects, it is highly
recomended to use the Set Filter Before Rebuilding Cache option together
with a Filter Field Name and Filter Value to reduce the time when
rebuilding the cache.
Issue
Rebuilding the cache takes very long.
Resolution
Use
the Set Filter Before Rebuilding Cache option together with a Filter
Field Name and Filter Value to reduce the time when rebuilding the
cache.
What is the Cache?
It is a dictonary of all the fields, variables and id of objects in the App. It is only metadata.
What does it mean Rebuild the Cache?
It is the process of creating this dictonary of metadata.
When is it necessary to Rebuild the Cache?
When new objects, fields or variables were added to the App and M&D needs these new elements in a report and/or task.
Why Rebuilding the Cache can take very long?
M&D will request Qlik Sense to open the App and it will visit every sheet gathering all the object id's present in the sheet. Qlik
Sense will load the App into memory and it will do all the necessary
calculations to render all the charts and tables present in the sheet,
and for every sheet. If it is a very big app with many sheets and
objects, the process can take long.
How to minimize the time to Rebuild the Cache?
Use
the option Set Filter Before Rebuilding Cache together with a Filter
Field Name and Filter Value to set a filter that will load as few rows
as possible, making the process of creating the dictionary/rebuilding
the cache much faster.
When setting the option Set Filter Before Rebuilding Cache, is the dataset reduced when distributing Reports?
No, the dataset is only reduced when rebuilding the cache/creating the dictionary. It is not reduced when distributing reports.
How to Rebuild the Cache?
Press the sync icon on the list of Datasources.
Looking for Additional Guidance?If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.
Related Articles
What steps can I take if the Execution Calendar takes too long to load in Mail & Deploy?
FIRST CREATED ON 6 Jun 2023 I AUTHOR Emma Camacho If the Execution Calendar in Mail & Deploy is taking too long to load, it can impact your scheduling and workflow. Here’s a brief guide to help you address and resolve this issue: Use the command line ...What to do if the M&D Extensions for Qlik Sense take very long to generate a Report or exporting an object ?
FIRST CREATED ON 17 Mar 2025 I AUTHOR Emma Camacho If the Report Requester and/or Visualization Exporter are taking very long to generate a Report or to Export an object, use the Usage Condition property to be sure that the necessary fields are ...How to solve the errors Unable to connect to the remote server and The remote server returned an error: (400) Bad Request ?
FIRST CREATED ON 17 Feb 2025 I AUTHOR Emma Camacho If getting the follow error every other time when rebuilding the cache of a Datasource or when running a task or in general, when using a Datasource, please review the version of Qlik Sense and ...What to do if getting the error The remote server returned an error: (403) Forbidden?
FIRST CREATED ON 19 Feb 2024 I AUTHOR Emma Camacho When rebuilding the cache of a Datasource, generating a Report or running a task the following error will appear if M&D doesn't have permission to access the Qlik Sense App. Issue Der Remoteserver ...What to do if getting the error TimeoutException: Se excedió el tiempo de espera de la operación?
FIRST CREATED ON 19 Feb 2024 I AUTHOR Emma Camacho When running a task that connects to a Qlik Sense Datasource that is very big and complex that even when accessing it within the Qlik Sense Hub takes a lot of time to load, the following error might ...