Created new content sources for SharePoint Search 2013 a week friday ago, returned content no problem. On the following Monday Search stopped working and displayed the error message "There was an exception in the Database".
In the ULS logs, i got an error messages "System.Data.SqlClient.SqlException (xxxxxxxxx): Could not find stored procedure 'proc_MSS_GetUrlMapping'"
"SqlError: 'Could not find stored procedure 'proc_MSS_GetUrlMapping'.' Source: '.Net SqlClient Data Provider' Number: 2812 State: 62 Class: 16 Procedure: '' LineNumber: 1 Server: 'xxxxxxxxxx\xxxxxxxxx'"
"Exception occured in scope Microsoft.Office.Server.Search.Query.SearchExecutor.ExecuteQueries. Exception=System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: There was an exception in the Database. Please retry your operation and if the problem presists, contact an administrator."
I have tried resetting the index and doing a full crawl etc but no joy. Can anyone help please?
Thanks
Josh