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

[manaxi]

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>

[manaxi]

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]

[djurecicK2]

Hi @manaxi ,

 What is your data source?

These might be helpful to you:

https://community.powerbi.com/t5/Desktop/unable-to-connect-to-the-data-source-using-an-encrypted/m-p...

[manaxi]

Hi,

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

[lbendlin]

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/