Friday, July 26, 2013

All Data View Web Parts stopped working Share Point 2010

PROBLEM:
It seems that all of our (customized) DVWP stopped working this morning. It doesn't seem to depend if the datasource is a list or database. If I open the page with the DVWP in Sharepoint Designer 2010, it opens just fine with data. We get the message,

"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as FrontPage. If the problem persists, contact your Web server administrator."

These are pages on a SP 2010 server, to be more precize SP 2007 updated to SP2010  , but until this morning, they were just fine. This only happens when Data View Web Part are modified to do some conditional formatting or are inter connected with each other. My only lead is that some automatic updates happened over night.

 SOLUTION:

Just Uninstall Windows Update KB2844286

PS:

There are very similar error to this one but this error is specificcaly connected with Windows update.

If you read the following error from sharepoint log NOT WINDOWS LOG then this solution should work.

Area     : SharePoint Foundation
Category : Web Parts
Level    : High
EventID  : 89a1
Message  : Error while executing web part: System.NullReferenceException: Objec
           t reference not set to an instance of an object.     at System.Xml.X
           sl.XslCompiledTransform.Load(MethodInfo executeMethod, Byte[] queryD
           ata, Type[] earlyBoundTypes)     at Microsoft.Xslt.STransform.GetCom
           piledTransform()     at Microsoft.SharePoint.WebPartPages.BaseXsltLi
           stWebPart.LoadXslCompiledTransform(WSSXmlUrlResolver someXmlResolver
           )     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCom
           piledTransform()     at Microsoft.SharePoint.WebPartPages.DataFormWe
           bPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)



Info How to read sharepoint error log please check this post http://ittechnotebook.blogspot.com/2013/07/how-to-find-real-error-in-sharepoint.html

3 comments:

Anonymous said...

Thanks. This was spot-on. Refreshing to find something so direct and simple in the maze of Sharepoint waffle.

Anonymous said...

Hi, we had the same issue. Microsoft released a hotfix, no need to uninstall KB2844286 http://support.microsoft.com/kb/2872441

Concerned Citizen said...

We had the same issue in November. We applied the hotfix back then and it resolved the issue. However the issue has started again, occuring twice now in the last week and a half.

A manually (and painful) fix if you cannot perform an IISReset during the day is to simply edit the web part and then save it. It seems all the other web parts should reappear the following day.

We are performing a reset tonight and are hoping this resolves the lates reincarnation of this issue.

Any other suggestions if this doesnt work?