Itgenobr292 The TOTP secret must be available to calculate the verification code when TOTP is enabled on the Exact Online account

[mds]

Bij een klant de onderstaande melding terug uit de log. Hoe kan ik dit oplossen

itgenobr292
The TOTP secret must be available to calculate the verification code when TOTP is enabled on the Exact Online account ‘naam@email.com’.

Logging:

2023-10-16 14:00:35.720 Error itgenobr292: ValidationException
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, Boolean isRecoverable, String poolIdentityId, String url)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.GetOAuthAccessTokenForEOL(GlobalState owner, ExecutionOptions executionOptions, String providerName, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.Invantive.Data.IOAuthProvider.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.A(GlobalState , ExecutionOptions executionOptions, SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   at Invantive.Data.ConnectionManager.a(GlobalState , ExecutionOptions executionOptions, SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   at Invantive.Data.ConnectionManager.GetOAuthTokenForConnection(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, ISupportsOAuth provider, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.A(GlobalState , ExecutionOptions executionOptions, IConnectionDataProvider , SerializableDatabase , DataContainer , Credentials credentials, Boolean , Boolean& )
   at Invantive.Data.ConnectionManager.OpenDataContainerProvider(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, List`1 triedProviders, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.A(GlobalState , ExecutionOptions executionOptions, 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(String[] arguments)
   at Invantive.Producer.Data.Hub.Program.Main(String[] args)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.GetOAuthAccessTokenForEOL(GlobalState owner, ExecutionOptions executionOptions, String providerName, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.OAuth.OAuthBackgroundProvider.Invantive.Data.IOAuthProvider.GetOAuthToken(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, OAuthInformation oauthInfo, Credentials credentials)
   at Invantive.Data.ConnectionManager.A(GlobalState , ExecutionOptions executionOptions, SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   at Invantive.Data.ConnectionManager.a(GlobalState , ExecutionOptions executionOptions, SerializableDatabase , DataContainer , OAuthInformation , Credentials )
   at Invantive.Data.ConnectionManager.GetOAuthTokenForConnection(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, ISupportsOAuth provider, Credentials credentials, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.A(GlobalState , ExecutionOptions executionOptions, IConnectionDataProvider , SerializableDatabase , DataContainer , Credentials credentials, Boolean , Boolean& )
   at Invantive.Data.ConnectionManager.OpenDataContainerProvider(GlobalState owner, ExecutionOptions executionOptions, SerializableDatabase database, DataContainer dataContainer, Credentials credentials, List`1 triedProviders, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
   at Invantive.Data.ConnectionManager.A(GlobalState , ExecutionOptions executionOptions, 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)
2023-10-16 14:00:35.778 Error itgencun016: Error itgendhb005: Could not connect to database 'Voorbeeld\Database'. Application will be closed.
2023-10-16 14:00:35.780 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, Boolean isRecoverable, String poolIdentityId, String url)
   at Invantive.Producer.Data.Hub.QueryEngine.Run(String[] arguments)
   at Invantive.Producer.Data.Hub.Program.Main(String[] args)
   at Invantive.Producer.Data.Hub.QueryEngine.Run(String[] arguments) in c:\smoke\ws-22.0\Invantive.Data.Hub\src\Invantive.Producer.Data.Hub\QueryEngine.cs:line 630
2023-10-16 14:00:35.790 Error itgenube182: itgendhb005: Could not connect to database 'Voorbeeld\Database'. Application will be closed.

[forums]

Gelieve een waarde voor totp-secret toe te voegen in de connection string (meestal in het settings*.xml-bestand) zoals beschreven in:

Circumvent two-step verification and refresh tokens on Exact Online using Data Hub

This note presents a number of easy steps to circumvent the use of an OAuth2 refresh token using the Code Grant Flow on the console apps Invantive Data Hub and Invantive Data Replicator. Instead of the refresh token, the user name, password plus a generated TOTP verification code are used to establish and maintain a connection going through the Implicit Grant Flow every approximately ten minutes. Various other means are used for TOTP on Exact Online, like “2FA” (two factor authentication) and “…

Vanaf de volgende release zal een hint meegegeven worden bij deze melding:

Please specify the TOTP-secret in the login window or using ‘totp-secret’ in the connection string.

[mds]

Alles werkte weer nadat de klant een nieuwe verificatiecode in Exact Online had ingevuld