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

  • General discussion

  • Feedback Type:
    Frown (Error)

    Timestamp:
    2018-05-28T10:53:49.8238269Z

    Local Time:
    2018-05-28T13:53:49.8238269+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.413.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:
    652 MB

    Private Memory:
    535 MB

    Peak Virtual Memory:
    2.03 TB

    Error Message:
    Attempted to read or write protected memory. This is often an indication that <g class="gr_ gr_82 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="82" id="82">other</g> memory is corrupt.

    Stack Trace:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: Attempted to read or write protected memory. This is often an indication that <g class="gr_ gr_84 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="84" id="84">other</g> memory is corrupt. ---> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that <g class="gr_ gr_86 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="86" id="86">other</g> memory is corrupt. ---> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that <g class="gr_ gr_88 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="88" id="88">other</g> 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.FunctionInvocationExpression2.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.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.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.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.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.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.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__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.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
       at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
       at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
       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.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.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       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)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       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.Form.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass5.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
       at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.InvokeDeferredStorageAction(IWorkbook workbook, Action`1 action)
       at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
       at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
       at Microsoft.Mashup.Client.Excel.DialogManager.TryShowModalEditor(IWin32Window ownerWindow, IWorkbook workbook, Query query, Boolean isNewQuery, Boolean navigatorExpanded)
       at Microsoft.Mashup.Client.Excel.ExcelRibbonHandler.<>c__DisplayClass43.<OnShowEditorAction>b__42(IWorkbook workbook)
       at Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
       at Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass1.<OnRibbonButtonAction>b__0()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Client.Excel.ExcelCallbackManager.InvokeAndReturnHResult(Action action)


    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 11:02 AM