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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.