Solved

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

Posted on 2016-07-19
7
593 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 18

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 Admins - 7 Day Trial

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 13

Expert Comment

by:Ajit (Kevin k)
ID: 41720965
0
 
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 18

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

710 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