Tag Archive: SharePoint 2013

Recently I have the issue with Search Service Servicece Application on SharePoint 2013 onprimise. This issue make all Search Query webpart and any search feature on farm come to Unexpected error. From the Correlation ID,  ULS logs show the error message “Index lookup failed to work since no active index cell was available

After several hours investigated, the problem is recognized from Index Partition and SharePoint Search Host Controller service

Reason: The problem come from Search Service Application.
System have error with Index Partition components, so all content query from web pages and SharePoint sites can not render correctly to show.
To check this component, you can follow SharePoint Powershell script to check for Index Component State
PS > $ssa = Get-SPEnterpriseSearchServiceApplication
PS > Get-SPEnterpriseSearchStatus -SearchApplication $ssa -Text
Resolution: We tried to Reconfigure Indexing component from SharePoint Search Service Application and clean up error indexing content by following steps
Step 1: Check if Search Service Application Crawling and Indexing are Running or Paused.
You can run this command in the SSA management console to verify if the Search Service Application is paused.
$ssa.IsPaused() -ne 0
If ourput of this command returns False, the SSA is running. If this command returns True, the SSA is paused and you have to turn it to running. This article will tell you more about Paused reasons https://technet.microsoft.com/en-us/library/dn745901(v=office.15).aspx
Common error cases message: ‘Search Service Application’ is paused for with reason(s) other than Index Repartitioning.
If you don’t care about Paused reason, you can run below command try to force the SSA to resume:
$ssa.ForceResume($ssa.IsPaused())If you still not get Resume SSA successful, just skip this step and go to Step 2

Step 2: Run Services.msc with Administrator permission and try to stop following services:
SharePoint Timer Service
SharePoint Search Host Controller

Step 3:  Delete all content of data directory from locationC:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Applications\Search\Nodes\[Hex ID\IndexComponentN\storage\data\* (noted that: If you installed SharePoint folder in other drive, just change C drive your your installed foder)

Then restart services “SharePoint Timer Service” and “SharePoint Search Host Controller”

Step 4: Reset Search Indexing content

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
  2. On the Manage Search Applications page, click the Search service application for which you want to reset the search index.
  3. On the Search Administration page, under System Status, verify that the Administrative status of the Search service application is Running and not Paused.
  4. On the Search Administration page, in the Crawling section, click Index Reset.
  5. On the Index Reset page, verify that the Deactivate search alerts during reset check box is checked, and then click Reset Now.
  6. In the confirmation dialog box that appears, click OK to confirm that you want to reset the index.

Step 5: Start Full Crawl again.

Since we reset indexing conten, you need re-run full craw to make Search Service App crawl all configured content to make search data available

After finished steps, Search Topology should be works fine with green check as below



Root cause: The problem may come from Windows Update on Jan 2016, so SharePoint server was automatically run Windows update and installed for many packages from Microsoft. It may impacted to SharePoint Search Service and Index partition was interrupted.
SharePoint Search Architecture

SharePoint Search Architecture

Thank you for your time to join with us SharePoint User Group yesterday.
It’s really great to meet you again after 5 months from the last SPUG. We have a awesome presentation with Thuan Nguyen on building a scalable Search architecture in SharePoint 2013
We want to thanks our sponsors Infragistics and Nintex who would provide many gifts as well.

Below is the presentation yesterday

SharePoint 2013 – CSOM

Since SharePoint 2010, Microsoft announced Client object model to developer community and it really help to extent SharePoint to many other platform.  SharePoint client object model (CSOM) allow you to manage data in SharePoint such as list data, user profile, ….

In SharePoint 2013, I’m very impressive with CSOM since it support for multiple plat for

  • .NET Framework redistributable assemblies
  • JavaScript library
  • REST/OData endpoints
  • Windows Phone assemblies
  • Silverlight redistributable assemblies

This artile show a code snippet for demo how to get user from a list data

        public static User GetUserFromAssignedToField() 
            string strUrl="http://" + Environment.MachineName; 
            // create site context 
            ClientContext ctx = new ClientContext(siteUrl); 
            // create web object 
            Web web = ctx.Web; 
            // get Tasks list 
            List list = ctx.Web.Lists.GetByTitle("MyList"); 
            // get list item using Id e.g. updating first item in the list 
            ListItem targetListItem = list.GetItemById(1); 
            // Load only the assigned to field from the list item 
                             item => item["AssignedTo"]); 
            // create and cast the FieldUserValue from the value 
            FieldUserValue[] fuv = (FieldUserValue[])targetListItem["AssignedTo"]; 
            User user = null; 
            for (int i = 0; i < fuv.Length; i++) 
                Console.WriteLine("Retrieved user Id is: {0}", fuv[i].LookupId); 
                Console.WriteLine("Retrieved login name is: {0}", fuv[i].LookupValue); 
                user = ctx.Web.EnsureUser(fuv[i].LookupValue); 
            return user; 

For more detail about CSOM: You can find at on MSDN http://msdn.microsoft.com/en-us/library/office/fp179912(v=office.15).aspx

Hoang Nhut NGUYEN

We are delighted to announce that the Call for Speakers for the 7th SharePoint Saturday Vietnam is now officially open.

If you are interested in speaking at SharePoint Saturday Vietnam on January 11th, 2014, please fill and submit the Speaker Submission Form (http://sdrv.ms/Hw8yKd) and sent it back to us at spsvietnam@live.com

The Call for Sponsors is out as well. Sponsorships help us provide the necessary resources to facilitate the event. If you are interested, please download and review sponsorship document (SPSVN Sponsorship Package – 7thspsvn). If there are any questions or want so sponsor an item, please email spsvietnam@live.com. Sponsorship for SharePoint Saturday Vietnam is on a first come first serve basis.

Join SharePoint architects, developers, and other professional that work with the Microsoft SharePoint platform for the 7th SharePoint Saturday Vietnam in Ho Chi Minh City. SharePoint Saturday Vietnam will be an educational, informative, and interactive day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-orientated topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse yourself in SharePoint.


SharePoint 2013 Installation

SharePoint 2013 was released about Jul 2012. I did some test in some new and interesting features such as
– More social
– New Service Applications
– Modern (Metro) style solution
– SharePoint App and App Store
– OAuth Authentication Support
– SharePoint Duet
– New Versioning
– SharePoint 2013 and Infopath Office 15
– SharePoint and Biztalk integration
– ….
Today I would like to write article series about SharePoint 2013 preview version.
In this version, Microsoft provide 2 options for download
SharePoint Foundation 2013 Preview
Microsoft SharePoint Server 2013 Preview (Installation Key: 6RNT8-XV26M-GWH36-VMGQH-94MMH)
– And SharePoint Designer 2013 review version also introduced.

This article, I would like to walk through installation and trouble shooting. Before start, you should refer to hardwares and softwares requirements.
In totally, it required for 64bit platform with 64-bit edition of SQL Server 2008 R2 Service Pack 1 and Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter or the 64-bit edition of Windows Server 2012 Release Candidate Standard, Enterprise, or Datacenter.
If you got this error message on starting as below, Don’t forget to install Service Pack 1 if you have Windows Server 2008 R2 already, download at http://download.microsoft.com/download/0/A/F/0AFB5316-3062-494A-AB78-7FB0D4461357/windows6.1-KB976932-X64.exe

After completed Windows 2008 R2 SP1, it’s now ready to install Prerequisites

Use product key from MS site

Installation progress about 10-15 minutes

After intallation finished, system will ask you to start for Configuration Wizard, just say Yes to open PSConfig.  A message will be shown as below. Click Yes to confirm and start the wizard.

Input Database server and database name. Make sure Database access account have write permission on DB server.

Give the passphrase, this password will be used to add more front-end server to farm or uninstall

You should specify easy remember port number instead of default.

Configuration progress about 10minutes.

After finished configuration process, it will show you Central Administration page for initial farm configuration. A helper popup will show, select No to skip the introduction

In Initial Farm Configuration Wizard, I select “Cancel”, you can select “Start the Wizard” to make SharePoint setup all Service Application automatically, but in my experience, you should handle by your self to define data table name and avoid losing of memory from unused service applications

Finally, you have Central Administration page for SharePoint 2013 as below.

Next articles, we will go through setting up for important service applications.

SharePoint 2013 – Setup Secure Store Service

Hoang Nhut Nguyen

Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen

This article wil introduce how to setup SharePoint enterprise search in SharePoint 2013 and how to manage crawled properties which will be indexed and queryable.

1. Create Search Service Application Proxy

Login Central Administration with Farm Administrator permission, click on Manage Service Applications under Application Management section. Click on New ribbon in top left corner and select Search Service Application from menu


In Create New Search Service Application dialog, input appropriated settings as below. In this sample, I would like reuse existed SharePoint Service Application, you can also create new application pool for this Search Service


Click OK to finish and wait for processing, the result should be like this



2. Configure Content Sources

Back to Central Admin page -> Application Management -> Manage service applications. In the service application list, you can see Search Service Application which just created above. Click on it to open manage page

At Search Service Application page click Content Source in left menu and edit Local SharePoint sites content source


You can verify in address box, there are will list all site address which will be lookup for crawling. If there are missing address, you can add more by typing in a new line. Notice that sps3 protocal is using to index for User Profile property which are managed by User Profile Service Application, and the port is My Site’s port


3. Set Crawl scheduler

At Manage Content Source page, select Edit in current content source. Then click on Create Schedule under Crawl Schedules.



Manage Schedules dialog will display and allow you to setting



4. Manage Crawled properties

In SharePoint 2013, Search service application’s navigation has some changes, and Metadata Property in left menu was changed to Search Schema.


By click on this menu item, system will show you Managed Properties, here is the place you can manage what data will be crawled and queryable in search scopes.


To add new property, click New Managed Property, and fill Property NameType of informatoin of property, make sure checked on Searchable and Queryable, select other options with your expectation.


At Mappings to crawled properties section, you need to define what data information will map to this property, it can be a list columns, a user profile property,…. Click Add a Mapping to find your data. A selection popup will show as below


Click Add and then OK to finish adding new property.

Finally, Start Full Craw by come back to Content Sources management page, select Content Source’s menu and click Start Full Crawl

For others option configuration in search service application, you can find more at Technet Microsoft site


Hoang Nhut Nguyen

Email: nhutcmos@gmail.com

Skype: hoangnhut.nguyen
%d bloggers like this: