Re: Search not working after upgrading MOSS server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



You may need to apply the service pack again. It looks like the database and code base are not the same version level.

--
Bryan Phillips
MCT, MCSD, MCDBA, MCSE
Microsoft MVP - Client Application Development
Blog: http://bphillips76.spaces.live.com
Web Site: http://www.composablesystems.net



"Gudni" <Gudni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:218FEEF5-B270-4CE6-8E02-25ED24E2734A@xxxxxxxxxxxxx:

Hi hi

After upgarding the server with Service Pack 1 for the Office Sharepoint
Server 2007 I'm having an Error like below on page
/admin/_layouts/listcontentsources.aspx

Could not find stored procedure 'dbo.proc_MSS_GetCrawlHistory'. at
Microsoft.SharePoint.Portal.Search.Admin.Pages.SearchAdminPageBase.ErrorHandler(Object sender, EventArgs e)
at
Microsoft.SharePoint.Portal.Search.Admin.Pages.SearchSSPAdminPageBase.OnError(EventArgs e)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP._layouts_listcontentsources_aspx.ProcessRequest(HttpContext
context)
at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)

while clicking the Configure Search Settings -->Content sources and crawl
schedules, and the Search Results for the content sources have been stopped
due to this problem.

The search database (SharedServices2_Search_DB) is running on sql express on
the same server. I'm not finding this stored procedure in this Database.

I really need a solution to this!

Best Regards

Guðni

.



Relevant Pages

  • Re: Quiet in here today
    ... who hates that he has to apply the SQL service pack individually to ... each database instance. ... I noticed that when I recently patched SQL Server 2005. ...
    (uk.games.video.misc)
  • Re: Server setup
    ... Informix database running on the same server. ... the Informix server seems to crap out and about once a week the database service stops running and cannot be restarted. ... Which service pack for Win2K? ...
    (comp.databases.informix)
  • Re: ImpersonationMode that is reserved for server administrators
    ... giving the deployer an unacceptable permission level. ... the Analysis Services server role, ... "The database, 'ASO_StatisticalAnalysis', contains an ImpersonationMode ... We have tried with both Service Pack 1 and Service Pack 2. ...
    (microsoft.public.sqlserver.olap)
  • Re: Move SharePoint & Project Server to New Servers Using SQL Serv
    ... doing a database migration to a new environment. ... I would consider it wise to upgrade your Server A to WSS SP2 and Project ... SQL Server 2005 - have a better chance of being so). ... Windows Server 2003 Enterprise Edition (no service pack) ...
    (microsoft.public.sharepoint.windowsservices)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)