Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

obesli

Schedule problem

Submitted by on ‎01-23-2019 12:23 AM

Hi,

 

I'm using PBIRS reporting server and there is existing schedules for my report. Exisiting schedules work without problem but, when I want to edit the existing schedule or add new one I got this error "I got Something went wrong. Please try again later.".

 

I couldn't find any information about this, what is the source of this error?

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎01-23-2019 07:22 PM

@obesli,

What version of Power BI report server do you use and what is your data source? I am unable to reproduce this issue on my side.

Please take a look at the ReportingServicesServiceXXXX.log and RSPortalXXXX.log in the following folder and share detailed logs here:

C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles



Regards,
Lydia

Anonymous
Not applicable
‎01-23-2019 07:22 PM
 
obesli
Frequent Visitor
‎01-23-2019 09:39 PM

Hi,

 

In the report I use sharepoint and excel data sources. Log files are:

 

RSPortalXXXX.log

 

2019-01-23 10:44:25.5863|ERROR|10|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.SetCacheRefreshPlanProperties(String cacheRefreshPlanId, String description, String eventType, String matchData, ParameterValue[] parameters)

   at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass35.<SetCacheRefreshPlanProperties>b__34()

   at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.<>c__DisplayClass1.<ExecuteWithCorrespondingAuthMechanism>b__0()

   at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)

   at Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.UpdateCacheRefreshPlan(IPrincipal userPrincipal, Guid key, CacheRefreshPlan plan)

   at Microsoft.ReportingServices.Portal.ODataWebApi.V1.Controllers.CacheRefreshPlanController.PutEntity(String key, CacheRefreshPlan entity)

   at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Put(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_25176c6d-33c8-45d0-a84b-d2e0c83f4323

 

 

ReportingServicesServiceXXXX.log

 

 

appdomainmanager!DefaultDomain!1fac!01/24/2019-08:34:42:: e ERROR: AppDomain ReportServer_PBIRS_0 failed to start. Error: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280)

library!DefaultDomain!1fac!01/24/2019-08:34:42:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_PBIRS_0. ---> System.Web.HttpException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)

   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)

   at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)

   at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)

   at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)

   --- End of inner exception stack trace ---

   at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)

   at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement)

   at System.Web.Configuration.HealthMonitoringSectionHelper.BasicSanityCheck()

   at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()

   at System.Web.Configuration.HealthMonitoringSectionHelper.GetHelper()

   at System.Web.Management.HealthMonitoringManager..ctor()

   at System.Web.Management.HealthMonitoringManager.Manager()

   at System.Web.Management.HealthMonitoringManager.get_Enabled()

   at System.Web.Management.WebBaseEvent.RaiseSystemEventInternal(String message, Object source, Int32 eventCode, Int32 eventDetailCode, Exception exception, String nameToAuthenticate)

   at System.Web.Compilation.AssemblyBuil

appdomainmanager!DefaultDomain!1fac!01/24/2019-08:34:42:: e ERROR: AppDomain ReportServer error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_PBIRS_0. ---> System.Web.HttpException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified..

appdomainmanager!DefaultDomain!1fac!01/24/2019-08:34:42:: e ERROR: AppDomain ReportServer id 22 ('ReportServer_PBIRS_0-17-131927816811879640') was created. Unloading it...

appdomainmanager!DefaultDomain!1fac!01/24/2019-08:34:42:: i INFO: UnloadAspDomain ReportServer: 22, 'ReportServer_PBIRS_0-17-131927816811879640'

appdomainmanager!DefaultDomain!1fac!01/24/2019-08:34:42:: i INFO: SetUnloadStarted AppDomain id '22': unloadStarted = 1

appdomainmanager!DefaultDomain!1fac!01/24/2019-08:34:42:: i INFO: Appdomain:22 ReportServer_PBIRS_0-17-131927816811879640 unloading.

library!DefaultDomain!1fac!01/24/2019-08:34:42:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: Failed to create Report Server HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportServer within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_PBIRS_0. ---> System.Web.HttpException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 280) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.Web, Version=4.121.2.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)

   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)

   at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)

   at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)

   at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)

   --- End of inner exception stack trace ---

   at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)

   at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement)

   at System.Web.Configuration.HealthMonitoringSectionHelper.BasicSanityCheck()

   at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()

   at System.Web.Configuration.HealthMonitoringSectionHelper.GetHelper()

   at System.Web.Management.HealthMonitoringManager..ctor()

   at System.Web.Management.HealthMonitoringManager.Manager()

   at System.Web.Management.HealthMonitoringManager.get_Enabled()

   at Sys

rshost!rshost!1fac!01/24/2019-08:34:42:: e ERROR: Failed to create HttpRuntime 80131500.

rshost!rshost!1fac!01/24/2019-08:34:42:: e ERROR: Failed to get appdomain 80131500, pipeline=0x000000F1B83ABD60.

rshost!rshost!1fac!01/24/2019-08:34:42:: e ERROR: Error state. Internal abort for pipeline=0x000000F1B83ABD60 ...

obesli
Frequent Visitor
‎01-23-2019 09:39 PM

And report server version is august release.

Idea Statuses