Issue:
SQL Event logging dbghelp.dll messages every
second, or multiple msgs per second.
Solution:
Reduce the time they are logged.
The Database Performance Metric Timer Job runs
every minute. This was throwing the message into SQL. This appears to be a bug
with SharePoint 2013 on premise. The 'workaround' is to Change the frequency of
the Timer Job to Daily, rather than the default of every minute.
I found this to be the most helpful post and
provided the person that had incorrectly set the Answered post with an update to
the lower most post marked as Helpful that actually resolved this.
http://social.technet.microsoft.com/Forums/sharepoint/en-US/6060757a-9832-4d28-8719-c24862ef7de9/sql-2012-standard-with-sharepoint-2013-error-message-filling-sql-log-using-dbghelpdll-version
By "reduced" I mean until midnight when the
Timer job associated with the issue will run again.
MCTS, MCP, MCSE, LMAO, Working on it...
SharePoint, OneDrive, Microsoft 365, PowerBI, Analytics, Compliance reporting, Dynamics/SharePoint integrations
Wednesday, July 31, 2013
Thursday, July 11, 2013
XSLT Problem with Windows KB2844286
If
you have any clients on the Automatic Tuesday Windows Update cycle, and they are
running SharePoint on premise, please be aware of a critical issue that occurred
at one of our clients as a result of the June 11th Updates that were
installed last night.
It will be very obvious, the WebPart Header will display OK, but all contents in the webpart disappear and will instead show an error
Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object. at System.Xml.Xsl.XslCompiledTransform.Load(MethodInfo executeMethod, Byte[] queryData, Type[] earlyBoundTypes) at Microsoft.Xslt.STransform.GetCompiledTransform() at Microsoft.SharePoint.WebPartPages.BaseXsltListWebPart.LoadXslCompiledTransform(WSSXmlUrlResolver someXmlResolver) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCompiledTransform() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) 5962a0e6-2114-4dad-9682-5b327c6e47e1
The Solution
Go To Control Panel, Programs> Programs and Features > View installed Updates
In the Windows section, find Windows KB2844286
Uninstall it. (And you may want to disable Automatic Updates)
open elevated Command Prompt and run IISRESET
It will be very obvious, the WebPart Header will display OK, but all contents in the webpart disappear and will instead show an error
Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object. at System.Xml.Xsl.XslCompiledTransform.Load(MethodInfo executeMethod, Byte[] queryData, Type[] earlyBoundTypes) at Microsoft.Xslt.STransform.GetCompiledTransform() at Microsoft.SharePoint.WebPartPages.BaseXsltListWebPart.LoadXslCompiledTransform(WSSXmlUrlResolver someXmlResolver) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCompiledTransform() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) 5962a0e6-2114-4dad-9682-5b327c6e47e1
The Solution
Go To Control Panel, Programs> Programs and Features > View installed Updates
In the Windows section, find Windows KB2844286
Uninstall it. (And you may want to disable Automatic Updates)
open elevated Command Prompt and run IISRESET
Subscribe to:
Posts (Atom)