Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
JackNewson
New Member

Unexpected error: Attempted to read or write protected memory.

Hi all

 

after the last update one of my reports now will not refresh the data..

 

it is using a 32bit ODBC connection

 

any help would be greatfully received

 

Kindest regards

 

J

 

Unexpected error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Details:
    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.
   at Microsoft.Mashup.Engine1.Library.Odbc.Interop.NativeMethods.SQLColAttributeW(OdbcStatementHandle StatementHandle, UInt16 ColumnNumber, UInt16 FieldIdentifier, OdbcBuffer CharacterAttribute, Int16 BufferLength, Int16& StringLength, IntPtr& NumericAttribute)
   at Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcStatementHandle.GetColumnAttribute(Int32 columnNumber, UInt16 fieldIdentifier, OdbcBuffer characterAttribute, Int16& stringLength, Int64& numericAttribute)
   at Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcStatementHandle.TryGetColumnAttribute(Int32 columnNumber, SQL_DESC v3FieldId, SQL_COLUMN v2FieldId, OdbcBuffer buffer, Int16& resultLength)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.GetMetadata(Boolean supportsBindCol, SQL_GD getDataExtensions, OdbcStatementHandle statement, DataTable& schemaTable, FetchPlan& fetchPlan)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcService.OdbcEngineConnection.GetPageReader(OdbcStatementHandle statement, RowRange rowRange, OdbcBuffer parameterBuffer)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcService.OdbcEngineConnection.ExecuteDirect(String commandText, IList`1 parameters, RowRange rowRange)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.ExecuteDirect(String commandText, IList`1 parameters, RowRange rowRange)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClassf.<ExecuteDirect>b__e(IHostTrace trace)
   at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.ExecuteDirect(String commandText, IList`1 parameters, RowRange rowRange)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass17.<ExecuteCore>b__16()
   at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)
   at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteCore(String commandText, IList`1 parameters, RowRange rowRange, String[] columnNames)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteCoreDataReader(String commandText, IList`1 parameters, RowRange range, String[] columnNames)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteWithoutPaging(String commandText, IList`1 parameters, RowRange range, String[] columnNames)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.GetReaderCore()
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.get_Type()
   at Microsoft.Mashup.Engine1.Runtime.TableValue.get_Columns()
   at Microsoft.Mashup.Engine1.Runtime.DelegatingTableValue.get_Columns()
   at Microsoft.Mashup.Engine1.Runtime.DelegatingTableValue.get_Columns()
   at Microsoft.Mashup.Engine1.Runtime.TableValue.SelectColumns(Value columns, Boolean ignoreMissing)
   at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.SelectColumnsFunctionValue.TypedInvoke(TableValue table, Value columns, Value missingField)
   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1)
   at Microsoft.Mashup.Engine1.Runtime.FunctionValue.MetaTypeFunctionValue.Invoke(Value arg0, Value arg1)
   at Microsoft.Mashup.Engine1.Runtime.SerializationApplyingModule.SerializableFunctionValue.Invoke(Value arg0, Value arg1)
   at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.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.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.FunctionInvocationExpression2.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.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.Expression.Execute(Value frame, Expression[] expressions)
   at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression.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.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.FirewallPartition.BeginGetResult[T](Action`1 callback)
   at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
   at Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List`1 partitionsToBuffer, Int32 nextPartition, Action`1 callback)
   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.FirewallDocumentEvaluator.BeginGetResult(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.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message 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.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message 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.EvaluationHost.Run()
   at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
   at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__0(Object o)
   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(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.Evaluator.SafeThread2.<>c__DisplayClass2.<CreateThreadStart>b__1(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.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel channel, ExceptionMessage message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message 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.<>c__DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message 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.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
   at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
   at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
   at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
   at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

3 REPLIES 3
pqian
Microsoft Employee
Microsoft Employee

@JackNewson It would help if we can know what ODBC driver you are using for this query. Can you open the problematic workbook, and use the "Send a Frown" option to report this? Make sure you include the formula.

 

It looks like the access violation is in the driver.

unfortunately the server that the Bi application on doesn't have a mail client to email is there a way of accessing the information required?

 

the ODBC driver is sage 50 v19  

Greg_Deckler
Community Champion
Community Champion

I would recommend sending this information to support, https://support.powerbi.com and use the "Contact Us" link.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.