Itgeobr342 A connection to the database ... could not be established

Vragen
,
1

De update van Data Hub + Query Tool naar 24.0.393 en het toevoegen van het bestand zonder verdere werking lost het opstartprobleem van Data Hub op.

Echter resulteert de vernieuwing van de Exact-data via Data Hub nu in volgende foutmelding:

2024-11-12 12:29:16.145 Error itgencun016: Error itgenobr342: A connection to the database invantiveforum\data-replicator could not be established.

Unexpected form action length of 44 characters.

met call stack:

2024-11-12 12:29:18.161 Error itgenobr342: InvantiveSystemException
ValidationException
   at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Nullable`1 isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
   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, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.GetOAuthAccessTokenForEOL(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, String providerName, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.Invantive.Data.IOAuthProvider.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.ExecuteGetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.GetOAuthTokenForConnection(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, ISupportsOAuth provider, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.OpenDataContainerProviderInternal(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IConnectionDataProvider provider, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.OpenDataContainerProvider(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, ConcurrentBag`1 triedProviders, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.e.A(DataContainer, ParallelLoopState pls, Int64)
   at Invantive.Basics.ParallelUtility.<>c__DisplayClass3_0`1.<ForEachWithAggregatedExceptions>b__0(TSource tSource, ParallelLoopState parallelLoopState, Int64 index)
   at System.Threading.Tasks.Parallel.<>c__DisplayClass43_0`2.<PartitionerForEachWorker>b__1(IEnumerator& partitionState, Int64 timeout, Boolean& replicationDelegateYieldedBeforeCompletion)
   at System.Threading.Tasks.TaskReplicator.Replica.Execute()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
   at System.Threading.Tasks.ThreadPoolTaskScheduler.TryExecuteTaskInline(Task task, Boolean taskWasPreviouslyQueued)
   at System.Threading.Tasks.TaskScheduler.TryRunInline(Task task, Boolean taskWasPreviouslyQueued)
   at System.Threading.Tasks.Task.InternalRunSynchronously(TaskScheduler scheduler, Boolean waitForCompletion)
   at System.Threading.Tasks.TaskReplicator.Run[TState](ReplicatableUserAction`1 action, ParallelOptions options, Boolean stopOnFirstFailure)
   at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body)
   at Invantive.Basics.ParallelUtility.ForEachWithAggregatedExceptions[TSource](GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body, Boolean shuffle, Boolean useCancellationTokenFromExecutionOptions, Boolean keepGoingOnError)
   at Invantive.Data.ConnectionManager.B(GlobalState, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, CredentialsContainer, Boolean, Boolean& )
   at Invantive.Data.ConnectionManager.a(GlobalState owner, ExecutionOptions, SqlExecutionStep, CredentialsContainer, Boolean, Boolean& )
   at Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Producer.UtilityBaseCore.OpenDatabase(GlobalState owner, ExecutionOptions executionOptions, String databaseFullName, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Producer.UtilityBaseCore.CheckConnection(GlobalState owner, ExecutionOptions executionOptions, Boolean forceReconnect, Boolean silent, String databaseName, CredentialsContainer credentialsContainer)
   at Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String[] arguments)
   at Invantive.Producer.Data.Hub.Program.Main(String[] args)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.GetOAuthAccessTokenForEOL(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, String providerName, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.Invantive.Data.IOAuthProvider.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.ExecuteGetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.GetOAuthTokenForConnection(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, ISupportsOAuth provider, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.OpenDataContainerProviderInternal(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IConnectionDataProvider provider, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.OpenDataContainerProvider(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, ConcurrentBag`1 triedProviders, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.e.A(DataContainer, ParallelLoopState pls, Int64)
   at Invantive.Basics.ParallelUtility.<>c__DisplayClass3_0`1.<ForEachWithAggregatedExceptions>b__0(TSource tSource, ParallelLoopState parallelLoopState, Int64 index)
--- End of stack trace from previous location ---
   at Invantive.Basics.ErrorConstants.ThrowOneOrMoreExceptions(GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 exceptions)
   at Invantive.Basics.ParallelUtility.ForEachWithAggregatedExceptions[TSource](GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body, Boolean shuffle, Boolean useCancellationTokenFromExecutionOptions, Boolean keepGoingOnError)
   at Invantive.Data.ConnectionManager.B(GlobalState, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, CredentialsContainer, Boolean, Boolean& )
   at Invantive.Data.ConnectionManager.a(GlobalState owner, ExecutionOptions, SqlExecutionStep, CredentialsContainer, Boolean, Boolean& )
   at Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Producer.UtilityBaseCore.OpenDatabase(GlobalState owner, ExecutionOptions executionOptions, String databaseFullName, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
2024-11-12 12:29:18.221 Error itgencun016: Error itgendhb005: Could not connect to database 'invantiveforum\data-replicator'. Application will be closed.
2024-11-12 12:29:18.224 Error itgendhb005: ValidationException
   at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Nullable`1 isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
   at Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String[] arguments)
   at Invantive.Producer.Data.Hub.Program.Main(String[] args)
   at Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String[] arguments) in c:\smoke\ws-24.0\Invantive.Data.Hub\src\Invantive.Producer.Data.Hub\QueryEngine.cs:line 579
2024-11-12 12:29:18.240 Error itgenube182: itgendhb005: Could not connect to database 'invantiveforum\data-replicator'. Application will be closed.

For support go to https://forums.invantive.com.

2024-11-12 12:29:18.241 Information itgendhb219: End program execution with exit code 5.
2024-11-12 12:29:18.242 Information itgendhb068: Program finished on 12/11/2024 12:29:18.
2

In de volgende versie van Invantive Query Tool en Invantive Data Hub zal een verbetering doorgevoerd zijn die de initiele Code Grant Flow mogelijk maakt bij het gebruik van One Exact Identity tegen specifiek Exact Online Belgie.

Dit zal naar verwachting dit probleem oplossen.

Zodra de release beschikbaar is zullen de hyperlinks als antwoord toegevoegd worden.

3

Hebben jullie een richtlijn beschikbaar qua timing voor de nieuwe release?

4

De algemene richtlijn is Releasefrequentie Invantive Cloud.

Op dit moment zal het uitleveren aan de langste kant zitten vanwege gevolgen van de storing van 1 november jongstleden (itgendir105).

5

Enige update beschikbaar qua timing?

6

Er wordt nog intensief gewerkt aan een oplossing.

Als workaround is advies om de synchronisatie via het Invantive Query Tool te draaien.

Zodra meer informatie beschikbaar is wordt dit topic bijgewerkt.

1 like
7

Merk op dat de foutmelding per Exact Online-land anders kan zijn.

8

De problemen bij het gebruik van One Exact Identity, Exact Online en Invantive Data Hub worden centraal opgevolgd via de pagina Data Hub issues on Exact Online authentication.

U kunt zich aldaar abonneren op updates.

9

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.