September 19, 2018 at 1:07 pm
We have a couple of problems. I've looked closely at the configuration numerous times and don't see anything that looks wrong.
1) Cannot directly edit Datasources - get an error "Something went wrong." We are, however, able to deploy new reports and create new datasources in that way.
logged is an error:
RSPortal!reportserverwebapp!RSPortal.exe!20!09/19/2018-10:42:13:: i INFO: Sending response. Response code AD\pmg 200, Elapsed time 0:00:00.0077983 | RequestID = s_547583c7-817f-496e-b93f-97b441308560
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:13:: i INFO: Received request GET /api/v2.0/Extensions | RequestID = s_064c090a-e1c3-4451-9507-20acd42de818
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:15:: e ERROR: OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.ListExtensions(String ExtensionType)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListExtensions(String extensionType)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.GetExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.ListExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.ExtensionsController.GetEntitySet(String castName)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
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.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.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.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>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_064c090a-e1c3-4451-9507-20acd42de818
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:15:: i INFO: Sending response. Response code AD\pmg 500, Elapsed time 0:00:01.6005576 | RequestID = s_064c090a-e1c3-4451-9507-20acd42de818
2) Some users get authorization errors in the report interface even though the credentials and permissions are set up correctly for them. In the Windows event viewer, I see this:
The description for Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
3005
An unhandled exception has occurred.
9/19/2018 9:26:46 AM
9/19/2018 1:26:46 PM
ad302a8af78841ab948411700d48e56f
216
1
0
ReportServer_SSRS_0-7-131818233892396613
RosettaSrv
/ReportServer
E:\Microsoft SQL Server Reporting Services\SSRS\ReportServer\
DBServer3
5040
ReportingServicesService.exe
AD\ssrs
COMException
This network connection does not exist. (Exception from HRESULT: 0x800708CA)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.GetAuthType()
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()
Any thoughts on how to find the root cause of these issues and resolve them?
Thanks -
September 19, 2018 at 1:44 pm
Michael Gerholdt - Wednesday, September 19, 2018 1:07 PMWe have a couple of problems. I've looked closely at the configuration numerous times and don't see anything that looks wrong.
1) Cannot directly edit Datasources - get an error "Something went wrong." We are, however, able to deploy new reports and create new datasources in that way.
logged is an error:
RSPortal!reportserverwebapp!RSPortal.exe!20!09/19/2018-10:42:13:: i INFO: Sending response. Response code AD\pmg 200, Elapsed time 0:00:00.0077983 | RequestID = s_547583c7-817f-496e-b93f-97b441308560
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:13:: i INFO: Received request GET /api/v2.0/Extensions | RequestID = s_064c090a-e1c3-4451-9507-20acd42de818
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:15:: e ERROR: OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.ListExtensions(String ExtensionType)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListExtensions(String extensionType)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.GetExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.ListExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.ExtensionsController.GetEntitySet(String castName)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
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.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.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.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>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_064c090a-e1c3-4451-9507-20acd42de818
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:15:: i INFO: Sending response. Response code AD\pmg 500, Elapsed time 0:00:01.6005576 | RequestID = s_064c090a-e1c3-4451-9507-20acd42de8182) Some users get authorization errors in the report interface even though the credentials and permissions are set up correctly for them. In the Windows event viewer, I see this:
The description for Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
3005
An unhandled exception has occurred.
9/19/2018 9:26:46 AM
9/19/2018 1:26:46 PM
ad302a8af78841ab948411700d48e56f
216
1
0
ReportServer_SSRS_0-7-131818233892396613
RosettaSrv
/ReportServer
E:\Microsoft SQL Server Reporting Services\SSRS\ReportServer\
DBServer3
5040
ReportingServicesService.exe
AD\ssrs
COMException
This network connection does not exist. (Exception from HRESULT: 0x800708CA)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.GetAuthType()
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()Any thoughts on how to find the root cause of these issues and resolve them?
Thanks -
What browser are you using? Try Internet Explorer.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 19, 2018 at 1:48 pm
I do use IE. The errors are not UI-based, but are browser agnostic.
In general, 2017 RS seems much more cross-browser compatible than were 2005 and 2008 R2.
September 19, 2018 at 1:57 pm
Michael Gerholdt - Wednesday, September 19, 2018 1:07 PMWe have a couple of problems. I've looked closely at the configuration numerous times and don't see anything that looks wrong.
1) Cannot directly edit Datasources - get an error "Something went wrong." We are, however, able to deploy new reports and create new datasources in that way.
logged is an error:
RSPortal!reportserverwebapp!RSPortal.exe!20!09/19/2018-10:42:13:: i INFO: Sending response. Response code AD\pmg 200, Elapsed time 0:00:00.0077983 | RequestID = s_547583c7-817f-496e-b93f-97b441308560
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:13:: i INFO: Received request GET /api/v2.0/Extensions | RequestID = s_064c090a-e1c3-4451-9507-20acd42de818
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:15:: e ERROR: OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.ListExtensions(String ExtensionType)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListExtensions(String extensionType)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.GetExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.ListExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.ExtensionsController.GetEntitySet(String castName)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
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.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.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.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>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_064c090a-e1c3-4451-9507-20acd42de818
RSPortal!reportserverwebapp!RSPortal.exe!25!09/19/2018-10:42:15:: i INFO: Sending response. Response code AD\pmg 500, Elapsed time 0:00:01.6005576 | RequestID = s_064c090a-e1c3-4451-9507-20acd42de8182) Some users get authorization errors in the report interface even though the credentials and permissions are set up correctly for them. In the Windows event viewer, I see this:
The description for Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
3005
An unhandled exception has occurred.
9/19/2018 9:26:46 AM
9/19/2018 1:26:46 PM
ad302a8af78841ab948411700d48e56f
216
1
0
ReportServer_SSRS_0-7-131818233892396613
RosettaSrv
/ReportServer
E:\Microsoft SQL Server Reporting Services\SSRS\ReportServer\
DBServer3
5040
ReportingServicesService.exe
AD\ssrs
COMException
This network connection does not exist. (Exception from HRESULT: 0x800708CA)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.GetAuthType()
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()Any thoughts on how to find the root cause of these issues and resolve them?
Thanks -
There are some issues when using NTLM where the portal and Reporting server hit issues communicating.
Your error is not the same but it is similar to the issue in this blog. It's doing the same process - trying to get the installed extensions:
The strange case of Data source can’t be created with Reporting Services 2016 in Azure VM
The above article does go through how to fix towards the end of the article. It's essentially the same as step 3 in this article:
Configure a Report Server on a Network Load Balancing Cluster
The titles of the articles won't make sense and you wouldn't think they apply until you read the articles.
Sue
September 19, 2018 at 1:57 pm
The above errors were from the RSPortal log. In the RSManagement log, I see this:
2018-09-19 11:25:02.1936|ERROR|13|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_fb2bce58-854c-40ff-b011-28db3b7d4d9b
2018-09-19 11:25:02.1936|INFO|13|AD\sqlssrs 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0225175
Connection dropped| RequestID = s_fb2bce58-854c-40ff-b011-28db3b7d4d9b System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>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.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__0.MoveNext()
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply