Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"}
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?
@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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |