ODBC connection not workinf since November update

[cmcubism]

Hi there,

after updating to the November relalease of Power BI desktop all of my ODBC connections in all of my workbooks won't refresh throwing the following error.

Kind regards

Christian

Feedback Type:
Frown (Error)

Timestamp:
2017-11-13T11:08:26.8157398Z

Local Time:
2017-11-13T12:08:26.8157398+01:00

Session ID:
190d19a8-62a5-41de-8b0f-260563560ac0

Release:
November 2017

Product Version:
2.52.4921.461 (PBIDesktop) (x64)

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. ---> 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 Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcConnectionHandle.GetInfo1(SQL_INFO info, Byte[] buffer)
   at Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcConnectionHandle.GetInfoInt32Unhandled(SQL_INFO info, Int32& resultValue)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcService.OdbcEngineConnection.GetInfoInt32(SQL_INFO infoType)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcFunctionCaching.GetResult[Output](UInt16 input, Func`3 function)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass8.<GetInfoInt32>b__7(IHostTrace trace)
   at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.GetInfoInt32(SQL_INFO infoType)
   at Microsoft.Mashup.Engine1.Library.Odbc.UserOverrideOdbcService.UserOverrideOdbcConnection.GetInfoInt32(SQL_INFO infoType)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSourceInfo.OdbcConnectionDataSourceInfo.GetInt32OrDefault(SQL_INFO infoType, Int32 defaultValue)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSourceInfo.OdbcMemoryDataSourceInfo..ctor(OdbcConnectionDataSourceInfo dataSourceInfo)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<get_Info>b__0(IOdbcConnection connection)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass9`1.<Connect>b__8()
   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.get_Info()
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass17.<ExecuteCore>b__12()
   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, ColumnConversion[] columnConversions)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteCoreDataReader(String commandText, IList`1 parameters, RowRange range, String[] columnNames, ColumnConversion[] columnConversions)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExecuteWithoutPaging(String commandText, IList`1 parameters, RowRange range, String[] columnNames, ColumnConversion[] columnConversions)
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.GetReaderCore()
   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcNativeQueryTableValue.get_Type()
   at Microsoft.Mashup.Engine1.Runtime.TableValue.Take(RowCount count)
   at Microsoft.Mashup.Engine1.Runtime.WrappingTableValue.Take(RowCount count)
   at Microsoft.Mashup.Engine1.Runtime.DelegatingTableValue.Take(RowCount count)
   at Microsoft.Mashup.Engine1.Runtime.TableValue.Take(Value countOrCondition)
   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame)
   at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(Value frame)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.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, Exception exception)
   at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWin32Window activeWindow, WindowsHost windowsHost, FeedbackPackageInfo feedbackPackageInfo, Exception e)
   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.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   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.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 de-DE)

CLR Version:
4.7 or later [Release Number = 461308]

Peak Virtual Memory:
35.4 GB

Private Memory:
602 MB

Peak Working Set:
922 MB

IE Version:
11.15.16299.0

User ID:
60278275-291d-4aec-b1f6-0d3ed70bf9db

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



shared #"DIM Date" = let
    Source = Odbc.Query("dsn=FB DWH 250", "--Date Dimension#(lf)select#(lf)dd.DIM_DATE_ID as ID,#(lf)dd.DIM_DATE_DATE as ""Date"",#(lf)dd.DIM_DATE_DAY as ""Day in Month"",#(lf)dd.DIM_DATE_YEARDAY as ""Day in Year"",#(lf)case#(lf)    when dd.DIM_DATE_WEEKDAY = 0 then 'Sunday'#(lf)    when dd.DIM_DATE_WEEKDAY = 1 then 'Monday'#(lf)    when dd.DIM_DATE_WEEKDAY = 2 then 'Tuesday'#(lf)    when dd.DIM_DATE_WEEKDAY = 3 then 'Wednesday'#(lf)    when dd.DIM_DATE_WEEKDAY = 4 then 'Thursday'#(lf)    when dd.DIM_DATE_WEEKDAY = 5 then 'Friday'#(lf)    when dd.DIM_DATE_WEEKDAY = 6 then 'Saturday'#(lf)end as ""Weekday"",#(lf)iif(dd.DIM_DATE_WEEKDAY = 0, 7, dd.DIM_DATE_WEEKDAY) as ""Weekday No."",#(lf)dd.DIM_DATE_WEEK as ""Week No."",#(lf)dd.DIM_DATE_YEARWEEK as ""Year and Week No."",#(lf)dd.DIM_DATE_MONTH_FULL as ""Month"",#(lf)dd.DIM_DATE_MONTH as ""Month No."",#(lf)dd.DIM_DATE_MONTH_UW as ""Month of U/W Year"",#(lf)dd.dim_date_year||lpad(dd.dim_date_month,2,0) as ""Month sort order"",#(lf)dd.DIM_DATE_QUARTER as ""Quarter"",#(lf)dd.DIM_DATE_YEAR as ""Busines Year"",#(lf)dd.DIM_DATE_UW_PERIOD as ""U/W Year"",#(lf)dd.DIM_DATE_UW_PERIOD_LLOYDS as ""U/W Period""#(lf)from dim_date dd#(lf)where dd.dim_date_date >= (select min(lra.real_valid_from) from lr_loss_records_analysis lra)#(lf)and dd.dim_date_date <= dateadd(year, 2, (select max(lra.real_valid_from) from lr_loss_records_analysis lra))#(lf)")
in
    Source;

[v-jiascu-msft]

Hi @cmcubism,

I can't reproduce it. 

1. What's the data source of the DSN?

2. When did the error happen? Open it or handle it ?

I would suggest you upgrade Desktop to the latest version first. There is a latest release. https://www.microsoft.com/en-us/download/details.aspx?id=45331.

Best Regards!

Dale

[cmcubism]

Hi Dale,

thank you for your reply.

I updated top the actual version, which is: 2.52.4921.581 64-bit (November 2017).

But the problem still remains.

The data source is a Firebird ODBC driver in the actual version 2.005. You can find it here:

https://firebirdsql.org/en/odbc-driver/

The error happens during the attempt to refresh the data.
It happens with the first query, but the advanced editor shows the same problem for all queries.

I have the same workbook working without any problems since weeks. Problems appeared with the November Update (08.11.2017). all of my other workbooks have the same problem, too.

Unfortunately our DWH is based on a Firebird DB, so this is pretty heavy for me.

Please tell me., if you need further info.

Kind regards from Hamburg

Christian

[cmcubism]

Hi there,

any news for me?

Kind regards

Christian

[v-jiascu-msft]

Hi Christian,

I have reproduced this issue. A report has been submitted to Product Team: CRI 51915523. I will posts latest information in time.

Best Regards!

Dale

[cmcubism]

Hi Dale,

that's great news, as I am working with outdated data in my reports since 06.11.2017 for the time being!

Thank you for your efforts.

Kind regards from the port of Hamburg

Christian

[v-jiascu-msft]

Hi Christian,

This issue will be fixed in the release December 2017. Please try it by then.

Best Regards!

Dale

[cmcubism]

Hi Dale,

great news! Thank you very much for your efforts.

Will do!

Kind regards

from Hamburg, Germany

Christian

[hrojasr]

Hi Dale,

When do you think the release December 2017 will be available to be downloaded?

I have a complete business solution stopped because of this incident.

Thank you.