Itgenoda359 Refresh data interrupted

Questions (nl)
,
1

The following message appears when refreshing the account move line data:

Error in data source:
DataSource.Error:
OData:
Invalid JSON.
Unexpected end of input was found in JSON content.
Not all object and array scopes were closed.
Microsoft.Data.Mashup.ValueError.DataSourceKind = OData.
DataSourcePath = https://bridge-online.invantive.com/acme-odoo/odata4/Odoo.account.move_line@odo.
The exception was raised by the IDataReader interface.
Please review the error message and provider documentation for further information and corrective action.

2

Supplementary Information

Is it possible to add an (anonymised) screenshot of the request details in Invantive Bridge Online Monitoring as described at Meer inzicht met nieuwe Bridge Online Monitoring?

You can find the details by clicking on the download request representing the subject of this topic.

The download request usually includes an SQL statement where the table name is visible.

Please ensure at least the following data is visible from both columns:

  • the title bar with the request ID,
  • the status code, network size, path and timings in the left column,
  • the error code and error message at the very bottom of the left column,
  • the entire right column including the SQL statement, table name, and parameter values.

For example:

image
image1474×640 49.6 KB

Check Correct Server and User

Please carefully verify that you are logged into the Bridge Online website used by Power BI and with the same username. You will only see the requests from the Invantive Cloud user with whom you log into the website.

There are four servers in use:

  • bridge-online.cloud
  • app-online.cloud
  • bridge-online.invantive.com
  • app-online.invantive.com

The server in use can be found in your script or reporting source code.

Check Correct Request and Details

Ensure you first select the request to display the details. Only one request should be visible in the screenshot.

Also carefully check if the request has a path with odata4 or apps. Requests with other paths are generally not relevant for this purpose.

Error Messages and Tips by Email

Additionally, the Invantive Cloud user who received the error message will usually receive an email with an error message and tips if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik or Tableau.

The advice is to check the spam folder of the concerned user for such emails sent from support@invantive.com.

4

This is the complete error message:

itgenoda359
The connection to the website was unexpectedly and forcibly closed on 22-08-2026 02:41:30 for reasons such as insufficient permissions, the website hanging, the system restarting, a forced shutdown of a remote host or firewall action.
Retrieving data failed for all 3 attempts over 203 seconds.
Please contact Odoo API support. (https://acme.odoo.com/jsonrpc).
The data could not be downloaded because the connection was closed before the results were returned (timeout 57,000 ms).
(https://acme.odoo.com/jsonrpc).
The operation has timed out.

5

The advice is to schedule the download at a different time. It is not unusual for cloud platforms to carry out activities, usually between 2 and 3 a.m., during which they are unavailable.

Invantive SQL will make a number of attempts and, if unavailability persists, will report the original error message shown.

6

This question was automatically closed after 1 week of inactivity. The last given answer has been marked as the solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.