"Server too busy" error on paginated reports

[jccastellana]

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 ! 

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>

[jccastellana]

UP !

[pbx]

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?

[jccastellana]

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

[Abdelmajid]

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

[jccastellana]

UP !