Forum Discussion
"System.OutOfMemoryException"/Desktop keeps crashing
DataMashup.Trace Error: 24579 : {"Start":"2018-08-06T06:52:36.4112586Z","Action":"PackagePartitionAnalysisInfo/SetPreviewValue","Exception":"Exception:\r\nExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Exception of type 'System.OutOfMemoryException' was thrown.\r\nStackTrace:\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordInitializers()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFunctionOrInExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionMember()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSection()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionDocument(TokenReference begin)\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFirstDocument()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadDocument(ITokens tokens, IDocumentHost host, Action`1 log)\r\n at Microsoft.Mashup.Engine1.Engine.<Parse>b__0(ITokens t, IDocumentHost h, Action`1 l)\r\n at Microsoft.Mashup.Engine1.Engine.Parse(ITokens tokens, IDocumentHost host, Func`4 read)\r\n at Microsoft.Mashup.Engine1.Engine.Parse(ITokens tokens, IDocumentHost host, Action`1 log)\r\n at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Parse(ITokens tokens, IDocumentHost host, Action`1 log)\r\n at Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.ParseSections()\r\n at Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.GetPartitionKeys()\r\n at Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.<get_PartitionKeys>d__0.MoveNext()\r\n at Microsoft.Mashup.Evaluator.RelationshipIdentityAscriber.AscribeRelationshipIdentity(IPartitionedDocument document)\r\n at Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult[T](DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.BeginEvaluation()\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult(Evaluation evaluation)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult[T](Evaluator evaluator, DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.BeginEvaluation()\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.<>c__DisplayClass2.<Complete>b__0()\r\n at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.Dispose()\r\n at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)\r\n\r\n\r\n","ProductVersion":"2.60.5169.3201 (18.07)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":8060,"Tid":24,"Duration":"00:00:00.9257497"}
DataMashup.Trace Error: 24579 : {"Start":"2018-08-06T06:52:37.3399678Z","Action":"UnexpectedExceptionHandler/HandleException","Exception":"Exception:\r\nExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Exception of type 'System.OutOfMemoryException' was thrown.\r\nStackTrace:\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordInitializers()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFunctionOrInExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionMember()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSection()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionDocument(TokenReference begin)\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFirstDocument()\r\n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadDocument(ITokens tokens, IDocumentHost host, Action`1 log)\r\n at Microsoft.Mashup.Engine1.Engine.<Parse>b__0(ITokens t, IDocumentHost h, Action`1 l)\r\n at Microsoft.Mashup.Engine1.Engine.Parse(ITokens tokens, IDocumentHost host, Func`4 read)\r\n at Microsoft.Mashup.Engine1.Engine.Parse(ITokens tokens, IDocumentHost host, Action`1 log)\r\n at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Parse(ITokens tokens, IDocumentHost host, Action`1 log)\r\n at Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.ParseSections()\r\n at Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.GetPartitionKeys()\r\n at Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.<get_PartitionKeys>d__0.MoveNext()\r\n at Microsoft.Mashup.Evaluator.RelationshipIdentityAscriber.AscribeRelationshipIdentity(IPartitionedDocument document)\r\n at Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult[T](DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.BeginEvaluation()\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult(Evaluation evaluation)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult[T](Evaluator evaluator, DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.BeginEvaluation()\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.<>c__DisplayClass2.<Complete>b__0()\r\n at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.Dispose()\r\n at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)\r\n at Microsoft.Mashup.Host.Document.Analysis.CachingDocumentAnalysisInfo.CachingPartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)\r\n at Microsoft.Mashup.DocumentHost.DocumentAnalyzer.Analyze(IPartitionAnalysisInfo partitionInfo, AccessRecorder recorder, EvaluationResult2`1 result, Action`1 callback)\r\n at Microsoft.Mashup.DocumentHost.DocumentAnalyzer.<>c__DisplayClass10.<BeginAnalyzeDocumentPartition>b__d(EvaluationResult2`1 result)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass3`1.<BeginGetResult>b__0(EvaluationResult2`1 result)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)\r\n at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryComplete(EvaluationResult2`1 result)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)\r\n at Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass4.<Start>b__3(Object s)\r\n at Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)\r\n\r\n\r\n","ProductVersion":"2.60.5169.3201 (18.07)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":8060,"Tid":24,"Duration":"00:00:00.0003570"}Hi v-piga-msft,
Here is the trace error log, I've kept all the lines showing "error"due to the message character limit, as I couldn't see how to upload a file. If you could have a look I'd really appreciate it
thanks :)
Hi fletchb,
If you create a report with simple data, do you have this error?
In addition, do you have 64 bit Power BI? If not, you should get it.
For your case, it seems that you don't have enough memory. Please extend your memory as much as possible. You can refer to this article(though the article is about PowerPivot, it should be similar with Power BI) to optimize your data model in a way that makes a better use the available memory. For another thing, if you upload the data in import model, please disable "Allow data preview to download in the background" from options / options and settings/data load. And check if it is useful.
Best Regards,
Cherry