"Server too busy" error on paginated reports

jccastellana — Tue, 21 Aug 2018 12:39:50 GMT

Hello,

Since few weeks when i run any paginated report in PBIRS sometimes i get a "Server too busy" error instantly instead of my report. While with a PBI dashboard there is no problem and this server never restarts.

You'll find below an extract of the rsreportserver.config file.

If someone can help me it would be awesome ! :smileyhappy:

Version : 1.2.6690.34729 (March 2018)

<Add Key="SecureConnectionLevel" Value="0"/>
	<Add Key="DisableSecureFormsAuthenticationCookie" Value="false"/>
	<Add Key="CleanupCycleMinutes" Value="10"/>
	<Add Key="MaxActiveReqForOneUser" Value="20"/>
	<Add Key="DatabaseQueryTimeout" Value="300"/>
	<Add Key="RunningRequestsScavengerCycle" Value="60"/>
	<Add Key="RunningRequestsDbCycle" Value="60"/>
	<Add Key="RunningRequestsAge" Value="30"/>
	<Add Key="MaxScheduleWait" Value="5"/>
	<Add Key="DisplayErrorLink" Value="true"/>
	<Add Key="WebServiceUseFileShareStorage" Value="false"/>
	<!--  <Add Key="ProcessTimeout" Value="150" /> -->
	<!--  <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->
	<!--  <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
	<!--  <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
	<!--  <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
	<Add Key="WatsonFlags" Value="0x0428"/>
	<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>
	<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessException,System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException,System.AppDomainUnloadedException"/>
	<URLReservations>
		<Application>
			<Name>ReportServerWebService</Name>
			<VirtualDirectory>ReportServer</VirtualDirectory>
			<URLs>
				<URL>
					<UrlString>http://+:80</UrlString>
					<AccountSid>S-1-5-80-1730998386-2757299892-37364343-1607169425-3512908663</AccountSid>
					<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
				</URL>
			</URLs>
		</Application>
		<Application>
			<Name>ReportServerWebApp</Name>
			<VirtualDirectory>Reports</VirtualDirectory>
			<URLs>
				<URL>
					<UrlString>http://+:80</UrlString>
					<AccountSid>S-1-5-80-1730998386-2757299892-37364343-1607169425-3512908663</AccountSid>
					<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
				</URL>
			</URLs>
		</Application>
	</URLReservations>
	<Authentication>
		<AuthenticationTypes>
			<RSWindowsNTLM/>
		</AuthenticationTypes>
		<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
		<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
		<EnableAuthPersistence>true</EnableAuthPersistence>
	</Authentication>
	<Service>
		<IsSchedulingService>True</IsSchedulingService>
		<IsNotificationService>True</IsNotificationService>
		<IsEventService>True</IsEventService>
		<PollingInterval>10</PollingInterval>
		<IsDataModelRefreshService>True</IsDataModelRefreshService>
		<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
		<MemorySafetyMargin>80</MemorySafetyMargin>
		<MemoryThreshold>90</MemoryThreshold>
		<RecycleTime>720</RecycleTime>
		<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
		<MaxQueueThreads>0</MaxQueueThreads>
		<UrlRoot></UrlRoot>
		<UnattendedExecutionAccount>
			<UserName></UserName>
			<Password></Password>
			<Domain></Domain>
		</UnattendedExecutionAccount>
		<PolicyLevel>rssrvpolicy.config</PolicyLevel>
		<IsWebServiceEnabled>True</IsWebServiceEnabled>
		<FileShareStorageLocation>
			<Path></Path>
		</FileShareStorageLocation>
		<DefaultFileShareAccount>
			<Domain></Domain>
			<UserName></UserName>
			<Password></Password>
		</DefaultFileShareAccount>
	</Service>

Re: "Server too busy" error on paginated reports

jccastellana — Fri, 24 Aug 2018 07:31:18 GMT

UP !

Re: "Server too busy" error on paginated reports

jccastellana — Mon, 27 Aug 2018 13:12:00 GMT

UP !

Re: "Server too busy" error on paginated reports

pbx — Tue, 28 Aug 2018 04:19:43 GMT

Any clues in event viewer? Does it happen for all users or some? Could it be too many connections from one user and report server preventing DoS attack? Any memory leak?

Re: "Server too busy" error on paginated reports

jccastellana — Tue, 28 Aug 2018 09:54:58 GMT

Hello,

- Some EventID 137 or 108 without details in Event Viewer.

- It happens for any user.

- We increased MaxActiveReqForOneUser property to 40 but no success, but how can i see the number of connections per user?

- Memory increases to 20% max on one day (128 GB of total memory).

Re: "Server too busy" error on paginated reports

Abdelmajid — Tue, 10 Aug 2021 22:01:42 GMT

Hi jccastellana, did you ever get to know the RCA and fix of this issue?

topic Re: "Server too busy" error on paginated reports in Report Server

"Server too busy" error on paginated reports

Re: "Server too busy" error on paginated reports

Re: "Server too busy" error on paginated reports

Re: "Server too busy" error on paginated reports

Re: "Server too busy" error on paginated reports

Re: "Server too busy" error on paginated reports