We krijgen een foutmelding bij het laden van Exact Online data via PowerBI Desktop.
Melding is als volgt:
WO-MateriaalOLE DB- of ODBC-fout: [DataSource.Error] OData: Kan geen gegevens lezen uit de transportverbinding: De externe host heeft een verbinding verbroken…
De errors geven aan dat er te veel tijd nodig was om de data te laden:
itgenoda324
Try again on failing to retrieve text data of partition ‘2844834’ after 78,490 ms using ‘***’ of ‘ExactOnlineREST.Manufacturing.ShopOrderMaterialPlans’. Waiting for 11,144 ms and try again. Try #1 of 10; message ID ‘160a2e85-f339-4f6d-bf9c-d708329d0152’. > Invantive.Basics.InvantiveSqlException: itgenoda039: De gegevens voor partitie ‘2844834’ konden niet gedownload worden. > (https://start.exactonline.nl/api/v1/2844834/manufacturing/ShopOrderMaterialPlans?$select=*&$skiptoken=guid’17d1b43c-2703-4932-ab84-5efcfe230cf2’)
—> System.Net.WebException: The SSL connection could not be established, see inner exception.
—> System.Net.Http.HttpRequestException: The SSL connection could not be established, see inner exception.
—> System.IO.IOException: Received an unexpected EOF or 0 bytes from the transport stream.
at System.Net.Security.SslStream.ReceiveBlobAsync[TIOAdapter](TIOAdapter adapter) at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](TIOAdapter adapter, Boolean receiveFirst, Byte reAuthenticationData, Boolean isApm)
at System.Net.Security.SslStream.ProcessAuthentication(Boolean isAsync, Boolean isApm, CancellationToken cancellationToken)
at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
at System.Net.Http.ConnectHelper.EstablishSslConnectionAsyncCore(Boolean async, Stream stream, SslClientAuthenticationOptions sslOptions, CancellationToken cancellationToken) — End of inner exception stack trace —
at System.Net.Http.ConnectHelper.EstablishSslConnectionAsyncCore(Boolean async, Stream stream, SslClientAuthenticationOptions sslOptions, CancellationToken cancellationToken)
at System.Net.Http.HttpConnectionPool.ConnectAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken)
at System.Net.Http.HttpConnectionPool.CreateHttp11ConnectionAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationT…Token cancellationToken)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder1.AsyncStateMachineBox
1.MoveNext(Thread threadPoolThread)
at System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(IAsyncStateMachineBox box, Boolean allowInlining) at System.Threading.Tasks.Task.RunContinuations(Object continuationObject) at System.Threading.Tasks.Task.FinishSlow(Boolean userDelegateExecute)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) at System.Threading.ThreadPoolWorkQueue.Dispatch()
at Invantive.Data.Providers.Http.HttpBasedProvider.DoRequest(GlobalState owner, ExecutionOptions executionOptions, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, ExecutionStatistics& statistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
at Invantive.Data.Providers.Http.HttpBasedProvider.GetInternal(GlobalState owner, ExecutionOptions executionOptions, String relativeUrl, String mimeType, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, CacheSettings cacheSettings, String callSafeNameOverrule, Boolean allowRetry, Boolean preventRetryOnAuthenticationFailure, ParameterList parameters, String dataContainerIdOverrule, Boolean throwExceptionOnNonSuccessfulStatusCode, ExecutionStatistics& statistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions).
De gegevens voor partitie ‘2844834’ konden niet gedownload worden.
The SSL connection could not be established, see inner exception.
Received an unexpected EOF or 0 bytes from the transport stream.
26-10-2021 09:56:14
Enige idee wat er aan de hand kan zijn?