none
Search Error - There was an exception in the Database

    Question

  • Hello,

    I have SharePoint 2013 farm with search configured and was working fine until the I have installed the latest security updates KB3191886.

    After installing update, search is stopped working with the below exception

    There was an exception in the Database. Please retry your operation and if the problem presists, contact an administrator.

    Correlation ID: 8594029e-517f-008b-0bd3-8b8f786ce72d

    However after tried various methods, strange thing i have noticed that with default url http://<<Server name>> search is working fine and with AAM i.e. http://intranet... it's showing exception.

    I have found on some blogs that uninstalling this update may resolve this issue. Does anyone else face this kind of issue ? or have resolution for this ?

    Thanks

    Mehul Jamod

    Thursday, July 6, 2017 9:44 AM

All replies

  • Hi Mehul, 

    For your issue, try to install the latest SharePoint CU and restarted computers.

    http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=346

    Similar issue post for your reference:

    https://techcommunity.microsoft.com/t5/SharePoint/SharePoint-2013-search-stopped-working-on-the-alternate-access/td-p/73061

    Best Regards, 

    Lisa Chen


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, July 7, 2017 7:40 AM
    Moderator
  • Hi Mehul,

    I am checking to see how things are going there on this issue. Please let us know if you would like further assistance.

    You can mark the helpful post as answer to help other community members find the helpful information quickly.

    You can also share your own solution here and mark it as answer, and we can learn from each other.

    Best Regards, 

    Lisa Chen 

     

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, July 19, 2017 2:25 AM
    Moderator
  • Hi Mehul,

    Is there anything update?

    Please remember to mark the reply as an answer if it helps.

    Have a nice day!

    Best Regards, 

    Lisa Chen


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, July 26, 2017 1:57 AM
    Moderator
  • Lisa,

    Does the latest SharePoint CU need to be installed on all servers in the farm?  We have two WFE servers, one APP server, and one DB server.

    Thanks,

    Dan

    Tuesday, May 1, 2018 2:01 PM
  • Hi Dan,  Sometimes you can run psconfigui.exe on all the servers and this will fix this issue, versus installing the latest CU.  It's also a good idea to let a CU get released for at least 90 days or so before applying it to your production.  Or apply it to a non-prod and thoroughly test it out.  Another thing to try before running psconfig is to clear the SharePoint config cache. 

    Hope this helps,


    Stacy Simpkins | MCSE Productivity | MCSE SharePoint 2013 | anothersharepointblog.com

    Wednesday, May 16, 2018 8:56 PM