Forum Discussion
"System.OutOfMemoryException"/Desktop sigue estrellándose
No @fletchb,
¿Tiene este problema sólo para este informe o para todos los informes?
Además, ¿cuál es su espacio de memoria?
Si es conveniente, ¿podría compartir los archivos de registro? Es útil activar el seguimiento y recopilar archivos de registro para aislar e identificar mejor el problema. Para activar el seguimiento, seleccione Opciones y configuración de > de archivos > Opciones y, a continuación, seleccione Diagnósticosy, a continuación, active Habilitar seguimiento en Opciones de diagnóstico. Nos damos cuenta de que Power BI Desktop debe estar en ejecución para establecer esta opción, lo que resulta más útil para futuros problemas asociados con el inicio de Power BI Desktop.
Saludos
cereza
Error de DataMashup.Trace: 24579: {"Start":"2018-08-06T06:52:36.4112586Z","Action":"PackagePartitionAnalysisInfo/SetPreviewValue","Exception":"Exception:rnExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089rnMessage: Exception of type 'System.OutOfMemoryException' was thrown.rnStackTrace:n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpressionUnchecked()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()n rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordInitializers()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader ReadUnaryExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFunctionOr InExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast .DocumentReader.ReadLetInitializers()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionMember()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSection()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionDocument(TokenReference begins)rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFirstDocument()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadDocument(ITokens tokens, Host IDocumentHost, registro de Action'1)rn a Microsoft.Mashup.Engine1.Engine.<Parse>b__0(ITokens t, IDocumentHost h, Action'1 l)rn a Microsoft.Mashup.Engine1.Engine.Parse(tokens ITokens, host IDocumentHost, Func'4 read)rn a Microsoft.Mashup.Engine1.Engine.Parse(tokens ITokens, host IDocumentHost, registro action'1)rn a Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Parse(tokens ITokens, host IDocumentHost, registro de Action'1)rn a Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.ParseSections()rn a Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.GetPartitionKeys()rn a Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument .<get_PartitionKeys>d__0.MoveNext()rn a Microsoft.Mashup.Evaluator.RelationshipIdentityAscriber.AscribeRelationshipIdentity(documento IPartitionedDocument)rn a Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult[T](Parámetros DocumentEvaluationParameters, llamada Action'1back)rn a Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action'1 callback)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.BeginEvaluation()rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult(Evaluation evaluation)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult[T](Evaluator evaluator, DocumentEvaluationParameters parameters, Action'1 callback)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action'1 callback)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.BeginEvaluation()rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete( Evaluación de evaluación)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.<>c__DisplayClass2.<Complete>b__0()rn a Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.Dispose()rn a Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2'1 result, Func'1 getStaleSince, Func'1 getSampled)rrrn","ProductVersion":"2.60.5169.3201 (18.07)","ActivityId":"00000000-0000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":8060,"Tid":24,"Duration":"00:00:00.9257497"}
Error de DataMashup.Trace: 24579: {"Start":"2018-08-06T06:52:37.3399678Z","Action":"UnexpectedExceptionHandler/HandleException","Exception":"Exception:rnExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089rnMessage: Exception of type 'System.OutOfMemoryException' was thrown.rnStackTrace:n at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpressionUnchecked()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()rn at Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()n rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordInitializers()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadRecordExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSimpleExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadPrimaryExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadTypeExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader ReadUnaryExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadUnaryExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadMetadataExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadEqualityExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadAsExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadIsExpression()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalAndExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLogicalOrExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFunctionOrInExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()r n a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetInitializers()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadLetExpression()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpressionUnchecked()rn a Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadExpression()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionMember()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSection()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadSectionDocument(TokenReference begin)rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadFirstDocument()rn en Microsoft.Mashup.Engine1.Language.Ast.DocumentReader.ReadDocument(tokens ITokens, host IDocumentHost, registro Action'1)rn en Microsoft.Mashup.Engine1.Engine.<Parse>b__0(ITokens t, IDocumentHost h, Action'1 l)rn en Microsoft.Mashup.Engine1.Engine.Parse(ITokens tokens, IDocumentHost host, Func'4 read)rn en Microsoft.Mashup.Engine1.Engine.Parse(ITokens tokens, IDocumentHost host, Action'1 log)rn en Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Parse(tokens ITokens, host IDocumentHost, registro Action'1)rn en Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.ParseSections()rn en Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.GetPartitionKeys()rn en Microsoft.Mashup.Evaluator.MemberLetPartitionedDocument.<get_PartitionKeys>d__0.MoveNext()rn en Microsoft.Mashup.Evaluator.RelationshipIdentityAscriber.AscribeRelationshipIdentity(documento IPartitionedDocument)rn en Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult[T](Parámetros DocumentEvaluationParameters, devolución de llamada Action'1)rn en Microsoft.Mashup.Evaluator.DocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action'1 callback)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1. BeginEvaluation()rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult(Evaluation evaluation)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.BeginGetResult[T](Evaluador evaluador, parámetros DocumentEvaluationParameters, devolución de llamada Action'1)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action'1 callback)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.BeginEvaluation()rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.EvaluationComplete(Evaluation evaluation)rn en Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.<>c__DisplayClass2.< Complete>b__0()rn en Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.Dispose()rn en Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2'1 result, Func'1 getStaleSince, Func'1 getSampled)rn en Microsoft.Mashup.Host.Document.Analysis.CachingDocumentAnalysisInfo.CachingPartitionAnalysisInfo.SetPreviewValue(EvaluationResult2'1 result, Func'1 getStaleSince, Func' 1 getSampled)rn en Microsoft.Mashup.DocumentHost.DocumentAnalyzer.Analyze(IPartitionAnalysisInfo partitionInfo, grabadora AccessRecorder, resultado EvaluationResult2'1, devolución de llamada Action'1)rn en Microsoft.Mashup.DocumentHost.DocumentAnalyzer.<>c__DisplayClass10.<BeginAnalyzeDocumentPartition>b__d(resultado EvaluationResult2'1)rn en Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.Complete(EvaluationResult2'1 result)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.Complete(EvaluationResult2'1 result)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass3'1.<BeginGetResult>b__0(EvaluationResult2'1 result)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action'1 callback, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Devolución de llamada Action'1, EvaluationResult2'1 result, Action action)rn at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation'1.Complete(EvaluationResult2'1 result)rn at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation'1.TryComplete(EvaluationResult2'1 result)rn at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)rn at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)rn en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)rn en Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass4.<Start>b__3(Object s)rn en Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)rn en Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2. <CreateThreadStart>b__0(Object o)rn en Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)rnrnrn","ProductVersion":"2.60.5169.3201 (18.07)","ActivityId":"00000000-0000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":8060,"Tid":24,"Duration":"00:00:00.0003570"}Hay @v-piga-msft,
Aquí está el registro de errores de seguimiento, he mantenido todas las líneas que muestran "error" debido al límite de caracteres del mensaje, ya que no pude ver cómo cargar un archivo. Si pudieras echar un vistazo, realmente lo apreciaría
gracias 🙂
- Syndicate_Admin5 years ago
Administrator
No @fletchb,
Si crea un informe con datos simples, ¿tiene este error?
Además, ¿tiene Power BI de 64 bits? Si no, deberías conseguirlo.
Para su caso, parece que no tiene suficiente memoria. Por favor, extienda su memoria tanto como sea posible. Puede consultar éste article(aunque el artículo trata sobre PowerPivot, debería ser similar con Power BI) para optimizar el modelo de datos de una manera que haga un mejor uso de la memoria disponible. Para otra cosa, si carga los datos en el modelo de importación, deshabilite "Permitir que la vista previa de datos se descargue en segundo plano" de opciones / opciones y configuración / carga de datos. Y comprobar si es útil.
Saludos
cereza