Upgrade from TR to RTM Work Around

Looks like at least one problem has snuck through that needs a work around. If you are getting errors like:

User Profiles and Properties Page: An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.

Or

Search Settings: The search service is currently offline. Visit the Services on Server page in SharePoint Central Administration to verify whether the service is enabled. This might also be because an indexer move is in progress.

Then you need to perform the following work around.

  1. Go to the operations tab in Central Administration
  2. Click on services on server
  3. Find the Office SharePoint Server Search and click the Stop button to its right

  4. You will get a message asking "Are you sure you want to uninstall the Office SharePoint Server Search service from this server?" Click OK.
  5. Now go back and start the Office SharePoint Server Search and click Start
  6. Now perform an iisreset.
  7. It sometimes takes up to 5 minutes for search and profiles to begin working.

 

Shane SharePoint Help

Published Fri, Nov 17 2006 4:42 by Shane

Comments

# TR to RTW Upgrade

Thursday, December 07, 2006 6:32 PM by Share This Point

TR to RTW Upgrade

# re: Upgrade from TR to RTM Work Around

Thursday, December 21, 2006 12:26 PM by Sam

when you upgrade from B2TR to the RTM is it required that you install a language package or not?

# re: Upgrade from TR to RTM Work Around

Thursday, December 21, 2006 12:35 PM by Shane

You don't need a language pack unless you are using another language on top of SharePoint.  I would say for most customers the answer to your question is no.

# re: Upgrade from TR to RTM Work Around

Thursday, December 21, 2006 12:42 PM by Sam

Thank you for your reply.

I performed un upgrade from B2TR to RTM step 8 of 9 hang didn't want to finish when I checked the upgrade.log it sleep every 10 seconds its a farm environment.

so then the search service is not working and I can't create new content and everytime I run the configuration wizard it keep saying that cannot upgrade because upgrade is already in progress.

I was thinking of running the spconfig update -force  to stop any current upgrade actions and restart it because I don't think it is done with step 8 of 9 and that was three days ago

any Ideas  

# re: Upgrade from TR to RTM Work Around

Saturday, March 17, 2007 11:40 PM by Dave Chan

I had that error and I performed the steps, still no go.

# re: Upgrade from TR to RTM Work Around

Tuesday, September 18, 2007 2:04 PM by Peter

I have this problem and reset of service with IIS did not help me. any ideas that to do?

# re: Upgrade from TR to RTM Work Around

Sunday, November 18, 2007 5:45 PM by Lester

I had to perform a more indepth correction than the one described above. I was getting this error when I had to restore my farm. In my hours of digging through logs and data, I found a class record (config DB) with an ID of '1AAB936C-E65C-4829-9683-5CCF5BAB90B0' and a name of 'Microsoft.Office.Server.Search.Administration.SearchSharedDatabase, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. My original configuration database contained a corresponding record with this classID specified and my new Farm configuration DB did not have this object record. I performed the following SQL to import the record into my new Farm configuration DB.

INSERT INTO <Current Farm Config DB>.[dbo].[Objects]

          ([Id],[ClassId],[ParentId]

          ,[Name],[Status],[Properties])

SELECT [Id]

     ,[ClassId]

     ,'8C2CB478-1843-4736-A757-0819E70BC1FA'

     ,'NSTG_NSTGSSP_Search_DB'

     ,[Status]

     ,[Properties]

FROM <Farm Config DB From Backup>.dbo.[Objects]

where classid = '1AAB936C-E65C-4829-9683-5CCF5BAB90B0'

The Object.Name is the new SSP Search DB name and the parentID is the ObjectID of your Server(Perform following SQL to find the ID).

Select *

from <Current Farm Config DB>.dbo.objects

where classid = '3112E92F-B97D-481E-8CEB-03FDE15ED1A7'

Note: Once this is done, you need to perform the steps described in the beginning of this post. Don't forget to restart your IIS.

Les Sims

lsims@koincompute.com

Microsoft MCP

# re: Upgrade from TR to RTM Work Around

Monday, February 11, 2008 11:36 AM by Laura

THANKS!!! That did the trick for me, I appreciate your information as I am new working with Sharepoint!

# re: Upgrade from TR to RTM Work Around

Monday, August 25, 2008 9:13 AM by Pooja

I have this problem and reset of service with IIS did not help me. any ideas that to do?

# re: Upgrade from TR to RTM Work Around

Thursday, October 23, 2008 12:08 AM by KrishnaPrasad H.

good trouble shoot. Resolved my nightmare.

Leave a Comment

(required) 
(required) 
(optional)
(required)