topic Re: ole db or odbc error: [DataFormat.Error] OData: The in Developer

ole db or odbc error: [DataFormat.Error] OData: The

ksingla96 — Thu, 15 Jun 2017 12:24:26 GMT

ole db or odbc error: [DataFormat.Error] OData: The format 'application/json;charset=utf-8' is not supported.. error when trying to refresh the report?

Re: ole db or odbc error: [DataFormat.Error] OData: The

Eric_Zhang — Sun, 18 Jun 2017 06:20:32 GMT

ksingla96 wrote:

ole db or odbc error: [DataFormat.Error] OData: The format 'application/json;charset=utf-8' is not supported.. error when trying to refresh the report?

ksingla96

What is the datasource in your case? Do you get the error when clicking "refresh" button in Power BI desktop. Could you enable trace, reproduce the error and upload the log file?

Re: ole db or odbc error: [DataFormat.Error] OData: The

ksingla96 — Wed, 21 Jun 2017 04:33:00 GMT

Eric_Zhang

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

Re: ole db or odbc error: [DataFormat.Error] OData: The

sixtosentido — Wed, 05 Jul 2017 08:48:40 GMT

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

Re: ole db or odbc error: [DataFormat.Error] OData: The

steph_io — Thu, 22 Feb 2018 19:43:21 GMT

Has this been resolved? Do you have a work around?

Re: ole db or odbc error: [DataFormat.Error] OData: The

amitchauhan — Tue, 19 Jun 2018 13:37:05 GMT

Was this resolved ? I am having similar issues and not able to fix it. I have tried deleting the credentials as well. other list in the same site works fine. Just this list wont work. I need to find what is and where it is wrong. Any help in finding the root cause would be helpful.