Brad's profileSharePoint BlogPhotosBlogLists Tools Help

Blog


    February 25

    New hotfixes for WSS and MOSS (SharePoint 2007)

    And not a moment too soon! We rolled out the infrastructure update to a client just recently to resolve an issue they were having where emails coming into an email-enabled document library were not triggering a workflow. As most people know, the Infrastructure Update breaks Alternate Access Mappings when using Load-balancing or Proxies… so if you use them, you then need to install at least the next hotfix rollup that came out after it.

    So that was the plan… and all was going swimmingly until we looked at the workflow and realised that they were all failing – it appears as though the October and December hotfixes introduced an issue where updates to user columns failed when running through SharePoint Designer workflow. It’s like playing Whack-a-mole.

    Anyway, the new hotfixes have just been released and they fix a lot of outstanding issues – they can be found here for WSS - http://support.microsoft.com/kb/961750 – and here for MOSS - http://support.microsoft.com/kb/961749. I can’t find the hotfix rollup yet, so until they are published, these should ideally be deployed on farms that already have the December releases.

    **UPDATE** - The Rollups for February have been released, as announced on Todd Klindt's blog - http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?List=56f96349%2D3bb6%2D4087%2D94f4%2D7f95ff4ca81f&ID=111 - get them here (WSS3) and here (MOSS 2007)

    **UPDATE** - Joerg Sinemus has updated his blog with the information required to roll these out. Until the uber-patches are released, you need to be at least running SP1, however there are no other prerequisites as per his article... having said that, other people have had problems if they do not yet have the infrastructure update installed and they try to install a hotfix pack released after the Infrastructure Update was released.


    The big or “uber” packages are not yet available. CAPES (Customer and Partner Engineering Services team in Microsoft) is still working on these so please stay tuned. If you need to immediately install the Feb Hotfix update please read & follow the checklist.

     Checklist to install Feb CU:

    - Preqs are WSS and MOSS Global SP1 and all language specific SP1
    - Install WSS Global 961750 (Feb Hotfix pack WSS)
    - For each language including the installed one install language specific WSS 967703
    - Install MOSS Global 961749 (Feb Hotfix Pack MOSS)
    - For each language including the installed one install language specific MOSS 961754
    - Run psconfig -cmd upgrade -inplace b2b –force


    List of issues resolved is as follows:WSS


  • When you decline a recurring meeting request from the meeting workspace, the e-mail message that is sent by the SharePoint server is not recognized by Microsoft Office Outlook 2007 as a meeting declination. Therefore, Outlook does not update the meeting attendee status to "Declined."
  • You migrate discussion boards from Windows SharePoint Services 2.0 to Windows SharePoint Services 3.0. Discussion boards work fine after that. However, if you export and import a discussion board into another Windows SharePoint Services 3.0 site, the thread relationship is broken, and all entries appear in one list.
  • Content deployment target site permissions that are not inherited can be removed.
  • The entries for e-mail-enabled lists are being deleted from the EmailEnabledLists table in the configuration database. When this issue occurs, incoming e-mail messages for these lists are not delivered. Therefore, the e-mail messages are deleted, and errors are logged for "Unkown alias."
  • If you have a list that has more than 500 unique scope IDs and if the Content Approval option is enabled, duplicated items may appear in the default view of this list.
  • In a Windows SharePoint Services 3.0 site, alerts for All day Calendar events do not show the correct start and end time in alert e-mail messages.
  • When you try to modify group membership of the built-in groups of site collections, you may receive a "System.UnauthorizedAccessException" exception. For example, this issue may occur when you try to add a new user to a built-in group. Built-in groups include visitors, owners, members, and so on.
  • If you use the SharePoint Content Migration API to export large sites, the performance is poor.
  • You create a new page in the source variation by using a customized page layout that has calculated columns. However, when you try to allow the variation engine to propagate the new page to the other variation label Web sites, it fails.
  • When you move through a specific blog category page, you cannot move to the Next page of blog entries. By default, the paging is set to 10 items per page. However, when you move to the next page in a category, a "There are no posts in this category" message is displayed. This message is incorrect. Paging in the All Posts area works as expected.
  • Before an incremental content deployment, you activate and then deactivate the feature that creates content types on both the source site and the destination site. During the incremental deployment, the content type delete operation fails, and the content deployment stops with an error message.
  • All meetings that you view under a meeting workspace display folder numbers instead of document names.
  • You create a versioned page, and you create a major version and a minor version. When you delete the versioned page and try to export the document library, it fails.
  • If you have an orphan site collection, the XML produced by the stsadm -o enumsites command is not well formed, as shown in the following example.

    <Sites Count="3"> 
    <Site Url="http://webapp/" ... /> 
    <Site Error="Error message">  
    <Site Url="http://webapp/..." ... /> 
    </Site>

    The last tag is missing an "s." It should be </Sites>. Also, the <site Error …> tag is not correctly closed.

  • After you install update 957691, you cannot set a user type column from the workflow when you create a new list item.
  • If you programmatically run the SPListItem.SystemUpdate(bool) method on a document library, the latest check-in comment will be removed.
  • If you add a Site Columns choice type that has a slash (/) in the column name to a document library, you cannot change the value of it on a SharePoint site. However, you can change the value by opening the document in Microsoft Word, editing the property, and saving it back to the document library.
  • When you build an application to control a document library, the SPFolder.CopyTo() method does not increase the List.ItemCount number, this will cause inconsistency in the list.
  • The Microsoft PKM Search Filter Daemon (Mssdmn.exe) crashes every 15 seconds when crawled using certificate authentication.
  • When you try to back up the Shared Search index, it always fails, and you receive the following error message in the backup log:

    [30/9/2008 2:11:46]: Verbose: Starting object: Shared Search Index. [30/9/2008 3:12:17]: Error: Object Shared Search Index failed in event OnBackupComplete. For more information, see the error log located in the backup directory. WebException: The current operation timed-out after 3600 seconds [30/9/2008 3:12:17]: Debug: at Microsoft.Office.Server.Search.Administration.CatalogPauseTimeout.WaitAndThrowIfTimeout() at Microsoft.Office.Server.Search.Administration.SearchApi.CatalogResumeCrawl(GathererPauseReason reason) at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnBackupComplete(Object sender, SPBackupInformation args) [30/9/2008 3:12:17]: Verbose: Starting object: SharedServices_Default_Search.

  • When you search on a SharePoint site, the performance may sometimes be slow.
  • Search results are not security trimmed for anonymous users who access the sites that have the lockdown feature activated.
    MOSS
    • The UserProfileChangeService service does not report user deletions.
    • If blob caching is enabled for a Web site, you cannot download files whose size is more than 32 megabytes (MB) from that Web site.
    • When you open a SharePoint Search site by using SharePoint Designer, the W3wp.exe process crashes.
    • You create a new page based on the "(Welcome Page) Welcome page with summary links" page layout. You add a new link to the Summary Links Web part, and you use a URL that starts with "mms://". However, the newly added link is an empty link.
    • You convert a Word document (.docx) to a Web page on a SharePoint site. However, the multi level numbering is incorrect. For example, 1.1 may be displayed as 0.1.
    • When you use spelling check in a Spanish site, it fails and you may receive the following error message:

      Spell checking is not available for the default language. Choose one of the following languages and click OK to continue spelling, or click Cancel to stop.

    • A Shared Services Timer job opens handles for each task, but the job does not close the handles. Because the type is set to manual reset for these handles, the garbage collector cannot clean them up. Therefore, a handle leak occurs in the Owstimer.exe process.
    • You have a Word document (.docx) that has Track Changes enabled. You convert the Word document to a Web page on a SharePoint site. However, deleted words are displayed in the conversion results as unhidden text.
    • If you disable the Show Subsites option on the navigation settings page and repeatedly visit a subsite, you see high latency and low throughput.
    • The variation engine cannot restore destination page properties if the page contains a Content Query Web part.
    • When you set a publishing time for a page in SharePoint, the publishing time may shift incorrectly if the time zone is not Coordinated Universal Time (UTC). This behavior occurs for the end time too.
    • If you input Date type cells in Excel 2007 files, the XLSX Filter extracts them as numbers.
    • A Variation Page propagation job cannot transfer updated content to target labels if the page has a comma in the URL. This is because the Variation engine cannot find propagated pages that have a comma in the URL.
    • The Business Data List Web part is not using the Regional Settings collation when it sorts the data.
    • When you build an application to control a document library, the SPFolder.CopyTo() API does not increase the List.ItemCount number. This behavior causes inconsistency in the List.
    • The Microsoft PKM Search Filter Daemon (Mssdmn.exe) crashes every 15 seconds when crawled using certificate authentication.
    • When you back up the Shared Search index, it always fails, and you may receive the following error message in the backup log:

      [30/9/2008 2:11:46]: Verbose: Starting object: Shared Search Index. [30/9/2008 3:12:17]: Error: Object Shared Search Index failed in event OnBackupComplete. For more information, see the error log located in the backup directory. WebException: The current operation timed-out after 3600 seconds [30/9/2008 3:12:17]: Debug: at Microsoft.Office.Server.Search.Administration.CatalogPauseTimeout.WaitAndThrowIfTimeout() at Microsoft.Office.Server.Search.Administration.SearchApi.CatalogResumeCrawl(GathererPauseReason reason) at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnBackupComplete(Object sender, SPBackupInformation args) [30/9/2008 3:12:17]: Verbose: Starting object: SharedServices_Default_Search.

    • When you search on a SharePoint site, the performance may be slow.
    • Search results are not properly security trimmed for anonymous users who access the SharePoint sites that have the Lockdown feature activated.
    This release also includes fixes that are described in the following Microsoft Knowledge Base articles:
    • 961176 (http://support.microsoft.com/kb/961176/ ) Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): December 19, 2008

    • 961176 (http://support.microsoft.com/kb/961176/ ) Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): December 19, 2008

    • 963022 (http://support.microsoft.com/kb/963022/ ) Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): January 27, 2009

  • February 24

    The Hosts file – here today, gone today!

    When I set up a SharePoint system, I like to ensure that it’s set up according to Microsoft’s “Least Privilege Access” rule. It means that if the site ever gets compromised, the user has no access to other resources except ones directly related to SharePoint.

    I was at a client’s site recently running an upgrade. Only one failure – It said that it could not find the hosts file… so I recreated the hosts file and reran the upgrade. No problems this time. Once I’d finished however, I noticed that there were a lot of errors coming up in the event log:


    Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (...).

    Reason: Could not find file 'C:\Windows\system32\drivers\etc\HOSTS'.

    Techinal Support Details:
    System.IO.FileNotFoundException: Could not find file 'C:\Windows\system32\drivers\etc\HOSTS'.
    File name: 'C:\Windows\system32\drivers\etc\HOSTS'
       at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at System.IO.FileStream.Init(...)
       at System.IO.FileStream..ctor(...)
       at System.IO.StreamReader..ctor(...)
       at System.IO.FileInfo.OpenText()
       at Microsoft.Search.Administration.Security.HOSTSFile.ParseHOSTSFile(...)
       at Microsoft.Search.Administration.Security.HOSTSFile.ConfigureDedicatedGathering(...)
       at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.SynchronizeDefaultContentSource


    The hosts file had disappeared again. Damn. Recreated it, but in about a minute it went again and these errors started up again. After a quick search, I uncovered this gem of an article which described the issue perfectly. It looks like the testing done for this feature was somewhat flawed.

    The solution is to grant permissions to the folder that the hosts file resides in – once the hosts file is deleted, then the service can recreate the hosts file the way its creator intended.

    Original article was here - http://blogs.msdn.com/jjameson/archive/2007/05/05/the-case-of-the-disappearing-hosts-file.aspx

    Brad

    February 19

    Had an interesting discussion after the last SharePoint User Group

    I really enjoyed myself at the last user group. I was all prepared to snore my way through it, but found that I was actually very interested.

    The usergroup was about Accessibility – a pretty lonely topic, less popular even than Governance. However, the presenter was a hearing-impaired, blind person who gave a very interesting speech. I was delighted because I wasn’t being forced to hear about another vendor product they say is for everyone and I think has an extremely limited scope… and because the presentation was interesting.

    But the most enjoyable part was once the presenter had finished – we started chatting amongst ourselves (there was about 20 people) about what the answer was. How do we make our systems more accessible? What technologies are out there today? Where do we need to be? What are the benefits? Downsides? There were several opinions – Most stemmed from personal experience. From a practical point of view, there were only really 3 things that could be improved - they were:

    1. The tools that visually impaired people use to interact with computer systems needs to be made better
    2. The languages that we use to create and “describe” the user interfaces needs to be made better
    3. The tools that developers use to build the UI need to be made better

    The problem with 1 & 3 is cost and motivation. 2 has already been solved – by using XML, people can create dynamic sites that are engaging and accessible. So what’s stopping a proliferation of web sites running XML with an XSL presentation layer? In the past it was bandwidth. XML is a heavy language – there’s no denying it… but these days bandwidth’s cheap and available to most… so it’s not so much of an issue.
    The tools we have today do not really facilitate using this type of language or developing in this way (that’s 3). Because visually impaired people are a minority, it’s difficult to get the type of private equity money invested into 1 – and if you do, the market is small and people with accessibility issues are generally at the lower end of the socioeconomic scale, making the potential market even smaller.

    The solution seems to be clear – make better developer tools – but an improvement in tools by vendors for something that is not being demanded or mandated is a tough ask (Vendors are looking for the “point of difference” in their product, not the same thing but in a different backend language). In the past, there has been considerable effort put into accessibility when governments started saying things like “We’ll only buy software that meets the following accessibility standards” – in fact, the only reason Windows has them is because governments were about to refuse to buy their OS as it didn’t have it “baked in”. So…

    Maybe what we need is some way for governments to say that they’ll only buy development tools that allow them to build web sites that meet accessibility standards with the same speed that they can build non-accessible sites. Hmmm… that’s a bit hard to quantify or measure. What about “We’ll only buy development tools that give developers the choice of creating the presentation layer of their solutions in either native code or a combination of XML+XSL”. That’s better – at least we can measure that.

    OK… That takes care of the guts of a web page, but how about the slick UI? What about Silverlight? Well… Silverlight uses XML to represent its functionality. It has limitations, but it’s getting there. What about InfoPath? InfoPath forms are ALL XML, with an XSL skin on them that gives them a rich UI experience in Forms Server. So you can see that we’re close. I mean, we have a language that is regarded as “Self-Describing” – that’s XML. We have tools that can have their toolset extended – in VS2008 you can implement your own intellisense for any language you can dream up. People have implemented CAML intellisense for VS2008. In a corporate environment where the devs are using this particular tool, you could conceivably build a corporate standard for XML and an XSL that maps to the corporate tags. XMLSpy has excellent capabilities, but the learning curve is steep.

    So we’re close… we have the capacity to enhance our current tools to meet the need for people with visual impairments. The population is aging, which will only increase the demand for these types of features. We have the language, and the overhead of running a UI layer through XML & XSL is being countered by the increase of available bandwidth to Joe user (even here in Australia, where ADSL1 is still kinda cool). Does anyone else have an opinion on this? Is there a better way to do it? I’m not on a personal crusade here, I don’t know anyone who’s blind, but it seems a bit silly that we’re 90% there and everyone’s looking at everyone else and say “you go first” “no you go first” “no, I insist, after you” etc.

    Anyway, just thought I’d get this down to see if there is a better approach. BTW – SharePoint has an “Accessibility” setting that can be turned on and off. Turning it on reduces some of the slick functionality in the UI but it makes it easier for screen readers to interpret what’s going on and let the users know.

    Lastly, if you are determined to build an accessible site or app the only true test of whether a user interface / web page is accessible is to get a blind person to try it for you. It’s easy to make something that is accessible, but a lot harder to retrofit it.

    Just my thoughts…

    Brad

    February 15

    Charities do it Cheaper!

    CustomWare does a lot of NFP and charity work as well as their commercial work. I was at the SharePoint user group in November ant one of the Microsoft employees there mentioned that there is a site these type of organisations can go to called http://www.donortec.com.au/ - here they can buy software from companies such as Microsoft, Cisco, Flickr etc for a fraction of the cost of going retail. for example:
     
    Office 2007 Professional normally sells at $500US - you can pick up Office 2007 Professional Plus for $30AU. That's a fair slab of savings!
    Or how about...
    SharePoint Server 2007 Enterprise Server? $377. Sweet!