locked
Error - An entry with the same key already exists RRS feed

  • Question

  • Hi,

    I'm a business user for Power Query and I have tools that connect to Oracle database. They used to work fine, but suddenly I get the error below when trying to connect to any table in a specific schema in the Oracle database.

    What might be causing the problem? I have investigated and nothing has been changed in the Oracle database. Could this be related to some update?

    I have Office 2010 32bit version 14.0.7153.5000 and Power Query version is 2.18.3874.242.

    Error that I get:

    Error Message:

    An entry with the same key already exists.

    Stack Trace:

       at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
       at System.Collections.Generic.TreeSet`1.AddIfNotPresent(T item)
       at System.Collections.Generic.SortedDictionary`2.Add(TKey key, TValue value)
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadCatalog()
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateCatalogTableValue(IEngineHost host)
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateTable()
       at Microsoft.Mashup.Engine1.Library.Oracle.OracleModule.DatabaseFunctionValue.TypedInvoke(TextValue server, Value options)
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression1.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key)
       at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
       at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args)
       at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression.Execute(MembersFrame0& frame)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
       at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key)
       at Microsoft.Mashup.Engine1.Runtime.Library.List.ElementWithListCheckFunctionValue.Invoke(Value collection, Value key)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(MembersFrame1& frame)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value frame)
       at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(MembersFrame0& frame)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
       at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args)
       at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageContext context, BeginGetPreviewValueSourceMessage message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClass9`1.<AddHandler>b__7(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.ContextMessenger.ContextMessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.ContextMessenger.OnMessageWithUnknownContext(IMessageContext baseContext, MessageWithUnknownContext messageWithUnknownContext)
       at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClass9`1.<AddHandler>b__7(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.ContextMessenger.ContextMessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageContext context, 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.Interface.EvaluationResult2`1.get_Result()
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageContext context, BeginGetPreviewValueSourceMessage message)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result()
       at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Invocation Stack Trace:

       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.<>c__DisplayClassb.<OnAjaxException>b__a()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass15.<Post>b__14(Object null)
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Delegate.DynamicInvokeImpl(Object[] args)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       at System.Threading.ExecutionContext.runTryCode(Object userData)
       at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.RunDialog(Form form)
       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
       at Microsoft.Mashup.Client.Excel.EditorManager.ShowModalEditor(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, BaseEditorDialogParameters editorDialogInitializationContext, Queries queries, Action`1 viewInitializer)
       at Microsoft.Mashup.Client.Excel.EditorManager.ShowModalEditor(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, BaseEditorDialogParameters initializationContext, Queries queries)
       at Microsoft.Mashup.Client.Excel.DialogManager.EditNewQuery(Query query, IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, JsonUpdate builderResults, Boolean isBlankQuery)
       at Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnImportSuccess(IEnumerable`1 importedQueries, DataImportDestination destination)
       at Microsoft.Mashup.Client.ClientShared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID)
       at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c__DisplayClass17.<OnQuerySettingsResolved>b__13(PreviewResult preview)
       at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c__DisplayClass11.<PrepareQueryAndShowStatus>b__10(PreviewResultPollingResultCode resultCode, PreviewResult previewResult)
       at Microsoft.Mashup.Client.ClientShared.PreviewResultPolling.InvokeCallback(PreviewResultPollingResultCode resultCode, PreviewResult previewResult)
       at Microsoft.Mashup.Client.ClientShared.PreviewResultPolling.<GetPreviewResult>b__3()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Client.ClientShared.PreviewResultPolling.GetPreviewResult(Object sender, EventArgs e)
       at System.Windows.Forms.Timer.OnTick(EventArgs e)
       at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.RunDialog(Form form)
       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.SimpleDialog.StatusDialog.ShowStatusDialog(IWin32Window owner, Action cancelCallback, Nullable`1 showTimeout)
       at Microsoft.Mashup.Client.ClientShared.PreviewResultPolling.<>c__DisplayClass5.<InitializeStatusDialog>b__4()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass15.<Post>b__14(Object null)
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Delegate.DynamicInvokeImpl(Object[] args)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       at System.Threading.ExecutionContext.runTryCode(Object userData)
       at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    Friday, October 9, 2015 2:05 PM

Answers