Forum Discussion

szablock's avatar
szablock
Helper I
9 years ago

Get data from SQL database

I try to get date from sql and I got that information     Slawek
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi szablock,

Please firstly install SQL Server Management Studio(SSMS) on the same machine that have Power BI Desktop installed, then use SSMS to connect to the SQL Server and check if it is successful.

If there is no connection  issue using SSMS, please go to File -> Options and settings -> Options -> Diagnostics in Power BI Desktop and click "enable tracing", then connect to SQL Server database and check the detailed logs in the traces folder. Also please help to post the detailed logs here.


Thanks,
Lydia Zhang

  • szablock's avatar
    szablock
    Helper I
    9 years ago

    Log contetnt

     

    DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9370495Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":4,"Duration":"00:00:00.0004806"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9409176Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0158829"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9568545Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0000915"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9568742Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":4,"Duration":"00:00:00.0001203"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9569628Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":7,"Duration":"00:00:00.0052352"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9575178Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0617715"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.0224864Z","Action":"Engine/IO/Db/SQL/ProcessException","Exception":"Exception:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0003964"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.0209194Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0020341"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.0209044Z","Action":"Engine/IO/Db/Microsoft SQL/ExecuteReader","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at

     

    Regards

    Slawek

    • szablock's avatar
      szablock
      Helper I
      9 years ago

      Part 2

       

      Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0022909"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.0209004Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0023722"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-12-14T12:27:30.0208873Z","Action":"Engine/IO/Db/Microsoft SQL/NativeQueryTableValue/Execute","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Execute(String commandText, CommandBehavior commandBehavior, Value parameters)\r\n   at Microsoft.Mashup.Engine1.Library.Common.NativeQueryTableValue.Execute(ConnectionReader connectionReader)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0025505"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.0246686Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0819116"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.1091270Z","Action":"Engine/IO/Db/SQL/ProcessException","Exception":"Exception:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0000832"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.1069623Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0023916"}
DataMashup.Trace Error: 24579 : {"Start":"2016-12-14T12:27:30.1069532Z","Action":"Engine/IO/Db/Microsoft SQL/ExecuteReader","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0024958"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.1069496Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0025374"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-12-14T12:27:30.1069350Z","Action":"Engine/IO/Db/Microsoft SQL/NativeQueryTableValue/Execute","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] An error happened while reading data from the provider: 'System.IO.FileLoadException'\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<>c__DisplayClass1.<Execute>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.Execute(String commandText, CommandBehavior commandBehavior, Value parameters)\r\n   at Microsoft.Mashup.Engine1.Library.Common.NativeQueryTableValue.Execute(ConnectionReader connectionReader)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0026552"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9409070Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.1686963"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9381723Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.0187963"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9569854Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.1527751"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:29.9381052Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"49","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"0bfe596e-9c37-4575-9f23-ef0d29b941e7","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":1,"Duration":"00:00:00.1716837"}
DataMashup.Trace Information: 24579 : {"Start":"2016-12-14T12:27:30.1097587Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.40.4554.463 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":31808,"Tid":4,"Duration":"00:00:00.0000408"}

      Regards

       

      Slawek

      • szablock's avatar
        szablock
        Helper I
        9 years ago

        Any clue ?