Our Power BI daily refreshes keep failing regularly:
Request failed: The operation has timed out.
DataSourceKind = OData.
DataSourcePath = https://bridge-online.cloud/acme-exact-online/odata4/ExactOnlineREST.Incremental.TransactionLinesIncremental@eol
OData:
Request failed:
The operation has timed out.
The exception was raised by the IDataReader interface.
Error code: itgenboe367
The data download was cancelled straight away after requested.
Please try again. Contact Invantive Support when this problem persists.
The download started at 16:07:28 and was considered canceled within 10 ms, going from itgenclr150 to itgenboe367. It returned a HTTP status 499.
The URL visited seems to be /setup, which is a list of available databases. Managed thread ID is 206.
The session has been restarted. This type of problem may occur at rare occassions, but should not occur consistently across multiple days.
Question: did restart of the session solve the problem for now?
In case the problem resurfaces within 7 days, please add a reply to this topic and include the request ID from Invantive Bridge Online Monitoring Details.
No root cause has yet been established. A new release with additional logging facilities will be taken into production before Monday, so hopefully this will shed some more light on the possible cause(s).
There was a filter on one partition.
I have removed this filter.
I tried to refresh, it started. Refresh is still running at 13:24 but in monitoring last step was at 12:59:
31 27-03-2024 12:59:27.412 itgenboe152 DataRetrieval Tot zover 6,000 rijen teruggegeven voor query op ‘Invantive.ExactOnlineREST.Incremental.TransactionLinesIncremental@eol’ (geschatte grootte 7,873,940 bytes).
It looks like it stopped downloading at 6000 rows.
Thank you for the additional information. We are uncertain whether it can also occur when multiple companies are selected. However, 6.000 rows in 25 minutes is extremely slow, so probably the issue also occurs for some users with multiple companies.
This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a 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.