Posts

Showing posts from June, 2014

SharePoint 2013 - Indexed Property Keys

Image
One of the cool features in SharePoint 2013 is the ability to index site property bag values and use them in search results page through display template. To make it work, you'll need to do the following steps Add Property Key through PowerShell (or you can do it programmatically.  I'll explain later) $web = Get-SPWeb http://test.fakesite.com $web.AllProperties["SiteContact"] = “Richard” $web.IndexedPropertyKeys.Add(“SiteContact”) $web.Update() Full or incremental crawl.  Make sure you can see the crawled property from the search service application Create Managed Property that maps to the crawled property Once the managed property is created and setup properly (i.e. searchable, queryable, ...etc), then you can use it in display template.  In the example below, I created a custom display template based on Community Portal Popular Communities template and use the SiteContact property to display Primary Contact name. To do it p

SharePoint 2013 App Details Page Error

Image
Out of no where, the app details page started throwing out error for all apps. ULS log entries System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'prc_CountAppInstanceData', database 'UsageAndHealth_Logging_DB', schema 'dbo'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()     at System.Data.SqlClient.SqlDataReader.get_MetaData()     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBe

SharePoint 2013 Search Index Issue - Troubleshooting

Image
Recently, I'm having problem with my search.  I keep getting the following error. When I check the Search Application, I would see warning icon for the index partition and searchable items would have errors on them. In URL log, I see the following two error (Unexpected and Critical) resepectively Microsoft.Ceres.InteractionEngine.Component.FlowHandleRegistry : Exceptions occurred when evaluating the flow.  Microsoft.Ceres.Evaluation.DataModel.EvaluationException: Cannot plan query for index system SP6a8f863b8e85. Index fragment '0' has no available cells. Cell statuses: [Cell I.0.0 on node IndexComponent1: Cell status is set to 'not available' (cell out of sync or seeding)]    at Microsoft.Ceres.Evaluation.Engine.ErrorHandling.HandleExceptionRecordSetSink.DoWithTryCatch(IRecord record)    at Microsoft.Ceres.InteractionEngine.Component.FlowHandleRegistry.SubmitData(FlowExecutionInfo handle, InputData inputData, Stopwatch timer, String correlation