Instable load from Exact into Qlik?

[4hf1]

Unfrequently I cannot load data from Exact. In Qlik I have an app to load the data:

As you can see the loading time varies from 2 minutes (successful) to 1 hour (failed).

In the monitoring I can see the following error:

For comparison here the fetch where it was successful:

Can anybody help? I would like to establish a stable connection, where I fetch every night the data from Exact.

[4hf1]

Also here the log from Qlik:

Accounts << JsonV4GetData 1,977 Lines fetched
Projects << JsonV4GetData 0 Lines fetched

The following error occurred:
Internal error. (Connector error: Failed on attempt 1 to GET. (The operation has timed out.))
The engine error code: Connector error:22013
The error occurred here:
SELECT *
	FROM JsonV4GetData
	WITH PROPERTIES (
	oDataResourcePath='ExactOnlineREST_Cashflow_Receivables_eol',
	oDataQueryOptions='',
	maxDepth='',
	maxResults=''
	)

As you can see, I can fetch from Exact successfully the Accounts and Projects, but the Receivables not.

[forums]

As a guess: can you try rescheduling the download to outside 00:00 - 06:00 UTC?

The German environment might have different down periods.

[4hf1]

Thanks, I tried that but still I get sometimes errors:

[forums]

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:

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.

[4hf1]

I could verify, that the connection is settep up correctly, as sometimes it is successful.

Here the requested screenshots:

If anything more I should provide you to solve the issue, please let me know.

[forums]

Please see How to resolve an itgenboe147 or itgenboe161 message: The data download was cancelled for help on this issue.

[forums]

Deze vraag is automatisch gesloten na 1 week inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.