Itgeneuy103 with DataHub 22.0.660 failing to log into Exact Online

[sda]

We have upgraded yesterday Data Hub from 22.0.578 to 22.0.660. It shows an error itgeneuy103 with ExactOnline:

Impossible de se connecter à Exact Online avec le nom d'utilisateur et le mot de passe. La raison est inconnue.
2023-06-13 05:38:56.287 Error itgeneuy103: Invantive.Basics.InvantiveSqlException

Could it be possible that it is the same issue a with itgenoam010-with-querytool-22-0-647-failing-to-log-into-exact-online.

Below the full error message:

2023-06-13 05:38:54.271 Error itgencun016: Erreur itgeneuy103: Une connexion à la base de données GROUP\DB+RABO+EOL+SQL(ExactNL_Replication) n'a pas pu être établie.

Impossible de se connecter à Exact Online avec le nom d'utilisateur et le mot de passe. La raison est inconnue.
2023-06-13 05:38:56.287 Error itgeneuy103: Invantive.Basics.InvantiveSqlException
ValidationException
   à 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, Boolean isRecoverable, String poolIdentityId, String url)
   à Invantive.Basics.InvantiveSqlException..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)
   à Invantive.Data.OAuth.OAuthBackgroundProvider.GetOAuthAccessTokenForEOL(GlobalState owner, ExecutionOptions executionOptions, String providerName, OAuthInformation oauthInfo, Credentials credentials)
   à Invantive.Data.OAuth.OAuthBackgroundProvider.Invantive.Data.IOAuthProvider.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   à Invantive.Data.ConnectionManager.XZ(GlobalState , ExecutionOptions , SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   à Invantive.Data.ConnectionManager.EZ(GlobalState , ExecutionOptions , SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   à Invantive.Data.ConnectionManager.GetOAuthTokenForConnection(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, ISupportsOAuth provider, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Data.ConnectionManager.BZ(GlobalState , ExecutionOptions , IConnectionDataProvider , SerializableDatabase , DataContainer , Credentials , Boolean , Boolean& )
   à Invantive.Data.ConnectionManager.OpenDataContainerProvider(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, List`1 triedProviders, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Data.ConnectionManager.SZ(GlobalState , ExecutionOptions , CredentialsContainer , Boolean , Boolean& )
   à Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Producer.UtilityBaseCore.OpenDatabase(GlobalState owner, ExecutionOptions executionOptions, String databaseFullName, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Producer.UtilityBaseCore.CheckConnection(GlobalState owner, ExecutionOptions executionOptions, Boolean forceReconnect, Boolean silent, String databaseName, CredentialsContainer credentialsContainer)
   à IDH.B.V(String[] )
   à Invantive.Producer.QueryEngine.Program.Main(String[] arguments)
   à Invantive.Data.OAuth.OAuthBackgroundProvider.GetOAuthAccessTokenForEOL(GlobalState owner, ExecutionOptions executionOptions, String providerName, OAuthInformation oauthInfo, Credentials credentials)
   à Invantive.Data.OAuth.OAuthBackgroundProvider.Invantive.Data.IOAuthProvider.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   à Invantive.Data.ConnectionManager.XZ(GlobalState , ExecutionOptions , SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   à Invantive.Data.ConnectionManager.EZ(GlobalState , ExecutionOptions , SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   à Invantive.Data.ConnectionManager.GetOAuthTokenForConnection(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, ISupportsOAuth provider, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Data.ConnectionManager.BZ(GlobalState , ExecutionOptions , IConnectionDataProvider , SerializableDatabase , DataContainer , Credentials , Boolean , Boolean& )
   à Invantive.Data.ConnectionManager.OpenDataContainerProvider(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, List`1 triedProviders, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Data.ConnectionManager.SZ(GlobalState , ExecutionOptions , CredentialsContainer , Boolean , Boolean& )
   à Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   à Invantive.Producer.UtilityBaseCore.OpenDatabase(GlobalState owner, ExecutionOptions executionOptions, String databaseFullName, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
2023-06-13 05:38:56.318 Error itgencun016: Erreur itgendhb005: Impossible de se connecter à la base de données 'GROUP\DB+RABO+EOL+SQL(ExactNL_Replication)'. L'application sera fermée.
2023-06-13 05:38:56.318 Error itgendhb005: ValidationException
   à 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, Boolean isRecoverable, String poolIdentityId, String url)
   à IDH.B.V(String[] )
   à Invantive.Producer.QueryEngine.Program.Main(String[] arguments)
   à IDH.B.V(String[] )
2023-06-13 05:38:56.344 Error itgenube182: itgendhb005: Impossible de se connecter à la base de données 'GROUP\DB+RABO+EOL+SQL(ExactNL_Replication)'. L'application sera fermée.

Pour obtenir de l'aide, rendez-vous sur https://forums.invantive.com.

2023-06-13 05:38:56.344 Information itgendhb219: Terminer l'exécution du programme avec le code de sortie 5.
2023-06-13 05:38:56.344 Information itgendhb068: Programme terminé sur 13/06/2023 05:38:56.
2023-06-13 05:38:56.344 Information itgendhb036: *** HARD-WIRED MANIFEST ***

[forums]

In release 22.0.663 relevant fixes will be available for users not using One Exact Identity with Invantive Data Hub. This release is scheduled for general availability on June 14, 2023 through https://releasenotes.invantive.com.

In general it is recommended to include the client secret in the connection string to reduce number of re-authentications executed. This can be done by adding ;client-secret=... to the connection string.

[sda]

We confirm the fix works.

[forums]

It is currently expected that the so-called “.net framework variant” of Invantive Data Hub will become incompatible with Exact Online cq. with the “One Exact Identity” component.

Alternatively, we recommend switching to the latest 22.0-release of the multi-platform variant of Invantive Data Hub with .net core v6.0.

The upgrade steps and limitations are described at:

Switching from Windows to multi-platform variant of Data Hub

Go to Dutch version Two variants There are two different variants in use called “Invantive Data Hub”: Invantive Data Hub: for use only with the .net Framework v4.8 on Microsoft Windows. Invantive Data Hub Multi-platform: for use on Windows, Linux and MacOS with .net core v6.0. The Windows variant of Invantive Data Hub is most commonly used for historical reasons. This article describes the differences and how to make a switch to the multi-platform variant. Both variants of Invantive Data H…

This variant can be used on Windows, macOS and Linux, each with its own download, and is available in releases 22.0 and 22.1-BETA.

Efforts are currently underway to make Windows-specific drivers such as AccountView available within the Windows version of the multi-platform variant. The Windows-specific drivers - if proven feasible - will only be available with the 22.1-BETA versions.

Data Hub users who are not using Exact Online and/or One Exact Identity we recommend continuing to use the current .net framework variant for now. New releases of this will continue to come in the same frequency as other Invantive products until at least the end of 2024 and probably longer.

More background information can be found at Invantive Data Hub, Currency Tools, Get My Report and One Exact Identity on Exact Online.