Forum Discussion
ole db or odbc error: [DataFormat.Error] OData: The
The data source is Sharepoint lists and yes the error occurs after clicking 'refresh' button
DataMashup.Trace Information: 24579 : {"Start":"2017-06-19T05:03:13.0486318Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","HostProcessId":"9116","Exception":"Exception:\r\nExceptionType: System.IO.IOException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The process cannot access the file 'C:\\Users\\dell\\AppData\\Local\\Temp\\Power BI Desktop\\1bd8f44d-d832-46d8-9a51-5edb85b9848a\\Caches\\0b820d1e-d39b-4f96-9ceb-a5648de724ee\\a44c0631-7945-45ef-9fa1-0851e16feda7.dat' because it is being used by another process.\r\nStackTrace:\n at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n at System.IO.File.InternalDelete(String path, Boolean checkHost)\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, IEvaluationConstants evaluationConstants, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":10,"Duration":"00:00:00.0029686"}
DataMashup.Trace Error: 24579 : {"Start":"2017-06-19T05:03:12.9252151Z","Action":"Engine/IO/OData/GetResponse","HostProcessId":"9116","RequestUri":"http://apps.mydrreddys.com/sites/gg/OCMS/_vti_bin/ListData.svc/Observation?$select=ApplicableUnits,B...: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\r\nStackTrace:\n at System.Net.HttpWebRequest.GetResponse()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.2951614"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-06-19T05:03:12.8959829Z","Action":"Library/Common/RetryPolicy/TryExecuteAction","HostProcessId":"9116","Attempt":"1","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\r\nStackTrace:\n at System.Net.HttpWebRequest.GetResponse()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3250264"}
DataMashup.Trace Error: 24579 : {"Start":"2017-06-19T05:03:12.8959074Z","Action":"Library/Common/RetryPolicy/ExecuteAction","HostProcessId":"9116","TryCount":"3","RetryAlgorithm":"ExponentialBackoff","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\r\nStackTrace:\n at System.Net.HttpWebRequest.GetResponse()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3253228"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-06-19T05:03:12.8948810Z","Action":"Engine/IO/OData/GetResponseStream","HostProcessId":"9116","ResourceKind":"SharePoint","RequestUri":"http://apps.mydrreddys.com/sites/gg/OCMS/_vti_bin/ListData.svc/Observation?$select=ApplicableUnits,B...: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\r\nStackTrace:\n at System.Net.HttpWebRequest.GetResponse()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key)\r\n\r\n\r\n","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\r\nStackTrace:\n at System.Net.HttpWebRequest.GetResponse()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream()\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3267592"}
DataMashup.Trace Warning: 24579 : {"Start":"2017-06-19T05:03:12.8946927Z","Action":"Engine/IO/OData/CreateResult","HostProcessId":"9116","RequestUri":"http://apps.mydrreddys.com/sites/gg/OCMS/_vti_bin/ListData.svc/Observation?$select=ApplicableUnits,B...: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The remote server returned an error: (400) Bad Request.\r\nStackTrace:\n at System.Net.HttpWebRequest.GetResponse()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponse(WebRequest webRequest)\r\n at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.<>c__DisplayClass1.<GetResponseStream>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key)\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream()\r\n at Microsoft.Mashup.Engine1.Library.OData.V3.Http.GetResult(Uri uri, ODataEnvironment environment)\r\n at Microsoft.Mashup.Engine1.Library.OData.V3.RequestInfo.RequestResult()\r\n at Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.HandleVersionFallback[T](Func`1 function, Boolean throwOnBadRequest)\r\n at Microsoft.Mashup.Engine1.Library.OData.V3.RequestInfo.CreateResult()\r\n\r\n\r\n","ProductVersion":"2.46.4732.721 (PBIDesktop)","ActivityId":"4c306003-2f31-4b71-b50f-e52561eea7f1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5912,"Tid":1,"Duration":"00:00:00.3274921"}
Hi everyone and thanks in advance for your help,
I'm having the same error and I'm not able to find a solution. The error appears just for some sharepoint lists, and the refresh run OK for another one, so it looks like should be a problem with the list configuration (format of a field, bad data...)
I thought it might be related to Calculated Fields, but I've discarded that option since a list without those fields failed anyway.
This is the trace I'm getting. I've tried to understand it, but can't find any exceptions there.
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7108430Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0043369"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7232289Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.1859531"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9092181Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0000787"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9092398Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0001153"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9183152Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":7,"Duration":"00:00:00.0001030"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7232096Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.1922834"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7196222Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.1931997"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9128711Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0111725"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.7193559Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"1","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.2047311"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9245153Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000378"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9617099Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0073147"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9690578Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000513"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9778989Z","Action":"SqlTranslator/SqlParser/Parse","SQL":"SELECT * FROM [Logs]","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0016327"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9796941Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000303"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9796842Z","Action":"SqlExpressionTranslator/Translate","IsRecognized":"True","Result":"(database) => Table.RenameColumns(Table.PrefixColumns(database[Logs], \"Logs\"), {{\"Logs.Log File\", \"Log File\"}, {\"Logs.Log File Date\", \"Log File Date\"}, {\"Logs.Level\", \"Level\"}, {\"Logs.Trace Id\", \"Trace Id\"}, {\"Logs.Date\", \"Date\"}, {\"Logs.Action.1\", \"Action.1\"}, {\"Logs.Action.2\", \"Action.2\"}, {\"Logs.Action.3\", \"Action.3\"}, {\"Logs.Action.4\", \"Action.4\"}, {\"Logs.Action.5\", \"Action.5\"}, {\"Logs.Action.6\", \"Action.6\"}, {\"Logs.Action Detail\", \"Action Detail\"}, {\"Logs.ProductVersion\", \"ProductVersion\"}, {\"Logs.ActivityId\", \"ActivityId\"}, {\"Logs.Process\", \"Process\"}, {\"Logs.Pid\", \"Pid\"}, {\"Logs.Tid\", \"Tid\"}, {\"Logs.Duration\", \"Duration\"}, {\"Logs.DbProviderName\", \"DbProviderName\"}, {\"Logs.Exception\", \"Exception\"}, {\"Logs.CommandText\", \"CommandText\"}, {\"Logs.ResponseFieldCount\", \"ResponseFieldCount\"}, {\"Logs.EvaluationId\", \"EvaluationId\"}, {\"Logs.Log Id\", \"Log Id\"}, {\"Logs.Hour\", \"Hour\"}})","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0604325"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:17.0401635Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000459"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9690541Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0715959"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:17.0406693Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000287"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9617025Z","Action":"SimpleDocumentEvaluator/GetResult<IDataReaderSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:09.8263895"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9612307Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource>","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:00.0794911"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:17.0407616Z","Action":"RemotePageReader/RunStub","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:10.1056506"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:16.9610941Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"2","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"11b58479-d648-44a9-9a74-5ce52d597b14","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":1,"Duration":"00:00:10.1853333"}
DataMashup.Trace Information: 24579 : {"Start":"2017-07-05T08:30:27.1466186Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.41.4581.361 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10132,"Tid":4,"Duration":"00:00:00.0000984"}
Has this been resolved? Do you have a work around?
