Forum Discussion
Scheduled Refresh Error
Hi,
Running 15.0.2.378 on windows 2012. The server is configured with https to name like myservice.dev.mydomain.
When a user tries to schedule a data refresh, they get an error. Here is some logging. Thanks!
2018-04-04 09:58:06.0382|INFO|11|Received request POST /api/v2.0/CacheRefreshPlans| RequestID = s_70829b83-9912-483c-9d70-a6a8003b7d9d 2018-04-04 09:58:07.6320|ERROR|11|OData exception occurred: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'. The request failed with an empty response. at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol() at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol) --- End of inner exception stack trace --- at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.CreateCacheRefreshPlan(String itemPath, String description, String eventType, String matchData, ParameterValue[] parameters) at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass32.<CreateCacheRefreshPlan>b__31() at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func) at Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.CreateCacheRefreshPlan(IPrincipal userPrincipal, CacheRefreshPlan cacherefreshPlan) at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CacheRefreshPlansController.AddEntity(CacheRefreshPlan entity) at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Post(ODataPath oDataPath, T value) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext().| RequestID = s_70829b83-9912-483c-9d70-a6a8003b7d9d 2018-04-04 09:58:07.6476|INFO|6|Sending response. Response code DOMAIN\User 500, Elapsed time 0:00:01.6050009| RequestID = s_70829b83-9912-483c-9d70-a6a8003b7d9d
While working with a helpful Microsoft employee, we found an entry in a log file that permissions were needed on a subdirectory inside the powerbi dir. Once this was granted to the service account things are working.
19 Replies
- AnonymousNot applicable
Is the same dataset able to be refreshed using Power BI desktop?
- samgreene1Resolver II
Yes, the refresh works on PowerBI Desktop.
- adaveFrequent Visitor
Any ideas? I have attached the error we get. This was not happening in the Oct 2017 release. We are having this issue with the March 2018 version.
- giorgilomidzeResolver I
i had 4 times this problem. two times i just restarted report server, and 2 times it was about the sql data access problems. some data for bi user had no acces with tables thus couldnt be refreshed.
- samgreene1Resolver II
Giorgilomidze, Thanks for the ideas. I restared the service and tested the dataset, which is connecting to an on-prem data source and testing successfully.
- samgreene1Resolver II
We tested this on another power bi report server and are getting the same behavior. Looking for a fix soon, otherwise we will have to reinstall the old version.
- ey1020_parkFrequent Visitor
I resolved the issue by referring the page below.
https://github.com/microsoft/Reporting-Services/issues/166
1. rsreportserver.config -> set ReportServerUrl with domain address
2. entry in hosts file on the server
hope it helps.