Wanneer ik via een batchbestand probeer een query uit te voeren krijg ik de melding:
itgenobr166
The OAuth flow redirected to the correct host, but no access token was present in the URL after all redirects
Waar kan dit in zitten?
Stack trace:
2022-07-22 09:59:08.400 Error itgenobr166: Invantive.Basics.InvantiveSqlException
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.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)
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.HG(GlobalState , ExecutionOptions , SerializableDatabase , DataContainer , OAuthInformation , Credentials )
at Invantive.Data.ConnectionManager.OG(GlobalState , 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.PG(GlobalState , ExecutionOptions , IConnectionDataProvider , SerializableDatabase , DataContainer , 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.LG(GlobalState , 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 IDH.D.B(String[] )
at Invantive.Producer.QueryEngine.Program.Main(String[] arguments)
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.HG(GlobalState , ExecutionOptions , SerializableDatabase , DataContainer , OAuthInformation , Credentials )
at Invantive.Data.ConnectionManager.OG(GlobalState , 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.PG(GlobalState , ExecutionOptions , IConnectionDataProvider , SerializableDatabase , DataContainer , 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.LG(GlobalState , 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)
2022-07-22 09:59:08.459 Error itgencun016: Error itgendhb005: Could not connect to database 'ACME\acme'. Application will be closed.
2022-07-22 09:59:08.464 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 IDH.D.B(String[] )
at Invantive.Producer.QueryEngine.Program.Main(String[] arguments)
at IDH.D.B(String[] )
2022-07-22 09:59:08.487 Error itgenube182: itgendhb005: Could not connect to database 'ACME\acme'. Application will be closed.