Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
manaxi
New Member

Onprem gateway 'A transport-level error has occurred when receiving results from the server. (provid

Hello,

We have a problem that sometimes this error appears in onprem gateway when refreshing dataset.

 

An error happened while reading data from the provider: 'A transport-level error has occurred when receiving results from the server. (provider: SSL Provider, error: 0 - The specified data could not be decrypted.

 

Full error:

 

 

DM.EnterpriseGateway Error: 0 : 2022-12-02T12:30:53.2768216Z DM.EnterpriseGateway	c068cd23-cca0-4699-875f-1d816f813fad	b940e9f3-7cac-498d-9e1b-0a12b009a487	MGPS	e59041c8-adbb-44db-a21e-635403d5a330	832e163d-bf91-487e-b3f4-dea2cf9aa3af	832e163d-bf91-487e-b3f4-dea2cf9aa3af	F5DD2A51 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=3885, err=MashupValueException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2022-12-02T12:30:53.2768216Z DM.EnterpriseGateway	819b9f3f-42ee-419d-8ec3-0098e82c04d5	b940e9f3-7cac-498d-9e1b-0a12b009a487	MDSR	e59041c8-adbb-44db-a21e-635403d5a330	832e163d-bf91-487e-b3f4-dea2cf9aa3af	832e163d-bf91-487e-b3f4-dea2cf9aa3af	C0BD9805 [DM.GatewayCore] Error serializing response: Microsoft.Data.Mashup.MashupValueException (0x80004005): An error happened while reading data from the provider: 'A transport-level error has occurred when receiving results from the server. (provider: SSL Provider, error: 0 - The specified data could not be decrypted.
)'
   at Microsoft.OleDb.Serialization.PageReaderDataReader.Read()
   at Microsoft.Data.Mashup.MashupReader.Read()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.AdoBinaryWriterSerializer.<Read>d__11.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.AdoBinaryWriterSerializer.<Serialize>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeAdoQueryResponse>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeAdoQueryResponse>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<>c__DisplayClass14_0.<<SerializeImpl>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.Metrics.PipelineMetricUtils.<MeasureQueryOperationAsync>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeImpl>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<>c__DisplayClass13_0.<<Serialize>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<Serialize>d__13.MoveNext()
DM.EnterpriseGateway Error: 0 : 2022-12-02T12:30:53.2768216Z DM.EnterpriseGateway	819b9f3f-42ee-419d-8ec3-0098e82c04d5	b940e9f3-7cac-498d-9e1b-0a12b009a487	MDSR	e59041c8-adbb-44db-a21e-635403d5a330	832e163d-bf91-487e-b3f4-dea2cf9aa3af	832e163d-bf91-487e-b3f4-dea2cf9aa3af	727CA6CB [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason: .; ErrorShortName: MashupDataAccessValueException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259,HResult=-2147467259]
DM.EnterpriseGateway Error: 0 : 2022-12-02T12:30:53.2768216Z DM.EnterpriseGateway	819b9f3f-42ee-419d-8ec3-0098e82c04d5	b940e9f3-7cac-498d-9e1b-0a12b009a487	MDSR	e59041c8-adbb-44db-a21e-635403d5a330	832e163d-bf91-487e-b3f4-dea2cf9aa3af	832e163d-bf91-487e-b3f4-dea2cf9aa3af	2A2D03D2 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <ccon>-2147467259</ccon>
DM.EnterpriseGateway Error: 0 : 2022-12-02T12:30:53.2768216Z DM.EnterpriseGateway	819b9f3f-42ee-419d-8ec3-0098e82c04d5	b940e9f3-7cac-498d-9e1b-0a12b009a487	MDSR	e59041c8-adbb-44db-a21e-635403d5a330	832e163d-bf91-487e-b3f4-dea2cf9aa3af	832e163d-bf91-487e-b3f4-dea2cf9aa3af	CCD490CD [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <ccon>[ccon]An error happened while reading data from the provider: 'A transport-level error has occurred when receiving results from the server. (provider: SSL Provider, error: 0 - The specified data could not be decrypted.
)'[/ccon]</ccon>

 

 

 

4 REPLIES 4
manaxi
New Member

Hello,

 

We are facing a issue in PBI. When refreshing data in schedule or refresh it through the web. Its not completing.

In gateway logs appears error with:

[ccon]An error happened while reading data from the provider: 'A transport-level error has occurred when receiving results from the server. (provider: SSL Provider, error: 0 - The specified data could not be decrypted.
)'[/ccon]

 

 

 

Hi,

 

Data source is MSSQL database. We have already added SQL server certificate in onprem gateway as "Trusted Root Certification"

lbendlin
Super User
Super User

This is not the right place.  You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors