On-premises data gateway intermittent connection (paginated reports only)

[kzeidiyeh]

We have multiple paginated Power BI reports running on the service. The gateway Status goes offline and when the end user runs the report, the below error is thrown:

Below is the error we have from the log:

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.<RunOperationAsync>d__7.MoveNext()
   --- End of inner exception stack trace ---
---> (Inner Exception #0) [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToImpersonateUserException: Error logging on username '<ccon>domain\user</ccon>'.
  TemplateMessage: Error impersonating a user.

 

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_ImpersonationError
GatewayVersion=3000.146.10 --->
Inner exception chain: System.ComponentModel.Win32Exception
<pi>System.ComponentModel.Win32Exception (0x80004005): The security database on the server does not have a computer account for this workstation trust relationship</pi>
   --- End of inner exception stack trace ---
  ([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToImpersonateUserException.StackTrace
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.GetSafeAccessTokenHandle(String userName, SecureString password)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.<RunImpersonatedAsync>d__17`1.MoveNext()

[kzeidiyeh]

we had a workaround to use a service account from a trusted domain. and the issue is resolved.

thanks sergej_og

[sergej_og]

Maybe gateway version update could be a nice approach (you have an old version) but I think you have to check hints in your error text..."trust relationship" etc.

Regards