Problems with Merging: Unexpected error: Session guid does not match the started session guid.

[Anonymous]

Again and again while trying to do simple, straightforward merges:

Unexpected error: Session guid does not match the started session guid.
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Session guid does not match the started session guid. ---> System.ArgumentException: Session guid does not match the started session guid. ---> System.ArgumentException: Session guid does not match the started session guid.
at Microsoft.DataIntegration.FuzzyMatching.FuzzyLookupEntry.ContinueJoin(Guid sessionGuid, DataTable inputTable)
at Microsoft.Mashup.Engine1.Language.Query.FuzzyMatchingUtil.ExternalFuzzyMatchingUtil.ExecuteJoin(DataTable inputDataTable, DataTable referenceDataTable, DataTable transformationDataTable, FuzzyLookupParameters fuzzyJoinParameters, JoinType fuzzyJoinType, Guid sessionId, Boolean isFirst)
at Microsoft.Mashup.Engine1.Language.Query.FuzzyMatchingUtil.ExternalFuzzyMatchingUtil.ExecuteFuzzyJoin(IEngineHost host, DataTable inputDataTable, DataTable referenceDataTable, DataTable transformationDataTable, FuzzyJoinOptions fuzzyJoinOptions, JoinKind joinKind, Guid sessionId, Boolean isFirst)
at Microsoft.Mashup.Engine1.Language.Query.FuzzyMatchingUtil.GetNestedJoinOutputTable(IEngineHost host, RecordValue inputTableValue, Int32[] inputTableKeys, TableValue referenceTableValue, Int32[] referenceTableKeys, FuzzyNestedJoinParameters parameters, Guid sessionId, Boolean isFirst)
at Microsoft.Mashup.Engine1.Language.Query.IndexFuzzyNestedJoinAlgorithm.IndexFuzzyNestedJoinEnumerator.GetNestedTableValue(RecordValue leftRow, RecordValue rightKeyValue)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.IndexNestedJoinEnumerator.get_Current()
at Microsoft.Mashup.Engine1.Language.Query.SelectRowsQuery.SelectRowsEnumerable.SelectRowsEnumerator.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.DistinctQuery.DistinctEnumerable.DistinctEnumerator.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.DistinctQuery.DistinctEnumerable.DistinctEnumerator.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.JoinAlgorithm.HashJoinAlgorithm.HashJoinEnumerator.MoveNext()
at Microsoft.Mashup.Engine1.Runtime.ConcatEnumerator`1.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.JoinAlgorithm.JoinPrologue.Read(JoinParameters parameters, Boolean readLeft, Boolean readRight)
at Microsoft.Mashup.Engine1.Language.Query.JoinAlgorithm.DynamicJoinAlgorithm.DynamicJoinEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.GroupQuery.GroupEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.ProjectColumnsQuery.SelectColumnsEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.ProjectColumnsQuery.SelectColumnsEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.ProjectColumnsQuery.SelectColumnsEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
at Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass11_0.<TryReportException>b__1()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass11_1`1.<OnBeginGetResult>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

[Anonymous]

Feedback Type:
Frown (Error)

Timestamp:
2019-02-20T01:11:21.3036917Z

Local Time:
2019-02-20T05:11:21.3036917+04:00

Session ID:
b8940983-7c7e-42fc-99c1-a79a1a75132b

Release:
February 2019

Product Version:
2.66.5376.1681 (19.02) (x64)

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Session guid does not match the started session guid. ---> System.ArgumentException: Session guid does not match the started session guid. ---> System.ArgumentException: Session guid does not match the started session guid.
at Microsoft.DataIntegration.FuzzyMatching.FuzzyLookupEntry.ContinueJoin(Guid sessionGuid, DataTable inputTable)
at Microsoft.Mashup.Engine1.Language.Query.FuzzyMatchingUtil.ExternalFuzzyMatchingUtil.ExecuteJoin(DataTable inputDataTable, DataTable referenceDataTable, DataTable transformationDataTable, FuzzyLookupParameters fuzzyJoinParameters, JoinType fuzzyJoinType, Guid sessionId, Boolean isFirst)
at Microsoft.Mashup.Engine1.Language.Query.FuzzyMatchingUtil.ExternalFuzzyMatchingUtil.ExecuteFuzzyJoin(IEngineHost host, DataTable inputDataTable, DataTable referenceDataTable, DataTable transformationDataTable, FuzzyJoinOptions fuzzyJoinOptions, JoinKind joinKind, Guid sessionId, Boolean isFirst)
at Microsoft.Mashup.Engine1.Language.Query.FuzzyMatchingUtil.GetNestedJoinOutputTable(IEngineHost host, RecordValue inputTableValue, Int32[] inputTableKeys, TableValue referenceTableValue, Int32[] referenceTableKeys, FuzzyNestedJoinParameters parameters, Guid sessionId, Boolean isFirst)
at Microsoft.Mashup.Engine1.Language.Query.IndexFuzzyNestedJoinAlgorithm.IndexFuzzyNestedJoinEnumerator.GetNestedTableValue(RecordValue leftRow, RecordValue rightKeyValue)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.IndexNestedJoinEnumerator.get_Current()
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.QueryEnumerator.get_Current()
at Microsoft.Mashup.Engine1.Runtime.TableValue.ValueReference2Enumerator.get_Current()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass11_0.<TryReportException>b__1()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass11_1`1.<OnBeginGetResult>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461808]

Peak Virtual Memory:
39.8 GB

Private Memory:
1.74 GB

Peak Working Set:
1.34 GB

IE Version:
11.590.17134.0

User ID:
ab80f365-7b8d-4dd3-b27f-fc05743e1b30

Workbook Package Info:
1* - en-US, Query Groups: 9, fastCombine: Enabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\dada\Microsoft\Power BI Desktop Store App\FrownSnapShot516400141.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_keyDrivers

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_showManageAggregations
PBI_qnaLiveConnect

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

@dadadance ,

What is your data source? Could you please share sample data of your tables so that I can reproduce?

Regards,
Lydia

[freder1ck]

I fixed this issue by turning off fuzzy matching.

[Anonymous]

I had the same problem in a query. When I make a fuzzy-match combine & afterwards I make a normal combine i can't expand the result of the last combination. If I do first the normal combination and then the fuzzy-match, I could.

Hope it helps you

CC: @Anonymous, @Anonymous, @freder1ck