Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • mgmeyer's avatar
    mgmeyer
    Power BI Team

    Can you check the ReportingServicesServiceXXXX log in the LogFiles folder and let me know if you see any errors?

    • Anonymous's avatar
      Anonymous
      Not 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. ;

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        FYI: I had NO errors show up during the install or configuration of the Power BI Report Server (?)