SharePoint WSS V2-to-V3 migration
Attempting to do a gradual upgrade from WSS v2 to v3 (which I successfully performed on test system). Doing it in production however and I'm getting the following error indicating Schema Mismatch:
[SPServerSequence] [DEBUG] [9/11/2010 12:56:47 AM]: [SPServer Name=STLSOISQL2005 Parent=SPFarm Name=wss_f1_config] BuildVersion = 12.0.0.6421.
[SPServerSequence] [DEBUG] [9/11/2010 12:56:47 AM]: [SPServer Name=STLSOISQL2005 Parent=SPFarm Name=wss_f1_config] SchemaVersion = 3.0.2.0.
[SPServerSequence] [DEBUG] [9/11/2010 12:56:47 AM]: [SPServer Name=STLSOISQL2005 Parent=SPFarm Name=wss_f1_config] BuildVersion = 12.0.0.6421.
[SPServerSequence] [DEBUG] [9/11/2010 12:56:47 AM]: [SPServer Name=STLSOISQL2005 Parent=SPFarm Name=wss_f1_config] SchemaVersion = 3.0.2.0.
[SPUtility] [DEBUG] [9/11/2010 12:56:49 AM]: File C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Template\sql\store.sql, Time out = 600 sec
[SPSiteCollectionMigrator] [DEBUG] [9/11/2010 12:57:02 AM]: PregrowTempDatabase: computing the size of temp db.
[SPSiteCollectionMigrator] [DEBUG] [9/11/2010 12:57:02 AM]: PregrowTempDatabase: target size 2560 MB.
[SPSiteCollectionMigrator] [DEBUG] [9/11/2010 12:57:02 AM]: SPContentDatabase2 Name=sts_intranet Parent=SPDatabaseServiceInstance Name=stlgp1 FullTextSearchEnabled: True
[SPSiteCollectionMigrator] [DEBUG] [9/11/2010 12:57:05 AM]: SPContentDatabase2 Name=WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997 Parent=SPDatabaseServiceInstance Name=stlgp1 FullTextSearchEnabled: True
[DatabaseSchema] [ERROR] [9/11/2010 12:57:08 AM]: [WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997].[proc_DetectOrphans] EXTRA String
[DatabaseSchema] [ERROR] [9/11/2010 12:57:08 AM]: [WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997].[proc_DetectOrphansFix] EXTRA String
[DatabaseSchema] [ERROR] [9/11/2010 12:57:08 AM]: [WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997].[proc_ScorchList] EXTRA String
[DatabaseSchema] [ERROR] [9/11/2010 12:57:08 AM]: [WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997].[proc_ScorchWeb] EXTRA String
[DatabaseSchema] [ERROR] [9/11/2010 12:57:08 AM]: [WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997] NON EQUAL Property SProcs
[SPManager] [ERROR] [9/11/2010 12:57:08 AM]: Migrate [SPMigratableSiteCollection Parent=SPManager] failed.
[SPManager] [ERROR] [9/11/2010 12:57:08 AM]: Schema mismatch between SPContentDatabase2 Name=sts_intranet Parent=SPDatabaseServiceInstance Name=stlgp1 and SPContentDatabase2 Name=WSSUP_Temp_efd21ec3-e059-4d42-8c57-5c5ade83e997 Parent=SPDatabaseServiceInstance
Name=stlgp1
[SPManager] [ERROR] [9/11/2010 12:57:08 AM]: at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.Migrate()
at Microsoft.SharePoint.Upgrade.SPManager.Migrate(Object o, Boolean bRecurse)
[SPManager] [DEBUG] [9/11/2010 12:57:08 AM]: Elapsed time migrating [SPMigratableSiteCollection Parent=SPManager]: 00:00:21.8758400.
[SPManager] [INFO] [9/11/2010 12:57:08 AM]: Gradual Upgrade session finishes. root object = SPMigratableSiteCollection Parent=SPManager, recursive = True. 6 errors and 0 warnings encountered.
[SPManager] [DEBUG] [9/11/2010 12:57:08 AM]: Removing exclusive upgrade regkey by setting the mode to none
September 11th, 2010 9:42am
Many things can cause issues during the migration process. Schema differences could be related to patch levels etc. For the defacto guide to migrating SharePoint 2003 to 2007 in a real world environment, start here:
http://www.cjvandyk.com/blog/Lists/Posts/Post.aspx?ID=107I trust that answers your question...
Thanks
C
http://www.cjvandyk.com/blog
Free Windows Admin Tool Kit Click here and download it now
September 14th, 2010 12:28am
Did you happen to figure this out? I am getting the same error and can't find any support for it.
November 4th, 2010 12:50pm