Search Service Application stuck on Starting

-
Hi Guys,

I was facing a very strange issue since two three days. I just wasted lot of my time while solving it. After experiencing SharePoint 2013 service architecture, I was under the impression that MS have modified SharePoint this time that one will never face any issue while configuring the service applications.

But I was wrong, I am talking about the Search service application here. If you are lucky then it may be the case that you will not see this issue but I wasn't actually explored the reason behind the issue.

Issue Description:

  1. “Unable to retrieve topology component health states. This may be because the admin component is not up and running.”

  2. The default content source “Local SharePoint Sites” is inconsistent. It doesn’t always appear after creation of Search, sometimes with start addresses of existing web apps listed already, other times not.

  3. Starting a full crawl results in stuck in ‘starting’.


                       ssa-bad

Tried Solutions:

  1.  Installed all hotfixes by following this post.

  2. Configure the Noderunner by following this post.


Solution:

I got disappointment after trying above solutions. Then one of my colleague helped my out finding the worked solution. Then I released that we are the same .Net developers having dependency on SQL server. I ran following script to fix the database issues and that worked for me. I am sharing queries as below:

EXEC sp_resetstatus 'WSS_Content'
ALTER DATABASE WSS_Content SET EMERGENCY
DBCC checkdb('WSS_Content')
ALTER DATABASE WSS_Content SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('WSS_Content', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [WSS_Content]  SET MULTI_USER

NOTE: Please change the name of the database. By default sharepoint creates the database with the name Wss_Content but make sure that you have this database in the SQL server. Other way to find the content database is navigate to Central Admin > Application management > Content Database.

I would like to mention one more important point here that you should execute these queries one after another. Because It may hours to fix the content database depending upon the size of the database.

Note: Don't Execute commands in one shot

You defiantly will get success like me :)

ssa-good

Happy Sharepointing :)

Comments

  1. AnnaAugust 27, 2014 at 6:33 AM

    Hi
    Can you explain a bit more what was the purpose of this query and what promoted you to create this query, mean the root cause of the problem etc.

    Because you are running a query in SharePoint Db which should not be touched as MS suggest so strongly I think we need to know what we are performing here.

    BR

    Anna

    ReplyDelete
  2. mohitvashAugust 28, 2014 at 3:13 AM

    Hi Anna,

    Really appreciated your concerns, Please find your answers as below:
    1) "what was the purpose of this query": To Repair the database and allow data loss.
    2) "What promoted you to create this query": The search service was not configuring on the server which promoted me to use this query.

    This query does not alter anything from the SP DB except below command:
    DBCC CheckDB (‘WSS_Content’, REPAIR_ALLOW_DATA_LOSS)

    Command written above executes and repairs the database losses. Thatz all.

    Let me know if still you need clarification.

    Regards
    Mohit Vashishtha

    ReplyDelete

Post a Comment

Popular posts from this blog

Hide Ribbon on SharePoint 2013 using CSS

-
Hi Guys, I recently experienced the migration from SharePoint 2010 to 2013. I was earlier hiding Ribbon using the SPSecurityTrimmedControl and CSS. But in SP 2013 MS has divided whole ribbon in two section: s4-ribbonrow and suiteBar Hiding the ribbon is as much as easier as it was in 2010 version. But here we just need to take care of above two mentioned sections. I have gone thorough some of the blogs where people are saying that we have change the html file(Seattle.html or oslo.html) and design manger will take care of creating master page for you (ref: Hide Ribbon ). But there is another traditional way of doing same, follow the given steps: 1) Open the master page file in the SharePoint designer. 2) Add the style tag to hide the ribbon for all the user: #s4-ribbonrow, #suiteBar { display : none; } 3) Now we have to do some more changes so that at least system account can access the ribbon. Find out the <div id="s4-ribbonrow"> tag. 4) Insert the following code insi
Read more

Get Comment Count in SharePoint

-
Hi Guys, In this blog I will explain how we can get the number of comments on any page/article. Prerequisites for this blog are: a list with rating enabled, an article/page/splistItem already have got comments from users and a tool like VS to code ;) According to requirement it may be the case that one need to get item comment count using java script or c#. I will explain both way to get the comment count: Using Javascript: This may be the case when one want to use the content search webpart or CQWP to display comment count. Followng code can be use to get the comment Count: var linkURL = $getItemValue(ctx, "Link URL"); linkURL.overrideValueRenderer($urlHtmlEncode); // Get the Comments count var soapEnv = "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \ <soap:Body>    \ <CountCommentsOnUrl xmlns='http://mi
Read more

Configure external site as content sources in sharepoint search

-
Image
Hi, In my previous post( Creating and configuring Search service application ) I explained how to configure the search service application and its configuration. We can also search the external sites content using the SharePoint search just by creating new content source. Follow the given steps to create the new content source for external site. To get to the Manage Content Sources page Verify that the user account that is performing this procedure is a service application administrator for the Search service application. On the Home page of the SharePoint Central Administration Web site, in the Application Management section, click Manage service applications . On the Manage Service Applications page, click Search Service Application . On the Search Administration Page, in the Crawling section, click Content Sources .                     After clicking on the link you will be redirected to the page where all the available content sources are displayed.                    To
Read more