locked
Trying to connect to MySQL Table throws "The given key was not present in dictionary" RRS feed

  • Question

  • When I connect to our MySQL database, the navigator opens up, when I then try to load a specific table, I get the following error message:

    Unexpected error: The given key was not present in the dictionary.
    Details:
        Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
       at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
       at Microsoft.Mashup.Engine1.Library.Common.NavigationPropertiesHelper.TargetLinkInfo.get_Table()
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue0`1.Invoke()
       at Microsoft.Mashup.Engine1.Language.Query.NestedJoinQuery.get_RightTable()
       at Microsoft.Mashup.Engine1.Language.Query.NestedJoinQuery.NestedJoinRecordType.get_Nullable()
       at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.GetColumnType(Int32 column)
       at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.GetColumnType(Int32 column)
       at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.GetColumnType(Int32 column)
       at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.<>c__DisplayClass1.<get_Type>b__0(Int32 recordTypeIndex)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.Microsoft.Mashup.Engine.Interface.IRecordValue.get_Item(String index)
       at Microsoft.Mashup.Evaluator.Services.ValueSerializer.WriteCustomRecordType(IRecordTypeValue recordType, AllowCustomTypes allowCustomTypes)
       at Microsoft.Mashup.Evaluator.Services.ValueSerializer.FinishWriting()
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
       --- End of inner exception stack trace ---
       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.Host.EvaluationContainer.EvaluationContainerMain.Run(String[] args)
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Main(String[] args)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.OnEvaluationException(IMessageChannel channel, EvaluationExceptionMessage 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.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.PreviewValueSource.<>c__DisplayClass7.<WaitForSerializedValue>b__6()
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.TranslateCancelExceptions(Action action)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.PreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Any idea what the problem is?

    Wednesday, April 15, 2015 4:35 PM

Answers

  • Do you get the same error when you do a refresh?

    If so, the problem is likely because we're making a mistake in reading the system catalogs. How many tables are in this particular database?

    Wednesday, April 15, 2015 10:07 PM

All replies

  • Do you get the same error when you do a refresh?

    If so, the problem is likely because we're making a mistake in reading the system catalogs. How many tables are in this particular database?

    Wednesday, April 15, 2015 10:07 PM
  • Hi Mustikah,

    If you're still experiencing this issue, could you kindly provide answers to Curt's questions.


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Wednesday, April 29, 2015 8:46 AM
  • Hi

    I am getting this issue with Power Query in Office 2016... Any help for this?

    Friday, October 23, 2015 11:41 AM