Sharepoint Migration from 2007 to 2010 and 2010 to 2013 issue

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

January 16th, 2014 3:07pm

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.

Free Windows Admin Tool Kit Click here and download it now
January 18th, 2014 12:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics