Itgenoda345 - Operation time outs with Teamleader connection

[cgk42]

The connection between Invantive and Teamleader Focus seemed to have been lost. I noticed this earlier this week. In Teamleader, under integrations, the Power BI connector suddenly disappeared. I added it again and re-authorized it in Invantive Cloud.

The connection is successful, but for two days in a row now, there has been an “operation time out” or “the remote server returned an error: (429) Too many requests.”

A snippet from the diagnostics:

Who can help me resolve this?

Here’s one of the error messages in full:
Try again on failing to retrieve text data of partition ‘’ after 57.009 ms using ‘https://api.focus.teamleader.eu/meetings.list’ of ‘Teamleader.V2.Meetings’. Waiting for 16.072 ms and try again. Try #1 of 3; message ID ‘someid’. Invantive.Basics.InvantiveSqlException: itgenoda315: Data cannot be downloaded because the connection was broken before the results were returned (time-out 57,000 ms). (https://api.focus.teamleader.eu/meetings.list) —> System.Net.WebException: The operation has timed out. at System.Net.HttpWebRequest.GetResponse() at Invantive.Data.Providers.Http.HttpWorker.DoRequest(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IHttpBasedProvider self, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int64 timeoutInitialMs, Int64 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, Encoding responseEncoding, ExecutionStatistics& executionStatisticsOut, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions) — End of inner exception stack trace — at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Nullable1 isRecoverable, String poolIdentityId, String url, Nullable1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId) at Invantive.Basics.InvantiveSqlException..ctor(Glob...ecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) at System.Threading.Thread.StartCallback() at Invantive.Data.Providers.Http.HttpWorker.DoRequest(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IHttpBasedProvider self, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int64 timeoutInitialMs, Int64 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, Encoding responseEncoding, ExecutionStatistics& executionStatisticsOut, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions) at Invantive.Data.Providers.Http.HttpWorker.Post(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IHttpBasedProvider self, String relativeUrl, Dictionary2 inHeaders, Byte postData, String anonymizedPostText, CacheSettings cacheSettings, ObjectDefinition objectDefinition, QueryObject queryObject, Boolean allowRetryOnConnectionLoss, ParameterList parameters, ExecutionStatistics& executionStatisticsOut, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions, String acceptMimeType, String contentType, Boolean authenticate, Boolean preventRetryOnAuthenticationFailure, String partitionCode, String method, String callSafeNameOverrule, Boolean throwExceptionOnNonSuccessfulStatusCode, String publicQueryParameters, String postDataCacheKey). Data cannot be downloaded because the connection was broken before the results were returned (time-out 57,000 ms). The operation has timed out.

[forums]

Supplementary Information

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

You will find the details by clicking on the download request that is the subject of this topic.

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

Please ensure that at least the following details are visible from both columns:

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

For example:

Check Correct Server and User

Carefully check that you log in to the Invantive Cloud website with the same username you use for processing data through, for example, Invantive Bridge Online. You will only see the requests from the Invantive Cloud user with whom you log into the website.

Check Correct Request and Details

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

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

Error Message and Tips via Email

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

Recommended to check the spam of the involved user for such emails sent from support@invantive.eu.

[cgk42]

Thank you for your response.

I am not seeing anything in the monitoring. Could this be that this is because everything was set up by another user? They no longer work with us (pensioned).

I also do not see how to change under which user this could run.

[forums]

The advice is to integrate into the logic of Invantive Cloud. A good starting point for this is the mentioned page at:

More insight with new Online Monitoring

In addition to many new users, Invantive Bridge Online, as part of Invantive Cloud, is also experiencing increasingly intensive use. In the existing Bridge Online Monitoring, it was difficult to keep an overview in large and complex reports due to hundreds of data requests coming in for a series of Power BI reports. The following improvements are available: All monitoring via Invantive Cloud itself for all servers Simpler display Tooltips on all fields with potentially long texts Detail mode D…

[cgk42]

I will need you to be more specific of what I need to do. That page is rather unclear for me.

[forums]

The advice is to involve one of our partners or the colleague who set it up.

[forums]

This question was automatically closed after 1 week of inactivity. The latest given answer is marked as the solution.

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