Forum Discussion
Error when deploying a report to Power BI Report Server October 2017
Which October version did you run? I tested on the latest October version 1.1.6530.30789, not reproduce the issue. Would you please test in this version again?
Best Regards,
Qiuyun Yu
I have this exact version of the PBIRS installed and get the exact same error described by the original post.
Any further insights would be appreciated.
Thanks,
Eric
- mgmeyer8 years agoPower BI Team
Can you check the RSHostingService and msmdsrv logs in the PBIRS installation LogFiles folder and let me know if you see any errors? Also are you able to upload the report from the Report portal? Thanks!
- emixon8 years agoRegular Visitor
I was just able to solve the issue by changing the Service Account in the Configuration Manager from Network Service to a local account with proper permissions by following the guidance on https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-report-server-service-account-ssrs-configuration-manager
Thanks!
- jcabgz8 years agoRegular Visitor
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!