You are currently offline, waiting for your internet to reconnect

Security Update MS11-074 for WSS 2.0/SPS 2003 breaks Data View Web Part

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

SYMPTOMS
After installing security update MS11-074 for Windows SharePoint Services 2.0 / SharePoint Portal Server 2003 (KB 2494007), some Data View Web Parts stop rendering in browser. The following error message is displayed:

"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."

CAUSE
The Security Update breaks some XSLT ddwrt functions in the Data View Web Part, for example, ddwrt:FormatDate(string szDate, long lcid, long formatFlag) and ddwrt:FilterLink(). 

For an introduction to XSLT ddwrt functions, please refer to: http://msdn.microsoft.com/en-us/library/dd583143%28v=office.11%29.aspx

RESOLUTION
Microsoft is aware of this issue.

The following options are currently available:

1. Upgrade to Windows SharePoint Services 3.0 or Office SharePoint Server 2007.

2. Evaluate how widely the Data View Web Part is used and apply the following workaround if there are very few pages affected:

Remove broken ddwrt functions in the Extensible Stylesheet Language Transformation (XSLT) code of the Data View Web Part.

Here is an example when the broken ddwrt function is ddwrt:FormatDate(string szDate, long lcid, long formatFlag):

Replace code "ddwrt:FormatDate(string(@someDateField), 1033, 5)" with "@someDateField". By applying this work around, the Data View will render in browser, however, the formatting of the Date field will be changed as following:

Before the security update, the date is in this format: 9/26/2011 3:41 PM
After above work around, the date is in this format: 2011-09-26T15:41:03

Another example, ddwrt:FilterLink(), this function returns an empty string. Just remove the function, the Data View should render the same way as before.

The above concept can be applied to other ddwrt functions with caution. There are possibilities that removing ddwrt functions will impair the function of XSLT so that the data displayed in Data View is not in the desired format. In those situations, please consider option 1 or 3. 


3. Rollback the WSS 2.0/SPS 2003 farm to a state prior to installing the above Security Update. A backup of the farm/content databases before the security update is required for this to be successful.


Backup / restore for WSS 2.0:
http://technet.microsoft.com/en-us/library/cc287794(office.12).aspx


Backup / restore for SPS 2003:
http://technet.microsoft.com/en-us/library/cc750142.aspx


MORE INFORMATION
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2623732 - Last Review: 09/28/2011 13:50:00 - Revision: 6.0

  • Microsoft Windows SharePoint Services 2.0
  • Microsoft Office SharePoint Portal Server 2003
  • KB2623732
Feedback