Category Archives: SQL Server

SSRS – WebForms Error 12019

Issue

We have some really long running queries in our SSRS SharePoint integrated mode environment. After a few minutes of processing, we would see the following error:

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12019

Interestingly, this issue only occurs when using IE. In Chrome, the report keeps running and works fine.

Solution

In our environment, we have an F5 BigIP as the load balancer in front of SharePoint. All we needed to do was set the Idle Timeout to 3600 (default was 300) on the TCP profile for the virtual server.


In other load balancing solutions, there are likely similar settings.

Advertisements

SSRS Report Parameters Session Timeout

Issue

A bug in the .net framework causes SQL Server Reporting Services (SSRS) reports to “lose” their parameter values when paging through the report when to stay on a page for longer than 1 minute.

When you click the next page button, you will be presented with the parameter prompt again:

Conditions:

  • You have a multi-page report in SSRS in SharePoint that includes required parameters
  • If you sit on a page of the report for more than 1 minute, you are re-prompted for parameter values and must re-run the report

 

Solution

This is a known problem in the .NET framework. Please reference the following KB: https://support.microsoft.com/en-us/kb/2996566

MSFT does not have the download link published, so you will need to contact support to be sent the hotfix. As of this writing, this hotfix has not been included in any public patches or updates.

Error Creating Folder in “Report Document Library” in SharePoint 2013

Issue

I came across this issue while running SQL Server Reporting Services 2014 (SSRS) in SharePoint integrated mode in SharePoint 2013. As part of the SSRS integrated mode installation, you get a feature that enables a library template called “Report Document Library”. If you use this template, you are unable to create folders using the web interface. Using the “New Folder” option in the web interface results in the following error:

The aspx_debug attribute on the page directive is not allowed in this page.

Cause

The “Report Document Library” feature has been deprecated and should not be used. This library template comes from these feature files:

\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\FEATURES\ReportsAndDataListTemplates\ReportDocumentLibrary

The SharePoint group removed this from the product in SharePoint 2013, but it gets added back in when you install SSRS integrated mode.

So, when creating libraries, stay away from both of these:

This recommendation is confirmed through Microsoft support.

Resolution

Use the standard “Document Library” template to create your libraries for SSRS reports. Once you have the document library, simply add the needed SSRS content types to the library to enable all of the same functionality.

  1. Browse to the library settings page
  2. Click on Advanced Settings. Then enable Allow management of content types
  3. Back to the library settings page, then add the SSRS content types as needed

  1. The SSRS content types are in the group called “SQL Server Reporting Services Content Types”

If you already have report document libraries setup, the best way (without a 3rd party migration tool) to move these into a regular document library is to:

  1. Rename the path of the existing library using SharePoint Designer 2013 (e.g. LibraryName_OLD)
  2. Create the new library using the “Document Library” template using the original name so that user’s links don’t break, then enable the SSRS content types as shown above
  3. Move the existing content into the new library using the Content and Structure feature (Gear -> Site Settings -> Content and Structure).  NOTE: If you do this, you will need to reconfigure any shared data connections settings on the reports!!

Alternatively, if you have a library already setup and you can’t migrate to a standard document library, you can create new folders using Windows Explorer:

  1. Browse to the library
  2. On the library tab, click Open with Explorer
  3. Create folder as needed in Windows Explorer