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.
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.
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:
- When the BI author selects the data source template, the permissions error is displayed.
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
Once the BI author has these priviledges on the root web, they are able to create PerformancePoint data sources in the BI subweb.