Error when creating a search service application in SharePoint 2013

I'm migrating a SharePoint 2010 environment to 2013. The 2010 environment is fairly simple as it only contains documents. However, after I migrated all the content and service application databases. I tried to create a Search Service Application using both CA and PowerShell.

Both times I received the following error:

Could not find stored procedure dbo.prc_TenantLog_CreateTVFs

I tried searching the old SharePoint 2010 databases and was unable to locate the stored proc anywhere. I tried searching the internet and could not find anyone with the same issue. Is there a CU update that I need to install?

Hope someone can help

May 22nd, 2015 12:23pm

Hi,

Can you please if this gives you some idea

https://spjoel.wordpress.com/2012/08/06/could-not-find-stored-procedure-dbo-search_getrecentstats/

Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 2:40pm

I think that might have worked.  I also tried some other things like deploying a wsp file that was missing from the old farm and not renaming the DB like I was doing.  I'm going to review it some more but for now it looks like it's working
May 22nd, 2015 3:09pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics