Itgenoda494 – Unable to renew Exact Online data container authorisation due to One Exact Identity with multiple users

Power BI Desktop has recently been unable to refresh the tables from one of our Exact Online environments via Invantive Bridge Online. We want to restore the existing connection so that the Power BI reports can refresh again.

When I open the OData URL of the relevant environment in the browser and log in, I get error code itgenoda494.

The message indicates that the stored refresh token is outdated. According to the message, this can happen when an Exact Online user is linked twice with the same OAuth application. Invantive advises renewing the authorisation of data container eol.

What we have tried

  • In Invantive Cloud, we looked up the existing database and data container eol and checked which user was last listed against the container.
  • We tried to renew the authorisation with that Exact Online account. Exact then shows a message stating that the One Exact Identity account is set up for multiple users and that this is not supported for API connections. I’ve attached a screenshot of this.
  • During an earlier authorisation attempt, we also received a message stating that the same single authentication ID already exists for another data container. We haven’t deleted any existing data containers.
  • In Invantive Cloud, the relevant container does not have “Repair needed” ticked, even though the OData connection does return error code itgenoda494.

We have two Exact Online environments that are used via Invantive for Power BI. We want to avoid restoring one connection breaking the other.

Our questions

  1. How can we determine which Exact Online account and which existing data container we should use to restore this connection?
  2. How can we restore the authorisation if the last-used One Exact Identity account is set up for multiple users?
  3. How can we find out which other data container uses the same authentication ID, and prevent the two connections from invalidating each other’s refresh token?
  4. Can the absence of a tick at Repair needed be explained, given that the OData URL does return itgenoda494?

Environment

  • Product: Invantive Bridge Online
  • Version: 27.0.101-PROD+6516
  • Source system: Exact Online
  • Consumer: Power BI Desktop via OData
  • Data container alias: eol
  • Error code: itgenoda494

Message

Login
Your One Exact identity account is configured for multiple users.
API Connections do not support this type of account.
Please create a separate One Exact identity account for every user.

To get a working configuration, it is advised to follow the instructions from Exact Online. The use of One Exact Identity users linked to multiple subscriptions is not supported by Exact Online. There are workarounds or bugs to get around this, but we advise against it.

In a future release of Invantive Cloud, the data container is expected to switch to “Repair needed” in this situation.

More information about itgenoda494 can be found at: