topic Re: Cannot deploy rdl file to Power BI Report Server in Report Server

Cannot deploy rdl file to Power BI Report Server

Anonymous — Wed, 29 Aug 2018 17:31:34 GMT

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.

Re: Cannot deploy rdl file to Power BI Report Server

BrianG — Mon, 27 Aug 2018 12:37:43 GMT

Same condition, dont know whats wrong with this one. Help needed.

Icloud Google Classroom GIMP

Re: Cannot deploy rdl file to Power BI Report Server

mgmeyer — Mon, 27 Aug 2018 15:56:23 GMT

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

Re: Cannot deploy rdl file to Power BI Report Server

Anonymous — Mon, 27 Aug 2018 16:15:34 GMT

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. ;

Re: Cannot deploy rdl file to Power BI Report Server

Anonymous — Wed, 29 Aug 2018 17:10:57 GMT

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

Re: Cannot deploy rdl file to Power BI Report Server

mgmeyer — Wed, 29 Aug 2018 19:29:14 GMT

It sounds like your configuration might be messed up, did you configure both the Portal and Report Server URLs in the configuration tool? If you did I would suggest removing the reservations and trying again.

Re: Cannot deploy rdl file to Power BI Report Server

Anonymous — Tue, 04 Sep 2018 16:09:59 GMT

We are now trying the August 2018 evaluation version and cannot install it. Here are parts of the install log...

MSI (s) (20:F0) [08:58:40:600]: Doing action: RemoveExistingProducts
MSI (s) (20:F0) [08:58:40:600]: Note: 1: 2205 2: 3: ActionText
Action ended 8:58:40: InstallValidate. Return value 1.
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2: 3: Error
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 22
Action start 8:58:40: RemoveExistingProducts.
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2: 3: Error

MSI (s) (20:F0) [08:58:40:559]: Package name extracted from package path: 'PBIReportServerSetup.msi'
MSI (s) (20:F0) [08:58:40:559]: Package to be registered: 'PBIReportServerSetup.msi'
MSI (s) (20:F0) [08:58:40:559]: Note: 1: 2205 2: 3: Error
MSI (s) (20:F0) [08:58:40:560]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (20:F0) [08:58:40:560]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (20:F0) [08:58:40:560]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (20:F0) [08:58:40:560]: Product installation will be elevated because user is admin and product is being installed per-machine.

MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 23
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2: 3: Error
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 16
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2205 2: 3: Error
MSI (s) (20:F0) [08:58:40:601]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 21
MSI (s) (20:F0) [08:58:40:602]: Doing action: InstallInitialize
MSI (s) (20:F0) [08:58:40:602]: Note: 1: 2205 2: 3: ActionText
Action ended 8:58:40: RemoveExistingProducts. Return value 1.

Action start 8:58:41: InstallFiles.
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2: 3: Patch
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2: 3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence`
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2: 3: Error
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1302
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2: 3: MsiSFCBypass
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2: 3: MsiSFCBypass 4: SELECT `File_` FROM `MsiSFCBypass` WHERE `File_` = ?
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (20:F0) [08:58:41:987]: Note: 1: 2228 2: 3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ?

1|Setup FailedSystem.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe.config'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)

Re: Cannot deploy rdl file to Power BI Report Server

mgmeyer — Tue, 04 Sep 2018 19:49:24 GMT

We found a last minute issue that impacts clean installs, if you download the latest setup this issue has been fixed.

Re: Cannot deploy rdl file to Power BI Report Server

Anonymous — Tue, 04 Sep 2018 21:19:39 GMT

Thanks, Now I can re-install the report server, but still same old issue with not being able to upload .rdl (paginated) reporting services reports.

Re: Cannot deploy rdl file to Power BI Report Server

Anonymous — Thu, 06 Sep 2018 16:23:17 GMT

Do we also need to install Reporting Services on our Web Server? Our environment is SQL Server 2012 on a separate DB Server and our Web Server (where we've installed Power BI Report Server) is running on Windows Server 2012 R2 Standard. Any help is much appreciated, as our evaluation copy of Power BI Report Server is about to run out. Thanks...