<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://msmvps.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx</link><description>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</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 SP2 (Build: 40407.4157)</generator><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#1651720</link><pubDate>Thu, 23 Oct 2008 05:08:37 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1651720</guid><dc:creator>KrishnaPrasad H.</dc:creator><description>&lt;p&gt;good trouble shoot. Resolved my nightmare.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1651720" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#1645729</link><pubDate>Mon, 25 Aug 2008 14:13:45 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1645729</guid><dc:creator>Pooja</dc:creator><description>&lt;p&gt;I have this problem and reset of service with IIS did not help me. any ideas that to do?&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1645729" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#1508514</link><pubDate>Mon, 11 Feb 2008 17:36:43 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1508514</guid><dc:creator>Laura</dc:creator><description>&lt;p&gt;THANKS!!! That did the trick for me, I appreciate your information as I am new working with Sharepoint!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1508514" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#1332516</link><pubDate>Sun, 18 Nov 2007 23:45:23 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1332516</guid><dc:creator>Lester</dc:creator><description>&lt;p&gt;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 &amp;#39;1AAB936C-E65C-4829-9683-5CCF5BAB90B0&amp;#39; and a name of &amp;#39;Microsoft.Office.Server.Search.Administration.SearchSharedDatabase, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c&amp;#39;. 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. &lt;/p&gt;
&lt;p&gt;INSERT INTO &amp;lt;Current Farm Config DB&amp;gt;.[dbo].[Objects]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ([Id],[ClassId],[ParentId]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ,[Name],[Status],[Properties])&lt;/p&gt;
&lt;p&gt;SELECT [Id]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;,[ClassId]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;,&amp;#39;8C2CB478-1843-4736-A757-0819E70BC1FA&amp;#39;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;,&amp;#39;NSTG_NSTGSSP_Search_DB&amp;#39;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;,[Status]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;,[Properties]&lt;/p&gt;
&lt;p&gt;FROM &amp;lt;Farm Config DB From Backup&amp;gt;.dbo.[Objects]&lt;/p&gt;
&lt;p&gt;where classid = &amp;#39;1AAB936C-E65C-4829-9683-5CCF5BAB90B0&amp;#39;&lt;/p&gt;
&lt;p&gt;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).&lt;/p&gt;
&lt;p&gt;Select *&lt;/p&gt;
&lt;p&gt;from &amp;lt;Current Farm Config DB&amp;gt;.dbo.objects&lt;/p&gt;
&lt;p&gt;where classid = &amp;#39;3112E92F-B97D-481E-8CEB-03FDE15ED1A7&amp;#39;&lt;/p&gt;
&lt;p&gt;Note: Once this is done, you need to perform the steps described in the beginning of this post. Don&amp;#39;t forget to restart your IIS.&lt;/p&gt;
&lt;p&gt;Les Sims&lt;/p&gt;
&lt;p&gt;lsims@koincompute.com&lt;/p&gt;
&lt;p&gt;Microsoft MCP&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1332516" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#1204771</link><pubDate>Tue, 18 Sep 2007 19:04:45 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1204771</guid><dc:creator>Peter</dc:creator><description>&lt;p&gt;I have this problem and reset of service with IIS did not help me. any ideas that to do?&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1204771" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#690236</link><pubDate>Sun, 18 Mar 2007 04:40:48 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:690236</guid><dc:creator>Dave Chan</dc:creator><description>&lt;p&gt;I had that error and I performed the steps, still no go.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=690236" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#440783</link><pubDate>Thu, 21 Dec 2006 18:42:59 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:440783</guid><dc:creator>Sam</dc:creator><description>&lt;p&gt;Thank you for your reply.&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;I was thinking of running the spconfig update -force &amp;nbsp;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&lt;/p&gt;
&lt;p&gt;any Ideas &amp;nbsp; &lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=440783" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#440772</link><pubDate>Thu, 21 Dec 2006 18:35:29 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:440772</guid><dc:creator>Shane</dc:creator><description>&lt;p&gt;You don't need a language pack unless you are using another language on top of SharePoint. &amp;nbsp;I would say for most customers the answer to your question is no.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=440772" width="1" height="1"&gt;</description></item><item><title>re: Upgrade from TR to RTM Work Around</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#440763</link><pubDate>Thu, 21 Dec 2006 18:26:06 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:440763</guid><dc:creator>Sam</dc:creator><description>&lt;p&gt;when you upgrade from B2TR to the RTM is it required that you install a language package or not? &lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=440763" width="1" height="1"&gt;</description></item><item><title>TR to RTW Upgrade</title><link>http://msmvps.com/blogs/shane/archive/2006/11/17/upgrade-from-tr-to-rtm-work-around.aspx#403706</link><pubDate>Fri, 08 Dec 2006 00:32:37 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:403706</guid><dc:creator>Share This Point</dc:creator><description>&lt;p&gt;TR to RTW Upgrade&lt;/p&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=403706" width="1" height="1"&gt;</description></item></channel></rss>