locked
Upgrading sharepoint 2.0 to 3.0 getting error: Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.FixSecurityCorruptions RRS feed

  • Question

  • I'm getting error for the upgrade from 2.0 to 3.0 (please look at the end of post) SPContentDatabaseSequence.FixSecurityCorruptions()

    Can anyone give me ideas what could be wrong?  Here is the log.  

    SPManager] [DEBUG] [10/19/2011 4:54:50 PM]: [SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812] Running 144 of 145 steps

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Initialize()

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Initialize()

    [AddSiteDeletion] [3.1.9.0] [INFO] [10/19/2011 4:54:50 PM]: Add SiteDeletion table.

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Upgrade()

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Executing SQL DDL Script.

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Upgrade()

    [SPContentDatabaseSequence] [DEBUG] [10/19/2011 4:54:50 PM]: Calling set SchemaVersion on Database STS_MyTeams, Status = Upgrading.

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Executing SQL DDL Script.

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Commit()

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Commit()

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Dispose()

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Dispose()

    [AddSiteDeletion] [3.1.9.0] [DEBUG] [10/19/2011 4:54:50 PM]: Elapsed time: 00:00:00.0312502.

    [SPManager] [DEBUG] [10/19/2011 4:54:50 PM]: [SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812] Running 145 of 145 steps

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Initialize()

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Initialize()

    [UpdateAlternateAccessMapping] [3.1.11.0] [INFO] [10/19/2011 4:54:50 PM]: Update AlternateAccessMapping in database information, again

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Upgrade()

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Upgrade()

    [SPContentDatabaseSequence] [DEBUG] [10/19/2011 4:54:50 PM]: Calling set SchemaVersion on Database STS_MyTeams, Status = Upgrading.

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: Executing SQL DDL Script.

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Commit()

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Commit()

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: Begin Dispose()

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: End Dispose()

    [UpdateAlternateAccessMapping] [3.1.11.0] [DEBUG] [10/19/2011 4:54:50 PM]: Elapsed time: 00:00:00.0156251.

    [SPContentDatabaseSequence] [DEBUG] [10/19/2011 4:54:50 PM]: Executing database object restore script.

    [SPUtility] [DEBUG] [10/19/2011 4:54:50 PM]: File C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\sql\storeup.sql, Time out = 231803 sec

    [SPContentDatabaseSequence] [DEBUG] [10/19/2011 4:55:06 PM]: Finished executing database object restore script.

    [SPContentDatabaseSequence] [DEBUG] [10/19/2011 4:55:06 PM]: Detecting Security Setting Corruptions.

    [SPManager] [ERROR] [10/19/2011 4:55:08 PM]: Upgrade [SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812] failed.

    [SPManager] [ERROR] [10/19/2011 4:55:08 PM]: Data is Null. This method or property cannot be called on Null values.

    [SPManager] [ERROR] [10/19/2011 4:55:08 PM]:    at System.Data.SqlClient.SqlBuffer.get_String()

       at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)

       at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.FixSecurityCorruptions()

       at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.Upgrade()

       at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)

    [SPManager] [DEBUG] [10/19/2011 4:55:08 PM]: Elapsed time upgrading [SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812]: 00:17:27.

    [SPManager] [INFO] [10/19/2011 4:55:08 PM]: Resetting the status of PersistedUpgradableObject: SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812 to Online.

    [SPManager] [DEBUG] [10/19/2011 4:55:09 PM]: Using cached [SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812] NeedsUpgrade value: True.

    [SPManager] [INFO] [10/19/2011 4:55:09 PM]: Inplace Upgrade session finishes. root object = SPContentDatabase Name=STS_MyTeams Parent=SPDatabaseServiceInstance Name=SQLT812, recursive = False. 1 errors and 0 warnings encountered.


    POZERUGA
    Thursday, October 20, 2011 7:21 PM

All replies

  • Hello Pozeruga,

     

    Thank you for your question.

     

    We are trying to involve someone familiar with this topic to further look at this issue.

     

    This may take some time. Thanks for your patience.

     

    Thanks,

    Pengyu Zhao

     

    Saturday, October 22, 2011 9:36 AM
  • Hello,

    Thanks for the reply.  It's been couple weeks and I was wandering if anyone could help me out with this?

     


    POZERUGA
    Thursday, November 3, 2011 3:03 PM
  • Hello Pozeruga,

    Thank you for your post. I have reviewed the error message and below are my findings. http://support.microsoft.com/kb/948780 Description of the sequences and actions that occur when you upgrade SharePoint Products and Technologies which talks about FixSecurityCorruptions

    There seems to be SharePoint group with some corruptions like Description is null. If the Sharepoint Object model is used to add a new group to the GroupCollection of a site and the value passed to Description parameter of the SPGroup is null then this issue may occur. Additional information  on the content database tables can be found below

    http://msdn.microsoft.com/en-us/library/dd585267(v=office.11).aspx

    Can you please run the SQl query below and see if you can identify the group that seems to be causing an issue here .

    select * from WebGroups (nolock) where Description is null

    Please  note  you can’t do any direct database modifications even if we identify the group as that would then leave your environment in an un-supported  state . Ref Support for changes to the databases that are used by Office server products and by Windows SharePoint Services.http://support.microsoft.com/kb/841057. If we identify an group we may have to go back to the Sharepoint 2003/WSS2.0 environment to find a supported way of fixng the same 

    Also please check if your prescan log contains any error or information around the same.


    Regards,
    Manas Biswas
    Microsoft Online Community Support


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Sunday, November 6, 2011 10:58 AM
  • Hello, Manas

    Thanks for the reply.  I can't verify the group becuase "WebGroups" does not exist in content DB.

    It appears that upgrade never created the table or the view.  Please note I'm upgradin from 2.0 to 3.0

    Any other ideas or suggestions?

     Thanks.

     

     


    POZERUGA
    Monday, November 7, 2011 3:29 PM
  • Hello Pozeruga,

    Thank you for the update and confirmation . The steps I mentioned are from a 2.0 to 3.0 upgrade.only . When you say that WebGroups" does not exist in content DB are you looking at the database in your 3.0 environment. If yes you need to check the same on WSS2.0 environment. Please post the details of the error message from prescan log . Also what is the upgrade method that you are using to upgrade from 2.0 to 3.0 ,please let us know.


    Regards,
    Manas Biswas
    Microsoft Online Community Support


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, November 7, 2011 6:35 PM