Itgenobr344 : OAuth2 State Error in Query Tool & Data Hub v25.0.227 - Exact Online Connection Failed

An alternative approach has been adopted to enable users to log in to Exact Online from Invantive Data Hub once again. The approach used in Invantive Data Hub in recent years is no longer viable on Exact Online due to technological changes.

The alternative approach involves using Invantive Cloud to manage login credentials. Over the course of the coming week, a separate node will be added to Invantive Cloud named “Invantive Credentials Server”. This node can be used to request the so-called “access token”. This will allow Invantive Data Hub to continue to be used with on-premises systems and databases, with credentials being exchanged (in part) via Invantive Cloud.

Please make the following preparations if you wish to switch to using the Invantive Credentials Server:

  • Log in to Invantive Cloud using the licence coordinator’s email address.
  • Create a new ‘service account’ user as described at Manage users on Invantive Cloud.
  • Check that you can log in as this service user. The menu will remain largely empty.
  • Log in again as the licence coordinator.
  • Create a database using the Exact Online credentials from your settings*.xml.
  • Tick the new checkbox labelled “Allow Invantive Credentials Server Use” on the database screen.
  • Add the IP address from which Invantive Data Hub will connect to Invantive Cloud to request the access token to the database.

The migration involves the following steps (to be supplemented if necessary):

  • Upgrade Invantive Query Tool to a release due to be available next week
  • Upgrade Invantive Data Hub to a release due to be available next week
  • Replace the Exact Online login details in settings*.xml for the Exact Online data container with the connection details required for the Invantive Credentials Server.

If you require assistance with this, please book a short consultation.

A Dutch version of the above can be found at Error itgenobr344: Missing state.