Visma.net table JournalTransactionLines does not download

Questions
, ,
1

Ref my forum post about 1 months ago, I once again have troubles refreshing my Power BI reports.

As in the last time the problem appears to be related to the Visma.net table JournalTransactionLines. As before, Power BI says “Waiting for bridge online cloud”, then after a while cancels.

I have tried resetting the cache.

Request ID: 0HNCBM5IJC4D6:00000001

image
image2128×660 165 KB

2

Analysis revealed that the download does not actually start. A lock on the OData response cache could not be acquired. A developer will look into this issue and this topic will be updated once more information is available.

1 Like
3

I did a couple of refreshes now over the last 1 hour, and things appear to refresh much faster now. The last refresh took about 1-2 minutes, including downloading about 110 MB from Visma Journal transaction lines.

4

The next release of Invantive Cloud will contain additional analysis features, which should make it easier to determine why in this specific scenario the lock could not be acquired.

This specific next release is scheduled for production before May 6, 2025.

For now, no specific cause could be found.

In case the problem resurfaces, please add a reply to this topic with a screenshot of the request involved.

5

I am trying to refresh the report today, and its not working. Same message “waiting for bridge online cloud”.

Tried several times. Reset the cache. Aborted existing download.

This is a big problem for me as we are completing reporting. Can you help me?

6

Update, refresh worked now.
It is a problem for me that the connection or refresh appears to be very unstable.

7

We will be happy to assist in analysis and when necessary improvements. To aid in analysis for the root cause(s), it is recommended to always include a screenshot of the request. Without this information, it is nearly impossible to analyze. The text below contains tips how to add this screenshot.

8

Complete information

Is it possible to add a (anonymized) screenshot of the request details in Invantive Bridge Online Monitoring as described in More insight with new Bridge Online Monitoring?

Details can be found by clicking on the download request which represents the issue discussed in this topic.

The download request typically has a SQL-statement with table name visible.

Please leave at least the following data visible from both columns:

  • the title bar with the request ID,
  • the status code, network size, path and times 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

Verify correct server and user

Check carefully that you are logging into the Bridge Online website that is also used from Power BI and with the same user name. You will only see the requests from the Invantive Cloud user you are logging into the website with.

There are four servers in use:

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

You can see the server used in your script or source code of reporting.

Verify correct request and details

Please make sure to select the request to display the details. Only one single request should be visible in the screenshot.

Also check carefully that the request has a path with odata4 or apps. Other requests are in general non-relevant for this purpose.

Error message and tips per email

In addition, the Invantive Cloud user who has the error message will usually receive on his email address 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.

Advice is to check the affected user’s spam for such emails sent from support@invantive.com.