Issue

Unable to upgrade ‘MOSS 2007 SP1 + Dec 2008 CU (12.0.0.6335)’ to ‘MOSS 2007 SP2 + Aug 2011 CU (12.0.0.6565)’.  It was getting failed on 8^th – 9^th step while running the ‘SharePoint Products and Technologies Configuration Wizard’ with below error message.

SearchSP2AnchorTextDatabaseAction.Upgrade on database SPDBP\SPDBP:SharedServices1_Search_DB

Action 12.2.506.0 of Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed.

The statistics 'LinkId' is dependent on column 'LinkID'.

Cause

The statistics for ‘LinkID’ and ‘BatchID’ were dependent on column ‘LinkID’ and ‘BatchID’ in ‘SharedServices1_Search_DB’ database and it failed because one or more objects access this column. In order to get this done, dropped and re-created the statistics.

Steps taken to resolve the issue.

·         Drop the statistics for ‘LinkID’ (script attached) and tried to attempt but it got failed on the same step (8^th-9^th) with below error message.

SearchQFE21038DatabaseAction.Upgrade: Changing MSSBatchHistory column BatchID type to bigint on database SPDBP\SPDBP:SharedServices1_Search_DB

Action 12.2.508.0 of Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed.

The statistics 'BatchID' is dependent on column 'BatchID'.

·         Drop the statistics for ‘BatchID’ (script attached) then tried to attempt and again it got failed on the same step (8^th-9^th) with ASP.Net error message.

Action 3.0.3.0 of Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed.

InstallAspNet 1785161557 failed.

·         Re-register the ASP.Net component by running the command ‘aspnet_regiis –u’ and ‘aspnet_regiis –I’

·         Attempt to run ‘SharePoint Products and Technologies Configuration Wizard’ and this time MOSS 2007+SP2 got updated successfully.

·         Next steps to install Aug CU 2011, binary got installed on all servers successfully but when we tried to run ‘SharePoint Products and Technologies Configuration Wizard’ then again it got failed on the same step (8^th-9^th) with time out error message.

Action 12.2.508.0 of Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed to commit.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

·         Restarted the SQL services and SharePoint servers then tried to attempt ‘SharePoint Products and Technologies Configuration Wizard’ and it got completed successfully.

·         Re-created the statistics for ‘LinkID’ and ‘BatchID’ (script attached).

·         Verified the version (12.0.0.6565) from Central Administration -> Operations -> Servers in farm.

Script to drop statistics

/****** Object:  Statistic [LinkId]    ******/

USE [SharedServices1_Search_DB]

GO

if  exists (select * from sys.stats where name = N'LinkId' and object_id = object_id(N'[dbo].[MSSAnchorText]'))

DROP STATISTICS [dbo].[MSSAnchorText].[LinkId]

GO

/****** Object:  Statistic [BatchId]    ******/

USE [SharedServices1_Search_DB]

Go

if  exists (select * from sys.stats where name = N'BatchID' and object_id = object_id(N'[dbo].[MSSBatchHistory]'))

DROP STATISTICS [dbo].[MSSBatchHistory].[BatchID]

GO

Script to create statistics

USE [SharedServices1_Search_DB]

GO

/****** Object:  Statistic [BatchID]    

CREATE STATISTICS [BatchID] ON [dbo].[MSSBatchHistory]([LinkId])

GO

/****** Object:  Statistic [LinkId]    

CREATE STATISTICS [LinkId] ON [dbo].[MSSAnchorText]([LinkId])

GO