Posted on May 22, 2010 by Yiu San Ho
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
Filed under: Form Services / Infopath / Form Server, Sharepoint MOSS SPS WSS | Tagged: Infopath Field Limit Form Fail to Publish | Leave a comment »
Posted on May 15, 2010 by Yiu San Ho
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 sqlserver1.abc.local
– ENSURE SQL services is running on a Services account AND NOT LOCAL OR NETWORK SERVICES!!!! (this was my problem).
Filed under: Sharepoint MOSS SPS WSS, SQL | Tagged: SQL 2005/2008 Mirroring Databases | Leave a comment »
Posted on April 21, 2010 by Yiu San Ho
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.)
Filed under: MS Search Server, Sharepoint MOSS SPS WSS | Tagged: Building Dashboard in Sharepoint using Sharepoint search (with no custom code) | Leave a comment »
Posted on March 16, 2010 by Yiu San Ho
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.
Filed under: Sharepoint MOSS SPS WSS | Tagged: Site Collection templates missing when creating a new site | Leave a comment »
Posted on March 9, 2010 by Yiu San Ho
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
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
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
Filed under: Sharepoint MOSS SPS WSS | Tagged: Sharepoint Error 6482: C:\WINDOWS\system32\drivers\etc\HOST access deied | Leave a comment »
Posted on February 16, 2010 by Yiu San Ho
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
Filed under: Sharepoint MOSS SPS WSS | Tagged: Sharepoint Site Colleciton and Subsite Template Numbers and Names | Leave a comment »
Posted on February 15, 2010 by Yiu San Ho
Here is a list of MOSS 2007 version. Can also be found in: http://blogs.kma-llc.net/microknowledge/2010/01/january-2010-update-sharepoint-2007-internal-version-numbers.html
|SharePoint 2007 Version/Release
||Microsoft Support KB Reference
||Version Number from Central Admin
|MOSS 2007 or WSS 3.0 June 2010 Cumulative Update
|MOSS 2007 or WSS 3.0 April 2010 Cumulative Update
|MOSS 2007 or WSS 3.0 February 2010 Cumulative Update
|MOSS 2007 or WSS 3.0 December 2009 Cumulative Update
||15 December 2009
|MOSS 2007 or WSS 3.0 October 2009 Cumulative Update
||27 October 2009
|MOSS 2007 or WSS 3.0 August 2009 Cumulative Update
||25 August 2009
|MOSS 2007 or WSS 3.0 June 2009 Cumulative Update
||20 July 2009
|MOSS 2007 or WSS 3.0 April 2009 Cumulative Update
||30 April 2009
|MOSS 2007 or WSS 3.0 SP2
||28 April 2009
|MOSS 2007 or WSS 3.0 Cumulative update
||16 September 2008
|MOSS 2007 or WSS 3.0 Infrastructure Update
||15 July 2008
|MOSS 2007 or WSS 3.0 post-SP1 hotfix
||21 February 2008
|MOSS 2007 or WSS 3.0 post-SP1 hotfix
||31 January 2008
|MOSS 2007 or WSS 3.0 post-SP1 hotfix
||26 February 2008
|MOSS 2007 or WSS 3.0 SP1
||8 December 2007
|MOSS 2007 or WSS 3.0 Security Bulletin MS07-059
||9 October 2007
|MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package
||24 August 2007
|MOSS 2007 or WSS 3.0 RTM [Released To Manufacturing]
||16 November 2006
|MOSS 2007 or WSS 3.0 Beta 2 TR
|MOSS 2007 or WSS 3.0 Beta 2
Filed under: Sharepoint MOSS SPS WSS | Tagged: MOSS 2007 intenral version number | Leave a comment »