If you’ve been bitten by the issue I described in my post called August Cumulative Update Causing Stack Overflows with DVWPs Running Over One Second, then you’ll be happy to know that there may be a solution available to you.
An anonymous reader left a comment on the above post the today letting me know that there is a new option provided in the February CU that allows you to increase the timeout from the rather nonsensical one second introduced in the August CU to something more reasonable.
I don’t have a setup where I can test this right now, so treat it as unconfirmed information, but it looks to be from someone named Joerg Sinemus, who works at Microsoft Germany GmbH.
Check out his post with a more complete description of the fix here:
Here’s the full text of his post in case it disappears for some reason. Full credit due, of course. That’s an assassin bug photo. It seemed appropriate.
If you run into the problem described in:
2639184 SharePoint 2010: DataForm Web Part displays “Unable to display this Web Part”
we might have another solution for you.
Our KB article 2597136 contains the following line that describes the issue but needs some more steps after you have installed the hotfix.
When you try to open a large .xsl file by using a Data Form Web Part (DFWP) on a SharePoint Foundation site, the DFWP does not display the file.
We highly recommend to use the following steps to change the behavior:
Install February 2012 cumulative update (Full Server package) for Microsoft SharePoint Foundation 2010 or SharePoint Server 2010
The code change is in the Microsoft.SharePoint.DLL with build 14.0.6117.5002 and later also on higher builds as usual.
Now you need to test which value might be a better one than One Second timeout.
On SharePoint Server log in with your Farm Account.
Start PowerShell in an elevated mode; check http://blogs.msdn.com/b/joerg_sinemus/archive/2010/08/16/what-is-the-difference-between-local-administrator-and-machine-administrator.aspxfor more information.
The following code lines will set the timeout to five seconds:
$farm = Get-SPFarm
$farm.XsltTransformTimeOut = 5
In a discussion forum I read that two seconds are also a good value but everything depends as usual on the overall performance on the server side.