Bij het openen van een Exact Online database van een klant krijg ik de foutmelding:
itgengpr087: A connection to the database ‘Klant.… B.V.’ could not be established as user ‘’.
The database ‘Klant - … B.V.’ could not be opened.
The encrypted contents of the disk cache file are missing.
Message ID: d67fab46-b007-4a71-ad74-1e92e52c0e64
Occurred (UTC): 7/20/2021 6:44:46 AM
InvantiveSystemException
ValidationException
at Invantive.Basics.ValidationException…ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String messageText, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Boolean isRecoverable, String poolIdentityId) at Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable
1 uid, Boolean isRecoverable, String poolIdentityId)
at Invantive.Data.GenericProvider.TryGetHttpFromDiskCache(GlobalState owner, ExecutionOptions executionOptions, CacheSettings cacheSettings, String cacheId, Nullable`1 maxAgeSec, Boolean expectEncryption, String expectedUrl, String dataContainerId, Boolean expectPreamble, HttpResponseCacheObject& httpResponseCacheObject)
at Invantive.Data.Providers.Http.HttpBasedProvider.GetInternal(GlobalState owner, ExecutionOptions executionOptions, String relativeUrl, String mimeType, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, CacheSettings cacheSettings, String callSafeNameOverrule, Boolean allowRetry, Boolean preventRetryOnAuthenticationFailure, ParameterList parameters, String dataContainerIdOverrule, Boolean throwExceptionOnNonSuccessfulStatusCode, ExecutionStatistics& statistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
Hoe los ik dit op? Het lijkt op deze storing: Itgengpr087 fout bij herladen Exact Online dataset in Power BI Cloud, maar daar staat geen oplossing bij.
Het volgende statement wil ik daarna kunnen uitvoeren:
local on error continue
set use-http-disk-cache false;
set use-http-memory-cache false;
set use-result-memory-cache false;
use 123456
alter persistent cache table ExactOnlineREST.Incremental.ItemsIncremental force refresh approach copy