Re: Firebird ODBC Connection Error

JAVIER · ‎03-22-2016

Hi I am getting Error to connect with Firebird ODBC, this is the follow-up, could help ?, Thanks.

DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1724889Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0008407"}
DataMashup.Trace Error: 24579 : {"Start":"2016-03-22T14:48:29.1749686Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","Attempt":"0","MaxAttempt":"0","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0124140"}
DataMashup.Trace Error: 24579 : {"Start":"2016-03-22T14:48:29.1749521Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0129723"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1749118Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0130825"}
DataMashup.Trace Error: 24579 : {"Start":"2016-03-22T14:48:29.1748870Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.InvokeWithoutRetry(Action action)\r\n en Microsoft.Mashup.Engine1.Library.Common.ProgressPageReader.Read(IPage page)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0163615"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-03-22T14:48:28.9102428Z","Action":"RemotePageReader/RunStub","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.InvokeWithoutRetry(Action action)\r\n en Microsoft.Mashup.Engine1.Library.Common.ProgressPageReader.Read(IPage page)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.InvokeWithoutRetry(Action action)\r\n en Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__0()\r\n en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.2861357"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:28.6472857Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"1","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.5491984"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1968435Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","Exception":"Exception:\r\nExceptionType: System.IO.FileNotFoundException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: No se pudo encontrar el archivo 'C:\\Users\\Administrador\\AppData\\Local\\Temp\\2\\Power BI Desktop\\166946bb-142f-458a-be30-c0aa085df3d6\\Caches\\e32f5885-9b87-4beb-a47b-1a55dd44aa91\\e6395229-70f9-4d4a-9115-6718c26e4a23.dat'.\r\nStackTrace:\n en System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n en System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)\r\n en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)\r\n en System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)\r\n en System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)\r\n en Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n en Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, Nullable`1 activityId, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0003591"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1972554Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0014135"}

arify · ‎05-16-2016

Hi @JAVIER, we've done a related fix recently, it will be out in the next release. Can you check if the next PBI Desktop still has the same issue when it gets released?

ankitpatira · ‎04-18-2016

@JAVIER I have successfully connected to firebird using firebird odbc in power bi desktop. Make sure you are using latest versin of PBI desktop. Have you checked your ODBC connection and make sure it is working. In PBI desktop are you using ODBC connector ? And then entering connection string or you have created DSN ?