cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samgreene1 Regular Visitor
Regular Visitor

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 

 

1 ACCEPTED SOLUTION

Accepted Solutions
samgreene1 Regular Visitor
Regular Visitor

Re: Scheduled Refresh Error

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.

View solution in original post

15 REPLIES 15
Ross73312 Super Contributor
Super Contributor

Re: Scheduled Refresh Error

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


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


samgreene1 Regular Visitor
Regular Visitor

Re: Scheduled Refresh Error

Yes, the refresh works on PowerBI Desktop.  

adave Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh Error

2018-04-09_8-01-35.png



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. 

stpnet Established Member
Established Member

Re: Scheduled Refresh Error

You might be able to get some detail on the underlying error using a query similar to the one mentioned in this post

 

 It might at least point you in the right direction. Trying to daignose this stuff form the web log files is just painful.

Re: Scheduled Refresh Error

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 Regular Visitor
Regular Visitor

Re: Scheduled Refresh Error

Thanks for the suggestion.  The subscription is not able to be created, so I don't think any history ends up in the table.  I had to modify that script for 2012 as it doesn't have any JSON functions, but there were no data refreshes with a LastStatus <> 'Completed 

data refresh'.

samgreene1 Regular Visitor
Regular Visitor

Re: Scheduled Refresh Error

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 Regular Visitor
Regular Visitor

Re: Scheduled Refresh Error

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.

Highlighted
Moderator mgmeyer
Moderator

Re: Scheduled Refresh Error

Hey @samgreene1, couple questions for you:

 

1. Is this a clean install of report server or are you upgrading/migrating a previous install?

2. It wasn't clear from the post are you getting the error when you try to create the schedule or when you try to execute and existing one?

3. Are you able to share with me the RSPortal_XXXXX.log with me view private message?

4. This did work previously with the Oct. release of PBIRS?

 

Also one thing you can try is create a URL reservation that is not https and see if you get the error there. Thanks!

 

Matt M.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 337 members 3,398 guests
Please welcome our newest community members: