PBIRS randomly crashes - Could not impersonate the user

[Anonymous]

Hello everyone,

One of our 3 Power BI Report Servers crash randomly multiple times per week.

It always throw the same error. 

Find below a snippet of the log file "RSPowerBI" stored in PBIRS/LogFiles/ directory:

2020-09-03 11:28:29.2895|ERROR|15|Error getting next eventSystem.ApplicationException: Could not impersonate the user. LogonUser returned error code 8.
à Microsoft.BIServer.HostingEnvironment.ImpersonationContext..ctor(AccountCredentials accountCredentials)
à Microsoft.BIServer.HostingEnvironment.ImpersonationContext.EnterUserContext(AccountCredentials accountCredentials)
à Microsoft.BIServer.Configuration.Catalog.CatalogAccessFactory.NewConnection()
à Microsoft.BIServer.Configuration.Catalog.CatalogAccessFactory.<QueryFirstOrDefaultAsync>d__5`1.MoveNext()

I also had a look at the Windows events and there is always a .NET Runtime error thrown (sorry for the french):

Application : RSHostingService.exe
Version du Framework : v4.0.30319
Description : le processus a été arrêté en raison d'une exception non gérée.
Informations sur l'exception : System.OutOfMemoryException
à NLog.MessageTemplates.TemplateEnumerator.ParseFormat()
à NLog.MessageTemplates.TemplateEnumerator.ParseHole(NLog.MessageTemplates.CaptureType)
à NLog.MessageTemplates.TemplateEnumerator.MoveNext()
à NLog.MessageTemplates.TemplateRenderer.Render(System.String, System.IFormatProvider, System.Object[], Boolean, System.Text.StringBuilder, System.Collections.Generic.IList`1<NLog.MessageTemplates.MessageTemplateParameter> ByRef)
à NLog.Internal.LogMessageTemplateFormatter.AppendFormattedMessage(NLog.LogEventInfo, System.Text.StringBuilder)
à NLog.LogEventInfo.AppendFormattedMessage(NLog.Internal.ILogMessageFormatter, System.Text.StringBuilder)
à NLog.LayoutRenderers.MessageLayoutRenderer.Append(System.Text.StringBuilder, NLog.LogEventInfo)
à NLog.LayoutRenderers.LayoutRenderer.RenderAppendBuilder(NLog.LogEventInfo, System.Text.StringBuilder)
à NLog.Layouts.SimpleLayout.RenderAllRenderers(NLog.LogEventInfo, System.Text.StringBuilder)
à NLog.Layouts.Layout.RenderAppendBuilder(NLog.LogEventInfo, System.Text.StringBuilder, Boolean)
à NLog.Layouts.SimpleLayout.PrecalculateBuilder(NLog.LogEventInfo, System.Text.StringBuilder)
à NLog.Targets.Target.PrecalculateVolatileLayoutsWithLock(NLog.LogEventInfo)
à NLog.Targets.Wrappers.AsyncTargetWrapper.Write(NLog.Common.AsyncLogEventInfo)
à NLog.Targets.Wrappers.AsyncTargetWrapper.WriteAsyncThreadSafe(NLog.Common.AsyncLogEventInfo)
à NLog.Targets.Target.WriteAsyncLogEvent(NLog.Common.AsyncLogEventInfo)
à NLog.LoggerImpl.WriteToTargetWithFilterChain(NLog.Targets.Target, NLog.Filters.FilterResult, NLog.LogEventInfo, NLog.Common.AsyncContinuation)
à NLog.LoggerImpl.Write(System.Type, NLog.Internal.TargetWithFilterChain, NLog.LogEventInfo, NLog.LogFactory)
à Microsoft.BIServer.BIService.ManagedProcess+<ThrottledStart>d__20.MoveNext()
à System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
à System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
à System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
à System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
à System.Threading.ThreadPoolWorkQueue.Dispatch()

I've been digging Google but didn't find any relevant information about those 2 errors.

We are running PBIRS January 2020 (15.0.1102.777)

The only difference with our 2 other servers is we have an HTTPS certificate configured on this one.

Everytime the server crash, we have to manually restart the PBIRS Service via the configuration manager console.

Thank you all for your input.

[amitchandak]

@Anonymous , it is showing out of the memory exception. Open this with most of the other processed closed and see does it open up. Check how much RAM and CPU power bi take up at that time.

[Anonymous]

Hi @amitchandak 

Thank you for the reply.

I've checked the metrics for the last 7 days (we have this monitored):

Each of the 4 CPUs is always below 15% and the RAM is always around 16Gb used with 32Gb available.

Can you pelase clarify the following sentence, I didn't get your point:

"Open this with most of the other processed closed and see does it open up"

Thanks

[amitchandak]

@Anonymous , seems like no load.

Log an issue https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous · Accepted solution]

Hello,

Quick update:

The error message was not relevant because it was a memory error. Some DAX queries were loading the memory and made the server crash.