Forum Discussion
Error when deploying a report to Power BI Report Server October 2017
Hi guys,
sorry for the late response, I had to roll back to the June release because we needed to use that server actively. This rollback (uninstall then reinstall the June version) run without issues.
Then I tried to upgrade again to the October release with the same results as I show in my previous posts. The Report Server version is: 1.1.6530.30789.
mgmeyer here you have some logs. The AS service definitely has some kind of issue. I'll try changing the Service Account as emixon suggested, but even if it works it's not a proper solution IMHO.
RSHostingService:
2017-11-30 09:09:18.7560|INFO|29|Throttled restart of process by 3.598.796,88ms: AS 2017-11-30 09:09:19.9592|WARN|24|Child Process [AS] Died. Check the log for further information
msmdsrv.log (the same sequence I'm showing below repeats itself every hour it seems):
(30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000B) (30/11/2017 9:09:19) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019) (11/30/2017 9:09:19 AM) Message: The Vertipaq thread pool now has 2 minimum threads, 4 maximum threads, and a concurrency of -1. Its thread pool affinity mask is 0x000000000000000f. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A) (11/30/2017 9:09:19 AM) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 286, Event ID: 0x411E0015) (11/30/2017 9:09:19 AM) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 286, Event ID: 0x411E000F) (11/30/2017 9:09:19 AM) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 286, Event ID: 0x411E0016) (11/30/2017 9:09:19 AM) Message: The flight recorder snapshot definition file 'C:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\FlightRecorderSnapshotDef.xml' was not found, skipping initialization of snapshot activity. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210021) (11/30/2017 9:09:19 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005) (11/30/2017 9:09:19 AM) Message: Cannot start the server in Tabular mode as the needed privilege for memory locking is not held (SE_INC_WORKING_SET_NAME or SE_INC_BASE_PRIORITY_NAME, depending on your operating system version) (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210025) (11/30/2017 9:09:19 AM) Message: The service cannot be started: The following system error occurred: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210000) (11/30/2017 9:09:19 AM) Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)
Thanks!
Hi again guys,
I got it working.
If you open the PBI configuration manager, in the Service Account tab, the default is "Use built-in account" and in the dropdown list, the option is Virtual Service Account. The actual account used is "NT SERVICE\PowerBIReportServer".
As soon as I changed to "Use another account" and put there the details of an account that is administrator in that machine, everything started to work.
I saw a very similar issue when installing the Analysis Services instance during the SQL Server 2017 installation. The service wouldn't start until I changed from the default service account to an account with administrative privileges. Since it seems PBI report server (October 2017 version) and SQL Server 2017 share the same AS version, it makes sense that they share the same issues too.
IMHO changing the service account is a workaround, not a solution, for both report server and SQL Server 2017 AS. I don't know if you guys at Microsoft can tell us anything about this, but it would be really appreciated :smileyhappy: