Attempted to read or write protected memory. This is often an indication that other memory is corrupt

• Question

• 

  

  0

  Sign in to vote

  Trying to refresh a Power Query connection. 

  The Data Model table couldn't be refreshed:
  We couldn't refresh the connection 'Query - qry_results_OCHA_stp1_NES'. Here's the error message we got:

  Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

  Feedback Type:
  Frown (Error)

  Timestamp:
  2018-05-28T19:00:01.5005463Z

  Local Time:
  2018-05-28T22:00:01.5005463+03:00

  Product Version:
  2.49.4831.381 (PQ-CY17SU08) (x64)

  Release:
  August 2017

  Excel Version:
  16.0.8431.2250

  Excel Install Location:
  C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE

  IE Version:
  11.1088.15063.0

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

  CLR Version:
  4.6.2. or later [Release Number = 460798]

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

  Peak Working Set:
  854 MB

  Private Memory:
  696 MB

  Peak Virtual Memory:
  2.03 TB

  Error Message:
  Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

  Stack Trace:
  Microsoft.Mashup.Evaluator.Interface.ErrorException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. ---> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. ---> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
     at System.Data.Common.UnsafeNativeMethods.IDBSchemaRowset.GetRowset(IntPtr pUnkOuter, Guid& rguidSchema, Int32 cRestrictions, Object[] rgRestrictions, Guid& riid, Int32 cPropertySets, IntPtr rgPropertySets, IRowset& ppRowset)
     at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
     at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
     at System.Data.OleDb.OleDbMetaDataFactory.PrepareCollection(String collectionName, String[] restrictions, DbConnection connection)
     at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConnection connection, String collectionName, String[] restrictions)
     at System.Data.OleDb.OleDbConnection.GetSchema(String collectionName, String[] restrictionValues)
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.<>c__DisplayClass44.<GetSchemaTable>b__40()
     at Microsoft.Mashup.Engine1.Library.Access.AccessEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.GetSchemaTable(Func`2 loader, Boolean openConnection, String collectionName, String[] restrictions)
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.GetTables()
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.<GetTableTypes>d__8.MoveNext()
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadTypeCatalog()
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadCatalog()
     at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.get_NavigationPropertiesRecord()
     at Microsoft.Mashup.Engine1.Library.Common.DbCatalogTableValue.GetEnumerator()
     at Microsoft.Mashup.Engine1.Language.Query.SelectRowsQuery.SelectRowsEnumerable.GetEnumerator()
     at Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()
     at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
     at Microsoft.Mashup.Engine1.Runtime.TableValue.TryGetValue(Value key, Value& value)
     at Microsoft.Mashup.Engine1.Runtime.TableValue.get_Item(Value key)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression2.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.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.Language.ExpressionInvocationExpression2.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.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.Language.ExpressionInvocationExpression2.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.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.Language.ExpressionInvocationExpression2.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.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.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.Language.Linker.AssemblyRecordValue.get_Item(Int32 index)
     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.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.Language.ExpressionInvocationExpression1.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.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.SqlTranslator.SqlExpressionTranslator.SqlToMTranslator.NewNamedTableReference(Identifier alias, MultiPartIdentifier table)
     at Microsoft.Mashup.SqlTranslator.SqlExpressionVisitor`2.VisitFromClause(FromClause from)
     at Microsoft.Mashup.SqlTranslator.SqlExpressionVisitor`2.VisitQuerySpecification(QuerySpecification querySpec)
     at Microsoft.Mashup.SqlTranslator.SqlExpressionTranslator.SqlToMTranslator.Translate(QueryExpression query)
     at Microsoft.Mashup.SqlTranslator.SqlExpressionTranslator.TranslateSelectStatement(StringBuilder sb, SelectStatement select)
     at Microsoft.Mashup.SqlTranslator.SqlExpressionTranslator.Translate(SelectStatement select)
     at Microsoft.Mashup.SqlTranslator.SqlExpressionTranslator.Translate(SqlParseResult parseResult)
     at Microsoft.Mashup.Engine1.Library.SqlExpression.SqlExpressionModule.ToExpressionFunctionValue.TypedInvoke(TextValue sql, RecordValue environment)
     at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression1.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression1.Execute(MembersFrame1& frame)
     at Microsoft.Mashup.Engine1.Language.DebugExpression.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.Language.MembersFunctionValue0.Invoke()
     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.FirewallPartition.BeginGetResult[T](Action`1 callback)
     at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
     at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
     at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
     at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
     at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
     at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetDataReaderSource(IMessageChannel channel, BeginGetDataReaderSourceMessage 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__DisplayClass15.<CreateAction>b__14(Object o)
     --- End of inner exception stack trace ---
     at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass7.<TryReportException>b__6()
     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.TryHandleException(Exception exception)
     at Microsoft.Mashup.Evaluator.SafeThread2.HandleException(Exception e)
     at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(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.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.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
     at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()
     at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunk()
     at Microsoft.Mashup.Evaluator.ChunkedInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)
     at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
     at System.IO.BinaryReader.ReadInt32()
     at Microsoft.Mashup.Evaluator.ITableSourceSerializationExtensions.ReadITableSource(BinaryReader reader)
     at Microsoft.Mashup.Evaluator.RemotePageReader.CreateProxy(IEngineHost engineHost, IMessageChannel channel, ExceptionHandler exceptionHandler)
     at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.DataReaderSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
     at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
     --- End of inner exception stack trace ---
     at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)
     at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
     at Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
     at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
     at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
     at System.Threading.ThreadHelper.ThreadStart(Object obj)
     --- End of inner exception stack trace ---

  Server stack trace:

  
  Exception rethrown at [0]:
     at Microsoft.OleDb.AsyncResult`1.get_Value()
     at Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)

  Exception rethrown at [1]:
     at Microsoft.OleDb.AsyncResult`1.get_Value()
     at Microsoft.Mashup.OleDbProvider.MashupRowset.get__Rowset()
     at Microsoft.OleDb.Rowset.Microsoft.OleDb.IRowset.AddRefRows(DBCOUNTITEM cRows, HROW* nativeRows, UInt32* nativeRefCounts, DBROWSTATUS* nativeRowStatus)
     at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IRowset.AddRefRows(DBCOUNTITEM cRows, HROW* nativeRows, UInt32* nativeRefCounts, DBROWSTATUS* nativeRowStatus)

  Invocation Stack Trace:
     at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
     at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
     at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
     at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
     at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
     at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
     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.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     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.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
     at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
     at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
     at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
     at Microsoft.Office.PowerPivot.BackEnd.IProgressCallback.Event(ProgressType type, Boolean cancellable, Int64 numberOfRows)
     at Microsoft.Office.PowerPivot.BackEnd.ProgressReporter.RaiseEvent(ProgressType type)
     at Microsoft.AnalysisServices.BackEnd.BackgroundEngineThread.DoWork(WaitCallback workCode, Object parameter)
     at Microsoft.Office.PowerPivot.BackEnd.PowerPivotFacade.RefreshExternalTables(String[] tableNames, Int32 txStage)
     at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
     at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
     at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
     at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args)
     at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2R.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.RefreshConnectionObject(IntPtr workbookPointer, String connectionName)
     at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookConnection.TryRefresh()
     at Microsoft.Mashup.Client.Excel.ConnectionManager.<>c__DisplayClass1c.<RefreshQueryConnection>b__1b()
     at Microsoft.Mashup.Client.Excel.Shim.NativeSafeInvoker.Invoke[T](Func`1 func)
     at Microsoft.Mashup.Client.Excel.ConnectionManager.RefreshQueryConnection(IWorkbook workbook, Query query)
     at Microsoft.Mashup.Client.Excel.Fill.FillManager.StartRefreshFill(IWin32Window ownerWindow, IWorkbook workbook, Query query)
     at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
     at Microsoft.Mashup.Client.Excel.ExcelQueryServices.TryInvokeOnWorkbookEnsureConnections(Action`1 action)
     at Microsoft.Mashup.Client.ClientShared.Ux.Navigator.QueriesNavigatorModelBase.InvokeWithQueryFromNode(TreeNode node, Action`1 action)
     at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
     at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
     at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
     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.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     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.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

  
  Supports Premium Content:
  True

  Formulas:

  
  section Section1;

  shared qry_results_OCHA_stp1_Dam_SO1 = let
      Source = Access.Database(File.Contents("C:\Users\udaraz\Documents\Master_DataBase\WASH_HRPs_4WS_V01.accdb"), [CreateNavigationProperties=true]),
      _qry_results_OCHA_stp1_Dam_SO1 = Source{[Schema="",Item="qry_results_OCHA_stp1_Dam_SO1"]}[Data]
  in
      _qry_results_OCHA_stp1_Dam_SO1;

  shared qry_results_OCHA_stp1_Dam_SO2 = let
      Source = Access.Database(File.Contents("C:\Users\udaraz\Documents\Master_DataBase\WASH_HRPs_4WS_V01.accdb"), [CreateNavigationProperties=true]),
      _qry_results_OCHA_stp1_Dam_SO2 = Source{[Schema="",Item="qry_results_OCHA_stp1_Dam_SO2"]}[Data]
  in
      _qry_results_OCHA_stp1_Dam_SO2;

  shared qry_results_OCHA_stp1_Gzt = let
      Source = Access.Database(File.Contents("C:\Users\udaraz\Documents\Master_DataBase\WASH_HRPs_4WS_V01.accdb"), [CreateNavigationProperties=true]),
      _qry_results_OCHA_stp1_Gzt = Source{[Schema="",Item="qry_results_OCHA_stp1_Gzt"]}[Data]
  in
      _qry_results_OCHA_stp1_Gzt;

  shared qry_results_OCHA_stp1_Jod = let
      Source = Access.Database(File.Contents("C:\Users\udaraz\Documents\Master_DataBase\WASH_HRPs_4WS_V01.accdb"), [CreateNavigationProperties=true]),
      _qry_results_OCHA_stp1_Jod = Source{[Schema="",Item="qry_results_OCHA_stp1_Jod"]}[Data]
  in
      _qry_results_OCHA_stp1_Jod;

  shared qry_results_OCHA_stp1_NES = let
      Source = Access.Database(File.Contents("C:\Users\udaraz\Documents\Master_DataBase\WASH_HRPs_4WS_V01.accdb"), [CreateNavigationProperties=true]),
      _qry_results_OCHA_stp1_NES = Source{[Schema="",Item="qry_results_OCHA_stp1_NES"]}[Data]
  in
      _qry_results_OCHA_stp1_NES;

  shared Append1 = let
      Source = Table.Combine({qry_results_OCHA_stp1_Dam_SO1, qry_results_OCHA_stp1_Dam_SO2, qry_results_OCHA_stp1_Gzt, qry_results_OCHA_stp1_Jod, qry_results_OCHA_stp1_NES})
  in
      Source;

  shared Table1 = let
      Source = Excel.Workbook(File.Contents("C:\Users\udaraz\Documents\GIS\Syria\AOI_DATA\locality_aoi_20180505.xlsx"), null, true),
      Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data],
      #"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"admin0Name_en", type text}, {"admin0Name_ar", type text}, {"admin0Pcode", type text}, {"admin1Name_en", type text}, {"admin1Name_ar", type text}, {"admin1Pcode", type text}, {"admin2Name_en", type text}, {"admin2Name_ar", type text}, {"admin2Pcode", type text}, {"admin3Name_en", type text}, {"admin3Name_ar", type text}, {"admin3Pcode", type text}, {"admin4Name_en", type text}, {"admin4Name_ar", type text}, {"admin4Pcode", type text}, {"admin4RefName_en", type text}, {"admin4RefName_ar", type text}, {"Latitude", type number}, {"Longitude", type number}, {"Actor_Type", type text}, {"Date_AOI", type date}})
  in
      #"Changed Type";

  Monday, May 28, 2018 7:00 PM