Forum Discussion
Cannot deploy rdl file to Power BI Report Server
We're trying out Power BI Report Server (trial version 15.0.2.402) and are unable to deploy an .rdl (using VS 2014) or upload using Portal URL. Attempting to deploy using VS 2014 we continue to get Login box with Username and Password, which keeps popping up each time we try with Admin credentials. Using the web portal we get "An error has ocurred. Something went wrong. Please try again later." We can upload a simple .txt file however (?).
Here's part of the RSPortal log file that shows the error: "System.Net.WebException: The request failed with HTTP status 401: Unauthorized."
We are able to upload .pbix type analytics reports (?)
2018-08-24 13:11:18.6033|INFO|52|CFG : AccessControlAllowCredentials = [false] (env)
2018-08-24 13:11:18.6033|INFO|52|Received request GET /assets/fonts/powerbiglyphs-regular.woff| RequestID = s_cbfe053b-aedb-43a6-99ad-d47e7691f1b6
2018-08-24 13:11:18.7153|INFO|52|Received request GET /api/v2.0/catalogitems%284f81527a-db55-46b1-9bdd-6f442e1c3489%29/Model.Folder/catalogitems/| RequestID = s_bfe11654-f05e-4c56-897c-e52937f6ed46
2018-08-24 13:11:18.7153|INFO|53|Sending response. Response code xxxxx\xxxxxxxxxx 200, Elapsed time 0:00:00.0141077| RequestID = s_bfe11654-f05e-4c56-897c-e52937f6ed46
2018-08-24 13:11:25.2322|INFO|52|Received request POST /api/v2.0/catalogitems| RequestID = s_8f81945e-d7bb-4069-b47e-32ec5d2c5ef5
2018-08-24 13:11:27.2728|ERROR|52|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.CreateCatalogItem(String itemType, String name, String parent, Boolean overwrite, Byte[] definition, Property[] properties, Warning[]& warnings)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass1.<CreateCatalogItem>b__0()
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.CreateReport(RSService rsService, IPrincipal userPrincipal, String reportName, String parentFolder, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.CreateItem(IPrincipal userPrincipal, CatalogItem catalogItem, CatalogItem& createdItem)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.AddEntity(CatalogItem entity, CatalogItem& createdEntity)
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_8f81945e-d7bb-4069-b47e-32ec5d2c5ef5
2018-08-24 13:11:27.2728|INFO|53|Sending response. Response code xxxx\xxxxxxxxxxx 500, Elapsed time 0:00:02.041152| RequestID = s_8f81945e-d7bb-4069-b47e-32ec5d2c5ef5
Any help is greatly appreciated, as we'd like to use the tool but cannot even fully evaluate it at this time.
9 Replies
- BrianGNew Member
Same condition, dont know whats wrong with this one. Help needed.
- mgmeyerPower BI Team
Can you check the ReportingServicesServiceXXXX log in the LogFiles folder and let me know if you see any errors?
- AnonymousNot applicable
Yes, there are several errors in the that log... here are the relevant parts of that log:
rshost!rshost!1b6c!08/24/2018-15:19:14:: i INFO: Derived memory configuration based on physical memory as 4193844 KB
rshost!rshost!1b6c!08/24/2018-15:19:14:: w WARN: Failed to initialize performance counters: 2. Possible setup issue.
appdomainmanager!DefaultDomain!1b6c!08/24/2018-15:19:14:: i INFO: Entered managed ServiceMain in DefaultDomain.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: e ERROR: Configuration file element UrlReservation has a invalid VirtualRoot. It will be ignored.--
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: e ERROR: Failed to get url configuration section.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: e ERROR: Failed to get url configuration section.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: w WARN: IsApplicationUrlSubsetOfReportServer() -- Failed to get url configuration section.
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: i INFO: Using report server internal url .
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: i INFO: Using report server external url .
configmanager!DefaultDomain!1700!08/24/2018-15:19:14:: i INFO: Using url root .--
library!WindowsService_0!1198!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
rshost!rshost!1700!08/24/2018-15:19:17:: i INFO: Derived memory configuration based on physical memory as 4193844 KB
rpcserver!DefaultDomain!182c!08/24/2018-15:19:17:: i INFO: Process monitoring started.
servicecontroller!DefaultDomain!12a4!08/24/2018-15:19:17:: i INFO: Total Physical memory: 4294496256
library!WindowsService_0!1198!08/24/2018-15:19:17:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
library!WindowsService_0!1198!08/24/2018-15:19:17:: e ERROR: ServiceStartThread: Attempting to start service again...
rpcserver!DefaultDomain!1198!08/24/2018-15:19:17:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!1198!08/24/2018-15:19:17:: i INFO: RPC Server started. Endpoint name ='ReportingServices$PBIRS'
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!DefaultDomain!1be8!08/24/2018-15:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;- AnonymousNot applicable
FYI: I had NO errors show up during the install or configuration of the Power BI Report Server (?)