Dear all,
We are working with a 32bit solution because we have some legacy 32bit access files as sources.
However, recently PowerBI 32bit keeps crashing, at random time between 15 seconds to 60 seconds after opening, without any interaction from the user.
I've tried opening the file on a another, and more powerful, PC with 64bit PowerBI with success.
PowerBI desktop doesn't provide any error message - I've enabled trace and of "errors" I can see the following 5 lines in the log;
2 Lines relates to the infamous System.OutOfMemoryException.
Any ideas to the root cause and how to get around the problem?
Trace Id,Hour,Log Id,ActivityId,Action Detail,Exception
24579,1899-12-30 08:41:39,4593,00000000-0000-0000-0000-000000000000,UnexpectedExceptionHandler/HandleException,"Exception:
ExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: Der blev udløst en undtagelse af typen 'System.OutOfMemoryException'.
StackTrace:
ved System.IO.MemoryStream.set_Capacity(Int32 value)
ved System.IO.MemoryStream.EnsureCapacity(Int32 value)
ved System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
ved System.IO.BinaryWriter.Write(Int32 value)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteList[T](List`1 list, Action`2 action)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.MetadataSet.<Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize>b__7(BinarySerializationWriter w, List`1 v)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteDictionary[TKey,TValue](Dictionary`2 dictionary, Action`2 keyFunc, Action`2 valueFunc)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.MetadataSet.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageItemMetadata.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteList[T](List`1 list)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageMetadata.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializer.SerializeBytesCore[T](T value)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializer.SerializeBytes[T](T value)
ved Microsoft.Mashup.Host.Document.Storage.Local.BinaryLocalStorageContext`1.SetPart(T part)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalStorageContext`1.Dispose()
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageMetadataStorage.UpdateItemMetadata(Int32 editVersion, PackageItemUpdate[] itemUpdates)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.TracingPackageMetadataStorage.UpdateItemMetadata(Int32 editVersion, PackageItemUpdate[] itemUpdates)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.PackageItemUpdateBuffer.Flush()
ved Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.FormulaMetadataRecorder.Flush()
ved Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetComplete()
ved Microsoft.Mashup.Host.Document.Analysis.CachingDocumentAnalysisInfo.CachingPartitionAnalysisInfo.SetComplete()
ved Microsoft.Mashup.DocumentHost.DocumentAnalyzer.Analyze(IPartitionAnalysisInfo partitionInfo, AccessRecorder recorder, EvaluationResult2`1 result, Action`1 callback)
ved Microsoft.Mashup.DocumentHost.DocumentAnalyzer.<>c__DisplayClass10.<BeginAnalyzeDocumentPartition>b__d(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass3`1.<BeginGetResult>b__0(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryComplete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
ved Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass4.<Start>b__3(Object s)
ved Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)"
24579,1899-12-30 08:41:39,4598,00000000-0000-0000-0000-000000000000,UnexpectedExceptionHandler/HandleException,"Exception:
ExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: Der blev udløst en undtagelse af typen 'System.OutOfMemoryException'.
StackTrace:
ved System.IO.MemoryStream.set_Capacity(Int32 value)
ved System.IO.MemoryStream.EnsureCapacity(Int32 value)
ved System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
ved System.IO.BinaryWriter.Write(String value)
ved Microsoft.Mashup.Evaluator.IPackageSerializationExtensions.WriteIPackageSection(BinaryWriter writer, IPackageSection section)
ved Microsoft.Mashup.Evaluator.IPackageSerializationExtensions.WriteIPackage(BinaryWriter writer, IPackage package)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.BeginGetResultMessage.Serialize(BinaryWriter writer)
ved Microsoft.Mashup.Evaluator.BinarySerializer.Serialize(Action`1 serializer)
ved Microsoft.Mashup.Evaluator.Interface.BufferedMessage.Prepare()
ved Microsoft.Mashup.Evaluator.ChannelMessenger.PostWithoutFlowControl(MessageChannel channel, Message message)
ved Microsoft.Mashup.Evaluator.ChannelMessenger.Post(MessageChannel channel, Message message)
ved Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Post(Message message)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
ved Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass4.<Start>b__3(Object s)
ved Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)"
24579,1899-12-30 08:41:39,4600,00000000-0000-0000-0000-000000000000,"PBI.Program/Main/Using MainWindow/LogUnhandledException Exception:System.OutOfMemoryException: Der blev udløst en undtagelse af typen 'System.OutOfMemoryException'.
ved System.IO.MemoryStream.set_Capacity(Int32 value)
ved System.IO.MemoryStream.EnsureCapacity(Int32 value)
ved System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
ved System.IO.BinaryWriter.Write(String value)
ved Microsoft.Mashup.Evaluator.IPackageSerializationExtensions.WriteIPackageSection(BinaryWriter writer, IPackageSection section)
ved Microsoft.Mashup.Evaluator.IPackageSerializationExtensions.WriteIPackage(BinaryWriter writer, IPackage package)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.BeginGetResultMessage.Serialize(BinaryWriter writer)
ved Microsoft.Mashup.Evaluator.BinarySerializer.Serialize(Action`1 serializer)
ved Microsoft.Mashup.Evaluator.Interface.BufferedMessage.Prepare()
ved Microsoft.Mashup.Evaluator.ChannelMessenger.PostWithoutFlowControl(MessageChannel channel, Message message)
ved Microsoft.Mashup.Evaluator.ChannelMessenger.Post(MessageChannel channel, Message message)
ved Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Post(Message message)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
ved Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass4.<Start>b__3(Object s)
ved Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)",
24579,1899-12-30 08:41:39,4599,00000000-0000-0000-0000-000000000000,"PBI.Program/Main/Using MainWindow/LogUnhandledException Exception:System.OutOfMemoryException: Der blev udløst en undtagelse af typen 'System.OutOfMemoryException'.
ved System.IO.MemoryStream.set_Capacity(Int32 value)
ved System.IO.MemoryStream.EnsureCapacity(Int32 value)
ved System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
ved System.IO.BinaryWriter.Write(Int32 value)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteList[T](List`1 list, Action`2 action)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.MetadataSet.<Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize>b__7(BinarySerializationWriter w, List`1 v)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteDictionary[TKey,TValue](Dictionary`2 dictionary, Action`2 keyFunc, Action`2 valueFunc)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.MetadataSet.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageItemMetadata.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteList[T](List`1 list)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageMetadata.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializer.SerializeBytesCore[T](T value)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializer.SerializeBytes[T](T value)
ved Microsoft.Mashup.Host.Document.Storage.Local.BinaryLocalStorageContext`1.SetPart(T part)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalStorageContext`1.Dispose()
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageMetadataStorage.UpdateItemMetadata(Int32 editVersion, PackageItemUpdate[] itemUpdates)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.TracingPackageMetadataStorage.UpdateItemMetadata(Int32 editVersion, PackageItemUpdate[] itemUpdates)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.PackageItemUpdateBuffer.Flush()
ved Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.FormulaMetadataRecorder.Flush()
ved Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetComplete()
ved Microsoft.Mashup.Host.Document.Analysis.CachingDocumentAnalysisInfo.CachingPartitionAnalysisInfo.SetComplete()
ved Microsoft.Mashup.DocumentHost.DocumentAnalyzer.Analyze(IPartitionAnalysisInfo partitionInfo, AccessRecorder recorder, EvaluationResult2`1 result, Action`1 callback)
ved Microsoft.Mashup.DocumentHost.DocumentAnalyzer.<>c__DisplayClass10.<BeginAnalyzeDocumentPartition>b__d(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass3`1.<BeginGetResult>b__0(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
ved Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryComplete(EvaluationResult2`1 result)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
ved Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
ved Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass4.<Start>b__3(Object s)
ved Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)
ved Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)",
24579,1899-12-30 08:41:39,4586,00000000-0000-0000-0000-000000000000,PackageMetadataStorage/UpdateItemMetadata,"Exception:
ExceptionType: System.OutOfMemoryException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: Der blev udløst en undtagelse af typen 'System.OutOfMemoryException'.
StackTrace:
ved System.IO.MemoryStream.set_Capacity(Int32 value)
ved System.IO.MemoryStream.EnsureCapacity(Int32 value)
ved System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
ved System.IO.BinaryWriter.Write(Int32 value)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteList[T](List`1 list, Action`2 action)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.MetadataSet.<Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize>b__7(BinarySerializationWriter w, List`1 v)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteDictionary[TKey,TValue](Dictionary`2 dictionary, Action`2 keyFunc, Action`2 valueFunc)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.MetadataSet.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageItemMetadata.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializationWriter.WriteList[T](List`1 list)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageMetadata.Microsoft.Mashup.Client.Packaging.BinarySerialization.IBinarySerializable.Serialize(BinarySerializationWriter writer)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializer.SerializeBytesCore[T](T value)
ved Microsoft.Mashup.Client.Packaging.BinarySerialization.BinarySerializer.SerializeBytes[T](T value)
ved Microsoft.Mashup.Host.Document.Storage.Local.BinaryLocalStorageContext`1.SetPart(T part)
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalStorageContext`1.Dispose()
ved Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageMetadataStorage.UpdateItemMetadata(Int32 editVersion, PackageItemUpdate[] itemUpdates)
ved Microsoft.Mashup.Host.Document.Storage.Metadata.TracingPackageMetadataStorage.UpdateItemMetadata(Int32 editVersion, PackageItemUpdate[] itemUpdates)"
