Solved

When I mount SharePoint 2010 Content DB to SharePoint 2013, I get a list of errors

Posted on 2016-07-19
7
719 Views
Last Modified: 2016-07-30
Command in SharePoint 2013 Admin Shell:
Mount-SPContentDatabase "PB_Content" -DatabaseServer "pbcdep123" -WebApplication http://sp.PB.pbdenton.pacar.com

RESPONSE:
100.00% : SPContentDatabase Name=PB_Content
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 "PB_Content" -DatabaseServer "pbcdepmvp106" -WebApplicat ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo          : InvalidData: (Microsoft.Share...ContentDatabase:
SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPUpgradeException
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletMountContentDatabase

FROM EVENT VIEWER1
The DELETE statement conflicted with the REFERENCE constraint "FK_Dependencies1_Objects".
The conflict occurred in database "SharePoint_Config", table "dbo.Dependencies", column 'ObjectId'. The statement has been terminated

FROM EVENT VIEWER2
The Execute method of job definition Microsoft.Office.Server.UserProfiles.LMTRepopulationJob (ID 9c68b12b-edf9-4026-9d26-3cf12b4f68ee) threw an exception. More information is included below.
Could not find stored procedure 'dbo.proc_GetFollowableLists'.

FROM EVENT VIEWER3
Unknown SQL Exception 15151 occurred. Additional error information from SQL Server is included below.
Cannot alter the role 'SPDataAccess', because it does not exist or you do not have permission.

FROM EVENT VIEWER4
Unknown SQL Exception 8144 occurred. Additional error information from SQL Server is included below.
Procedure or function TVF_AllWebs_Id has too many arguments specified.

FROM EVENT VIEWER5
Unknown SQL Exception 8144 occurred. Additional error information from SQL Server is included below.
Procedure or function TVF_AllWebs_Id has too many arguments specified.

FROM EVENT VIEWER6
Unknown SQL Exception 8144 occurred. Additional error information from SQL Server is included below.
Procedure or function TVF_AllWebs_Id has too many arguments specified.
0
Comment
Question by:Duane Lawrence
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 6

Author Comment

by:Duane Lawrence
ID: 41719462
THE UPGRADE ERROR LOG:


Timestamp                    Process                                       TID         Area                                Category                            EventID      Level           Message       Correlation
07/19/2016 10:25:29.37      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxjv      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:29.37      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxjv      WARNING      Assembly [Microsoft.ReportingServices.SharePoint.UI.ServerPages, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91] is referenced in the database [PB_Content], but is not installed on the current farm. Please install any feature/solution which contains this assembly.      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:29.52      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxjw      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:29.52      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxjw      WARNING      One or more assemblies are referenced in the database [PB_Content], but are not installed on the current farm. Please install any feature or solution which contains these assemblies.      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:33.79      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxlb      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:33.79      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxlb      ERROR      The list 'VendorList' at URL '/pbdivisionaccounting/GeneralAccounting/VendMaint/Lists/VendorList' has a schema that is incompatible with this version of SharePoint.      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:33.91      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxlf      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:33.91      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPContentDatabaseSequence      ajxlf      WARNING      The [SharePoint - 80] web application is configured with claims authentication mode however the content database you are trying to attach is intended to be used against a windows classic authentication mode.      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:34.16      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPUpgradeSession      ajxnm      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:34.16      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPUpgradeSession      ajxnm      ERROR      Upgrade [SPContentDatabase Name=PB_Content] failed.      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:34.40      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPUpgradeSession      ajxnm      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:34.40      powershell (0x1598)      0x293C      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.      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:34.48      powershell (0x1598)      0x293C      SharePoint Foundation Upgrade      SPUpgradeSession      ajxnm      INFO      SPContentDatabase Name=PB_Content      5dcede26-d05a-4c01-a04d-93b1718614db
07/19/2016 10:25:34.48      powershell (0x1598)      0x293C      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)      5dcede26-d05a-4c01-a04d-93b1718614db
0
 
LVL 19

Expert Comment

by:Walter Curtis
ID: 41719987
Not sure, but seems like this error is causing all the rest:

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.


Is that possible?

Good luck...
0
 
LVL 6

Author Comment

by:Duane Lawrence
ID: 41720091
Yes, it is indeed it is causing the rest, but under that message are missing stored procedures.

I am patching SharePoint 2013 with Sp1 now.  Then I will see if I am still missing stored procedures.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 6

Accepted Solution

by:
Duane Lawrence earned 0 total points
ID: 41722997
I found the answers on my own.  

1. Most of the problems were from a WSP file that needed to be upgraded from SP 2010 to SP 2013.

stsadm -o upgradesolution -name "pbcustomtemplatesp2010.wsp"  -filename "D:\DBA\pbcustomtemplatesp2010.wsp" -immediate -allowgacdeployment –allowcaspolicies

2. I patched SP 2013 to SP1.  Here is a list from Microsoft.
https://technet.microsoft.com/en-us/library/mt715807%28v=office.16%29.aspx?f=255&MSPPError=-2147217396#BKMK_2013
0
 
LVL 19

Expert Comment

by:Walter Curtis
ID: 41723009
Glad  you got it going and thanks for sharing the resolution...
0
 
LVL 6

Author Closing Comment

by:Duane Lawrence
ID: 41735649
The other answers were not even close.  I have to wonder if they were just fishing four points?
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question