Tag Archives: Business Intelligence

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

Error Creating PerformancePoint datasource

Scenario

The following error occurs when you attempt to create a new data source using Dashboard Designer 2010:

You do not have sufficient permissions to complete the request


This occurs in the following scenario:

  • Site Collection A contains the following webs:
    • Web1 – root site in site collection
    • Web2 – subweb to Web1 (Business Intelligence Center)
  • You have delegated design permissions to the BI authors in the BI site (Web2). These users do not have permissions on Web1
  • The BI author launches Dashboard Designer from the BI site and attempts to create a data source:

 

  • When the BI author selects the data source template, the permissions error is displayed.

 

Cause

In the process of creating the data source, Dashboard Designer requires that the user has at least the following permissions in the root web of the site collection:

 

In my scenario, the BI authors did not need access to the content on the root site, so I simply created a custom permission level on the root with the following permissions:

  • Use Remote Interfaces
  • Use Client Integration Features
  • Open

 

Once the BI author has these priviledges on the root web, they are able to create PerformancePoint data sources in the BI subweb.