I recently had a list on which all listdata.svc calls failed with a generic “500 Internal Server Error.” After reviewing some ULS logs, I found errors indicating my query attempts were aborted due to exceeding the farm’s lookup column threshold.
(more…)Tag: Troubleshooting
-
Unable to Display this Web Part – Round 2
As a continuation of my previous post on this issue, further investigation of my XSLTTransformTimeout issues points to farm-level performance issues with the SQL cluster.
Since the last post and the corrective action of copying known “valid” XSL stylesheets to those frontend servers with mismatched files, the web part issue eventually recurred (just as we secretly expected). The next action plan from Microsoft was to increase the XSLTTransformTimeout value from 10 seconds to a whopping 30 seconds!
The farm-wide performance impacts aside, my admins caved and raised the timeout value. For about a week, things seemed to normalize and behave correctly… but then one morning, BAM! The web part issue returned, yet again.
System.InvalidProgramException: Common Language Runtime detected an invalid program. So now with the timeout value at 30 seconds, XSL stylesheets consistent and manually verified across all the frontends, and the April 2014 CU applied, we were out of options.
The web part issue now ties directly back to larger performance issues on our farm, as a result of an overloaded SQL cluster. The only long-term resolution is to add additional SQL hardware (cue the bureaucratic red tape!).
-
Unable to Display this Web Part
In this latest installment of my ongoing series about intermittent SharePoint issues, I have been working with Microsoft Premier support on this web part error for well over a month now (xslttransformtimeout). (more…)
-
Intermittent Designer Workflow Failures – Unable to execute query: Error 0x81020014
The past 3 weeks I have monitored another intermittent issue that is comically difficult to troubleshoot, this time related to the workflow infrastructure. End users report that list items fail to either create or copy between lists as expected (and defined in the business process workflows). I eventually opened a Microsoft Premier support case to sort this one out. (more…)
