none
Sharepoint Migration from 2007 to 2010 and 2010 to 2013 issue RRS feed

  • Question

  • Hi,

    we are migrating our SharePoint 2007 environment to 2013. to do this, we have one SharePoint 2010 interim environment.

    migration from 2007 to 2010 worked well and there were some issue related to customization. and those were fixed.

    Now from 2010 to 2013, its giving issue. we are doing database migration. the server 2010 environment has sql server 2008 r2 and SharePoint 2013 environment has sql server 2012.

    after restore the database from the sql server 2008 database back up, and running the power shell command

    Mount-SPContentDatabase - Name -webapplication Url.

    below error is thrown. 

    Mount-SPContentDatabase : Content database data integrity check has
    encountered a severe issue that upgrade process must be stopped. See the
    upgrade log for more information about how to resolve this issue.
    At line:1 char:1
    + Mount-SPContentDatabase -Name DevEmacContentDBbackUp -WebApplication
    http://mct- ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ~~~
        + CategoryInfo          : InvalidData: (Microsoft.Share...ContentDatabase:
       SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPUpgradeExceptio
      n
        + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletMountCon
       tentDatabase

     I ran configuration wizard and that is also failing. in the Upgrade and migrations section database status is : database is too old and upgrade is required.


    01/16/2014 10:56:36.27 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPContentDatabaseSequence ajxlb ERROR The list 'AllEFormDepositary' at URL '/HR/PerformanceAppraisal/AllEFormDepositary' has a schema that is incompatible with this version of SharePoint. 116c85f6-0e95-4750-a160-30fca8278c82
    01/16/2014 10:56:36.32 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPContentDatabaseSequence ajxlc INFO SPContentDatabase Name=DevEmacContentDBbackUp 116c85f6-0e95-4750-a160-30fca8278c82
    Upgrade SPContentDatabaseSequence ajxlc ERROR The list 'ArchiveForReports' has more than the limit of 262 fields of type 'Single line of text', 'Choice', or 'Hyperlink or Picture'. 116c85f6-0e95-4750-a160-30fca8278c82
    01/16/2014 10:56:36.43 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPContentDatabaseSequence ajxlb INFO SPContentDatabase Name=DevEmacContentDBbackUp 116c85f6-0e95-4750-a160-30fca8278c82

    01/16/2014 10:56:36.52 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR Upgrade [SPContentDatabase Name=DevEmacContentDBbackUp] failed. 116c85f6-0e95-4750-a160-30fca8278c82
    01/16/2014 10:56:36.54 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name=DevEmacContentDBbackUp 116c85f6-0e95-4750-a160-30fca8278c82
    01/16/2014 10:56:36.54 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR Exception: Content database data integrity check has encountered a severe issue that upgrade process must be stopped. See the upgrade log for more information about how to resolve this issue. 116c85f6-0e95-4750-a160-30fca8278c82
    01/16/2014 10:56:36.57 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name=DevEmacContentDBbackUp 116c85f6-0e95-4750-a160-30fca8278c82
    01/16/2014 10:56:36.57 powershell (0x1440) 0x0C64 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR    at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.ContentDatabaseDataIntegrityCheck()     at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.PreUpgrade()     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse) 116c85f6-0e95-4750-a160-30fca8278c82

    Thursday, January 16, 2014 12:07 PM

Answers

  • You can see that you have issues that you must resolve manually in your content database, mainly:

    • The list 'AllEFormDepositary' at URL '/HR/PerformanceAppraisal/AllEFormDepositary' has a schema that is incompatible with this version of SharePoint.
    • The list 'ArchiveForReports' has more than the limit of 262 fields of type 'Single line of text', 'Choice', or 'Hyperlink or Picture'.

    You must resolve these by backing them up, deleting them, doing the upgrade, and then putting them back afterwards.


    Chris Givens CEO, Architecting Connected Systems Blog Twitter

    • Marked as answer by Ravish_Trigent Wednesday, January 22, 2014 1:01 PM
    Saturday, January 18, 2014 5:27 PM

All replies

  • You can see that you have issues that you must resolve manually in your content database, mainly:

    • The list 'AllEFormDepositary' at URL '/HR/PerformanceAppraisal/AllEFormDepositary' has a schema that is incompatible with this version of SharePoint.
    • The list 'ArchiveForReports' has more than the limit of 262 fields of type 'Single line of text', 'Choice', or 'Hyperlink or Picture'.

    You must resolve these by backing them up, deleting them, doing the upgrade, and then putting them back afterwards.


    Chris Givens CEO, Architecting Connected Systems Blog Twitter

    • Marked as answer by Ravish_Trigent Wednesday, January 22, 2014 1:01 PM
    Saturday, January 18, 2014 5:27 PM
  • I deleted the entire content of the site, and then took a backup, unfortunately, the size of DB did not decrease even though I restored and same items are logged in the log file.

    I have deleted all the subsites, only the root site collection I left and then took the back up.

    Monday, January 20, 2014 2:46 PM
  • Deletion itself may not have been enough.  Did you clear the recycle bin stages once the lists had been removed?

    Steven Andrews
    SharePoint Business Analyst: LiveNation Entertainment
    Blog: baron72.wordpress.com
    Twitter: Follow @backpackerd00d
    My Wiki Articles: CodePlex Corner Series
    Please remember to mark your question as "answered" if this solves (or helps) your problem.

    Monday, January 20, 2014 3:05 PM
    Answerer
  • After deleting the list, I went to recycle bin and removed items from recycle bin. But there were no reduction in the size of the Database
    Tuesday, January 21, 2014 2:33 AM
  • You have two stages of recycle bins, i hope you have deleted them from both levels.

    http://office.microsoft.com/fil-ph/office365-sharepoint-online-enterprise-help/manage-the-recycle-bin-of-a-sharepoint-site-collection-HA102772732.aspx


    My Blog- http://www.sharepoint-journey.com|
    If a post answers your question, please click Mark As Answer on that post and Vote as Helpful

    Tuesday, January 21, 2014 2:45 AM
  • Database size will not reduced unless you shrink it. if you run the query again content DB you will see more white space/free space in it. 

    you need to fix the two list which Chris mentioned in his reply....simply deleting the extra columns from the list...both list having same issue.

    More details about the List column limits check this:

    http://technet.microsoft.com/en-us/library/cc262787.aspx#Column


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

    Tuesday, January 21, 2014 3:20 AM
    Moderator
  • hi,

    i think generally database will not shrink until we do it forcibly. even though whn we forcibly shrink the database it will be a minimal decrease in capacity. by nature databases are tend to increase not to decrease in size, please correct me if i am wrong. 


    j.rajashekar

    Tuesday, January 21, 2014 7:56 AM