Wednesday, July 31, 2013

SharePoint 2013 dbghelp.dll issue

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. 

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