Itgeneor825 error when logging in to Exact Online via Query Tool

Since a week after updating to the latest version, we get a notification when starting the Query Tool (also with last week’s release). The current release installed is 25.0.5-PROD+5516.

The login screen stays pending while connecting to Exact Online, without the application starting up. Then it becomes apparent that, in the menu bar, hovering over the Query Tool icon shows a black popup. As soon as this is closed, the error message appears as shown in the 2nd screenshot.

itgeneor825
A connection with the database … could not be established as user …
The OAuth access token has expired or is currently not accepted.
The authentication has already expired.
The remote server returned an error:
(401) Unauthorised.

Call stack:

System.Net.WebException
ValidationException
OAuthException
ValidationException
at System.Net.HttpWebRequest.GetResponse()
at Invantive.Data.Providers.Http.HttpWorker.DoRequest(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IHttpBasedProvider self, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int64 timeoutInitialMs, Int64 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)

Black Screen

The black screen is normal under release 25.0.5 when taking screenshots. Due to uncertainty about the functioning and correctness of Microsoft Recall, most screens are no longer visible in screenshots, Teamviewer or Microsoft Teams.

Excluding the screen content can be disabled for the duration of a session by unticking “Enable Privacy Mode” under Settings in the “Key” menu on the sign-in screen. At the next session, it will automatically be enabled again.

See also:

itgeneor825

The advice is to follow the suggestion from:

to first clear the OAuth access token field and try again.

Thanks for the clear explanation.

Followed the advice to remove the OAuth access token and reconnect. This again shows an empty pop-up. After closing this pop-up, the following error message appears:

Error details:

itgenoda184
The refresh token expired at 4/25/2025 10:01:18 PM and it is now 9/6/2025 7:41:54 AM.

The external server returned an error: (400) Invalid command.

Correct the request to make it valid.

Message ID: 69f2fa42-72e6-4801-aca4-e36fdf4348aa

Occurred (UTC): 6-9-2025 07:07:45

System.Net.WebException
ValidationException
ValidationException
at System.Net.HttpWebRequest.GetResponse()
at Invantive.Data.Providers.Http.HttpWorker.DoRequest(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IHttpBasedProvider self, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int64 timeoutInitialMs, Int64 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)

I’d be keen to hear how to proceed from here.

After turning off “Privacy mode” in Query Tool and making a new attempt to connect to Exactonline, the popup is now visible with the following message:

The advice is to check whether the Exact Online user in question still exists and has the appropriate permissions, for example by logging in to Exact Online. If that is the case, the advice is to enter the correct verification code.

The text The refresh token expired at 4/25/2025 10:01:18 PM and it is now 9/6/2025 7:41:54 AM. (error code itgenoda184 or itgeneor559) is returned verbatim as a response from the Exact Online API server.

Thanks for the reply.

The user can log in to Exact Online and has the correct permissions.

Cleared the access token again and disabled privacy mode. Manually entered the two-factor authentication and successfully logged in with it. But, as expected, it didn’t persist.

Finally, I updated to the latest version of Query Tool. And I was able to connect to ExactOnline again without any issues.