Exact Online GoodsDeliveryLinesIncremental itgeneor643

For a few days now, the following query hasn’t been loading:

OData.Feed("https://bridge-online.cloud/acme-exact-online/odata4", null, \[Implementation="2.0", ODataVersion=4, OmitValues=ODataOmitValues.Nulls, Headers=\[Referer = "FLOW_EOL_GoodsDeliveryLines" \], Timeout=#duration(0,4,0,0)\])
select t.* 
from   ExactOnlineREST.Incremental.GoodsDeliveryLinesIncremental@eol t 
where  ([DeliveryDate] > :w1) 
limit  100

I’ve already cleared the cache several times and tried again, but it keeps giving itgeneor643. As far as I know, nothing else has changed.

Additional information

Would it be possible to add a (anonymised) screenshot of the details of the request in Invantive Bridge Online Monitoring, as described in Meer inzicht met nieuwe Online Monitoring?

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

The download request usually has an SQL statement in which the table name is visible.

Please leave at least the following information 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

You can see which server is being used in your script or the source code of your report.

Check the correct request and details

Make sure you select the request first in order to display the details. There should only be one request visible in the screenshot.

Also check carefully whether the request has a path containing 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.

We advise checking the spam folder of the user concerned for such emails sent from support@invantive.com.

Request ID: 0HNHGNP8JDPKP:0000003
Code: itgeneor643
Message: System error.
Parameter w1: 31-12-2023 23:00:00
Rows: 1474 (17 partitions/administrations selected)

The full error message in System Messages is:

itgeneor643
Each row in ExactOnlineREST.Incremental.GoodsDeliveryLinesIncremental should have a unique ID.
The new row with ID ‘0ae4d633-f1e9-49ca-9ccd-18dd4985d70e’ from modifiedandnew was already included in one of the previous 123 rows.

This means that Exact Online is returning a duplicate row, which the internal consistency check rejects.

The advice is to check whether it helps to retrieve the dataset completely afresh as follows:

  • Log in to the server described behind SPBA0401 in the screenshot.
  • Choose “Reset Cache” as described in Differentieer OData4 cachegedrag met Power BI.
  • Try refreshing again.
  • If resolved: tick the box under this comment.
  • If not resolved: add a screenshot of the new request associated with the retry.

I’ve already reset the Cache several times, is this referring to a different method of Resetting?

This definitely concerns a different server, probably Invantive Cloud itself, as node SPCA0401 cannot process OData4 requests.

The advice is to reset the cache on the previously mentioned server using the same Invantive Cloud user as used for the synchronisation.

Ok, that could be it. The refresh happens from the user “RPT”. I don’t remember the password for that any more. But I don’t have an email box for that. I always log in with “ME”. I just see the error messages coming through in monitoring. Is it correct that I need to log in with “RPT” and then reset the cache?

If so, how do I get the password? And I assume the authenticator as well?

Our advice is not to post any traceable personal or company information on the public forum. This has now been removed.

Regarding the password and authenticator, we advise getting in touch with whoever uses the user account, or resetting the password once you’ve regained access to the mailbox.

I just want to make sure. I’ve been using Invantive in exactly the same way for two years now.

On Invantive Cloud, ACME has given me a delegation on “ME”.

I have always used this, including to follow the monitor and reset the Cache. This has always worked. So now I can still log into Invantive and follow the Monitor, but apparently (according to you) I can’t reset the Cache? See the attached screenshot, which seems to suggest that this is indeed possible.

The “RPT” account was only used to set up the connection between the PowerBI service and Invantive. So it would be something new for me to have to use that. There’s also no active mailbox for it.

Is the cache indeed not being cleared? See screenshot. And do I now have to use “RPT” for the first time to log in? Can’t I do it the old, usual way?

The Reset Cache functionality has remained unchanged for several years. It only concerns the caches of the Invantive Cloud user who is logged in at the time.

A cache reset option is visible to every logged-in user via the menu at the top right, but it operates from within their own account and therefore has (virtually) no effect on other user accounts within the same environment.

Our advice is to log in with the “RPT” user after reconfiguration/resetting, and then reset the cache.

This way of communicating is still difficult for me. Can we take it step by step for a moment?

When I refresh the cache using the method I’ve always used and that always worked, it looks like it’s still simply being emptied.

Do you have an answer to the following question: Has the cache been refreshed or not?

The URL with /delegation relates to opening a delegation screen. The application of a refresh cache for the current user (as included with the request) can be recognised by the path /app/account/cache/reset as shown below:

The red box on the left is the user whose caches have been cleared, the one on the right signals the action.

The blue colour always appears with cache because this signals an HTTP 302 (redirect).

Thanks for the info! Sorry, my mistake, I used the wrong screenshot. Below is the cache reset.

The colour indeed doesn’t turn blue. Has this cleared the cache now?

This action performed a cache reset for the user “ME” on the server cloud.invantive.com.

To have an effect on the download, it is advised to do this for the user “RPT” on the Invantive Bridge Online server being used.

So this isn’t the method. I need to log in differently. You’re talking about the user RPT.

  1. Does this mean I need to log in with a different email address? If so, which email address is that?
    Or can the Customer log in to Invantive and upgrade my delegation account “ME” so that I can also clear the cache with this account?
  2. Does this login still happen on the usual URL?

The advice is to follow this earlier advice:

Alternatively, you can schedule a short consultation via the chat in the bottom right-hand corner. A charge will be made for each commenced quarter of an hour.

I don’t quite understand why I should have to pay for this, the customer pays a monthly subscription fee and there’s no need for technical knowledge on your end. I’d just like to know who the RPT user is in this environment, or how I can find that out? Shouldn’t be too complicated a question for you, I’d have thought?

The advice is to follow the original advice to reset the cache in order to prevent the exchange from repeating. The username “RPT” is a placeholder used to remove the entered personally identifiable information (all information here is public).

Ok, I was able to clear the cache and restart the refresh. Unfortunately, still no refresh. Has the cache not been cleared then?

See the previous advice and original advice. Only the cache of the connected user on the server it is connected to is cleared. In this case, that is the user “ME” instead of the user for the replication, and on the Invantive Cloud server instead of Invantive Bridge Online.