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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JAVIER
New Member

Firebird ODBC Connection Error

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"}

4 REPLIES 4
arify
Microsoft Employee
Microsoft Employee

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
Community Champion
Community Champion

@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 ?

Hi @ankitpatira ! Which version of firebird did you use? 1.5 or 2.5?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors