QRS API: Delete management cache

ToniKautto · Dec 21, 2020 1:43:17 AM

Qlik Sense Repository Service (QRS) entire cache can be purged by calling the below QRS API end-point. This will force the QRS to re-evaluate all the results and might be noticed on performance and response times while the cache is rebuilt. It is recommended to only use this when advised by Qlik Support as part of troubleshooting.

DELETE /qrs/internal/management/cache/

The rules cache is local to a Qlik Sense node. To reset the QRS rule cache on all nodes, the API must be called on each node.

The API call must be run as the user Internal\sa_repository. Qlik Sense client certificates must be used for authentication when calling QRS API as Internal\sa_repository
Call QRS API locally on Qlik Sense node or Export client certificate and root certificate to make API calls to a client machine.

Example on how to reset QRS security cache with PowerShell;

$qlikserver = 'qlikserver1.domain.local'

$cert = Get-ChildItem -Path "Cert:\CurrentUser\My" | Where {$_.Subject -like '*QlikClient*'}
$xrfkey = "iX83QmNlvu8x9yAB"

$url = "https://$($qlikserver):4242/qrs/internal/management/cache?xrfkey=$($xrfkey)"
$headers = @{}
$headers.Add("X-Qlik-xrfkey","$xrfkey")
$headers.Add("X-Qlik-User","UserDirectory=INTERNAL;UserId=sa_repository")

Invoke-RestMethod -Uri $url -Method Delete -ContentType 'application/json' -Headers $headers -Certificate $cert

Confirm in Audit_Repository logs that cache has been clear on a specific Qlik Sense node. Looks for a message referring to "Invalidating" followed by the type of cache being removed, like one of the below examples;

Invalidating User cache
Invalidating SecurityFilterResult cache
Invalidating ExtensionSchema cache
Invalidating SystemRule cache
Invalidating CustomPropertyDefinition cache

References

Qlik Sense for developers: Qlik QRS API reference

Environment

Qlik Sense Enterprise on Windows June 2017 and later

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

QRS API: Delete management cache