Without knowing the cause, no advice can be given here.
There is a long-standing known bug in Exact Online relating to open items, whereby, depending on the open items, in roughly 1 in perhaps five to ten thousand situations the Exact Online API server crashes with an error message depending on the open items. It is possible that these open items have since been settled and Exact Online no longer crashes?
For absolute certainty, it is advisable to always add the error message from Invantive itself, as Microsoft products usually replace the actual error message with something meaningless. To do this, please follow the instructions below:
Instructions for Next Time
Additional information
Is it possible to add a (anonymised) screenshot of the details of the request in Invantive Bridge Online Monitoring, as described at Meer inzicht met nieuwe Online Monitoring?
You can find the details by clicking on the download request which represents the subject of this topic.
The download request usually has an SQL statement in which the table name is visible.
Please ensure that at least the following information remains visible in both columns:
- the title bar with the request ID,
- the status code, network size, path and timestamps in the left-hand column,
- the error code and error message right at the bottom of the left-hand column,
- the entire right-hand column including the SQL statement, table name and parameter values.
For example:
Check the correct server and user
Please check carefully that you are logging in to the Bridge Online website that is also used from Power BI, and with the same username. You will only see the requests of the Invantive Cloud user with which you log in to the website.
There are four servers in use:
bridge-online.cloud
app-online.cloud
bridge-online.invantive.com
app-online.invantive.com
The server being used can be seen in your script or report source code.
Check the correct request and details
Make sure you first select the request to display the details. Only one request should be visible in the screenshot.
Also check carefully that the request has a path with odata4 or apps. Requests with other paths are generally not relevant for this purpose.
Error message and tips by email
In addition, if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik or Tableau, the Invantive Cloud user who received the error message will usually receive an email at their email address containing an error message and tips.
It is advisable to check the spam folder of the user concerned for such emails sent from support@invantive.com.