Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SP1 Upgrade Failure

  Asked By: Bradley    Date: Oct 28    Category: MOSS    Views: 866

I tried to upgrade SharePoint with the WSS & MOSS SP1 upgrade and it
failed. I even tried to run the `psconfig –cmd upgrade –force'
command and it also failed.

My setup is: (1 WFE, 1 APP server running search, & 1 SQL server
(2005))

It seems that when I installed SharePoint for my production servers,
I used the RTM version (12.0.0.4518). By using this version, all
databases has this version number except for the SEARCH database
which has a version of (6.0.2.6568) and does not have the
field `SecurityUpdateErrorID' at the end of the `MSSCrawlURL' table.

My question would be:

How would I get the search database corrected in order to run the SP1
upgrade? Any Ideas?

Why would the SERACH table have this version number (6.0.2.6568 - WSS
2.0 SP2) in it for a clean MOSS install (not an upgrade)?


Here is a section from the Upgrade.log.
[SPManager] [DEBUG] [9/26/2008 5:18:24 PM]: [SearchSharedDatabase
Name=SharedServices6_Search_DB Parent=SPDatabaseServiceInstance
Name=SQLSPINTRA] Running 1 of 6 steps

[SearchDatabaseActionForV2V] [12.0.1.0] [DEBUG] [9/26/2008 5:18:24
PM]: Begin Upgrade()
[SearchDatabaseActionForV2V] [12.0.1.0] [DEBUG] [9/26/2008 5:18:24
PM]: Executing search property store database object upgrade script
C:\Program Files\Common Files\Microsoft Shared\Web Server
Extensions\12\Template\SQL\SPS\1033\SEARCHDATADB.SQL on database
SQLSERVER:SharedServices_Search_DB
[SPManager] [DEBUG] [9/26/2008 5:18:29 PM]: SyncUpgradeTimerJob:
sleeping for 10 seconds

[SearchDatabaseSequence] [ERROR] [9/26/2008 5:18:36 PM]: Action
12.0.1.0 of
Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed.
[SearchDatabaseSequence] [ERROR] [9/26/2008 5:18:36 PM]:
Column 'SecurityUpdateErrorID' in table 'MSSCrawlURL' is invalid for
creating a default constraint.
Could not create constraint. See previous errors.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on SP1 Upgrade Failure Or get search suggestion and latest updates.




Tagged: