Forum Discussion

samgreene1's avatar
samgreene1
Resolver II
8 years ago
Solved

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 

 

  • samgreene1's avatar
    samgreene1
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Is the same dataset able to be refreshed using Power BI desktop?

      • adave's avatar
        adave
        Frequent 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. 

  • 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. 

    • samgreene1's avatar
      samgreene1
      Resolver 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. 

      • samgreene1's avatar
        samgreene1
        Resolver 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.