InfoPath Field Limit – Form Fail to Publish

Run into this error, and there wasn’t much info about this issue…  If anyone know anything about this one, please post a solution

– created a InfoPath form

– attempt to promote various field to the Content Type.

– InfoPath fail to publish more than 30 field.  (works perfectly find if I keep the # below 30)

– I read some where there was a hot-fix for it (forgot where), applied it, but still didn’t fix it…

I end up just publishing the form with less than 30 fields


SQL 2005/2008 Mirroring Databases

Was working on mirroring a few SQL databases for Sharepoint.  but keep getting the following error:

– error 1817, fail to connect to the server xxx

– when you check the server’s event log, it mention there were a log showing the 2 SQL server were trying to connect thru anonymous account.

Here is what I did to fix it:

– ensure to use a FQDN  such as

– ENSURE SQL services is running on a Services account AND NOT LOCAL OR NETWORK SERVICES!!!! (this was my problem).

Building Dashboard in Sharepoint using Sharepoint search (with no custom code)

Building Dashboard in Sharepoint using Sharepoint search (with no custom code)

Build a custom dashboard the other day base on the Sharepoint search, want to share with you all how I did it.  Hope someone else will also find this useful.

  • I need to get data from various site collections
  • The users wants to make a Announcements in a site collections and certain Announcements needs to roll up into a page to form a dashboard.
  • These Announcements can be anywhere on the farm.

The good old way to do this would be to create a custom app that loop thru all the pages to Identify all content marked to include in the dashboard.  BUT here is a new way to approach this with NO CUSTOM CODE:

  • Create a new content type for Announcements (its optional, but this way you can save it as a List Template and reuse it)
  • Add a column to the Announcements list, for the purpose of this article we will call it “Announcements Type”, have this as a Choice and set the choice as “Include in Dashboard” and “Exclude in Dashboard” (the name and field type is entity up to you)
  • Let the Sharepoint Search runs a crawl
  • The new column “Announcements Type” should now be available in SSP.  Add this to Metadata Property Mappings in your SSP.  Call it “AnnouncementsTypeData”.  Check the box to allow this metadata to be usable in Scope.
  • Go to the place where you want to have the dashboard and create a “search result page” (or blank  page and then add the Search Core Result web part)).
  • Modify the Search Core web part.
  • Modify the Results Query Options and add AnnouncementsTypeData to Selected Columns in the Search Core Result Web.
  • Create a scope call “Dashboard” and set the rule to include all contents base on the following rule “AnnouncementsTypeData = Include in Dashboard”
  • The Core Search Result should now be able to understand AnnouncementsTypeData.
  • Set the Cross-Web Part query ID not to use User Query, but manually define the Query.
  • Set the Scope in this web parts to “Dashboard”.
  • Save your changes and Exit
  • Now whenever you access this page, you should only see all Announcements that the user mark as Include in Dashboard.
  • To make your dashboard looks better, edit the XSL in the core result (I highly recommend you edit the XSL so it doesn’t look like the sharepoint out of the box search.  I made it so no one notice the back end was base on the sharepoint search J, by editing the XSL you can make it look and feel like a “fancy” dashboard.)

Site Collection templates missing when creating a new site

Run into this problem….  When you try to create a new Site Collection, some of the templates was missing.  In my case, someone manually override the webtemp.xml file.  So here is the path so non of you need to look for it:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\1033\XML\webtemp.xml

This xml file contains the list of site definitions (the templates) and can be marked with an option ‘Hidden=true’, which makes them invisible.

Sharepoint Error 6482: C:\WINDOWS\system32\drivers\etc\HOST access deied

Was getting the following Sharepoint error when I redirect the sharepoint to crawl itself during indexing.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server Shared Services Event ID: 6482
User: N/A
Computer: ******************
Description:Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance Reason: Access to the path ‘C:\WINDOWS\system32\drivers\etc\HOSTS’ is denied.
Techinal Support Details:
System.UnauthorizedAccessException: Access to the path ‘C:\WINDOWS\system32\drivers\etc\HOSTS’ is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append) at System.IO.FileInfo.CreateText() at Microsoft.Search.Administration.Security.HOSTSFile.CleanupDedicatedGathering(Hashtable HOSTSFileMappings, StringBuilder HOSTSComments, IEnumerable obsoleteHosts, String dedicatedName, Boolean isDirty) at Microsoft.Search.Administration.Security.HOSTSFile.ConfigureDedicatedGathering(SearchServiceInstance searchServiceInstance, SPServer dedicatedWebFrontEndServer, IList`1 previousWebApplicationHostNames) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.SynchronizeDefaultContentSource(IDictionary applications) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize() at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

It turns out that you need to give permissions to c:\Windows\System32\Drivers\etc folder for the wss_admin_wpg account  (a local account group):
• Read & Execute
• Modify
• Read
• Write
The reason is because when you have the server crawl itself when indexing, Sharepoint manually insert items in the hosts files to force the server to crawl itself (kind of a stupid design…), so the group will needs to have write access to the files

Sharepoint Site Colleciton and Subsite Template Numbers and Names

Was doing an import/export of a subsite.  Got an Error:

 Cannot import site. The exported site is based on the template STS#0 but the destination site is based on the template CMSPUBLISHING#0. You can import sites only into sites that are based on same template as the exported site.

So here is a list of the template number and its name

•Team Site, STS#0
•Blank Site, STS#1
•Document Workspace, STS#2
•Basic Meeting Workspace, MPS#0
•Blank Meeting Workspace, MPS#1
•Decision Meeting Workspace, MPS#2
•Social Meeting Workspace, MPS#3
•Multipage Meeting Workspace, MPS#4
•Business Activity Services Team Site, BAS#0
•SharePoint Portal Server Site, SPS#0
•SharePoint Portal Server Personal Space, SPSPERS#0
•SharePoint Portal Server My Site, SPSMSITE#0
•Contents area Template, SPSTOC#0
•Topic area template, SPSTOPIC#0
•News area template, SPSNEWS#0
•News Home area template, SPSNHOME#0
•Site Directory area template, SPSSITES#0
•SharePoint Portal Server BucketWeb Template, SPSBWEB#0
•Community area template, SPSCOMMU#0

MOSS 2007 intenral version number

Here is a list of MOSS 2007 version.  Can also be found in:

SharePoint 2007 Version/Release Microsoft Support KB Reference Version Number from Central Admin Release Date
MOSS 2007 or WSS 3.0 June 2010 Cumulative Update KB983310/KB983311 June 2010
MOSS 2007 or WSS 3.0 April 2010 Cumulative Update KB981042/KB981043 April 2010
MOSS 2007 or WSS 3.0 February 2010 Cumulative Update KB977026/KB977027 February 2010
MOSS 2007 or WSS 3.0 December 2009 Cumulative Update KB977026/KB977027 15 December  2009
MOSS 2007 or WSS 3.0 October 2009 Cumulative Update KB974988/KB974989 27 October 2009
MOSS 2007 or WSS 3.0 August 2009 Cumulative Update KB973409/KB973410 25 August 2009
MOSS 2007 or WSS 3.0 June 2009 Cumulative Update KB971537/KB971538 20 July 2009
MOSS 2007 or WSS 3.0 April 2009 Cumulative Update KB968851/KB968850 30 April 2009
MOSS 2007 or WSS 3.0 SP2 KB953334/KB953338 28 April 2009
MOSS 2007 or WSS 3.0 Cumulative update KB956056/KB956057 16 September 2008
MOSS 2007 or WSS 3.0 Infrastructure Update KB951695/KB951297 15 July 2008
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB948945 21 February 2008
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB941274 31 January 2008
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB941422 26 February 2008
MOSS 2007 or WSS 3.0 SP1 KB936984/KB936988 8 December 2007
MOSS 2007 or WSS 3.0 Security Bulletin MS07-059 KB942017 9 October 2007
MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package KB941422 (updated) 24 August 2007
MOSS 2007 or WSS 3.0 RTM [Released To Manufacturing] N/A 16 November 2006
MOSS 2007 or WSS 3.0 Beta 2 TR N/A 2006
MOSS 2007 or WSS 3.0 Beta 2 N/A 2006