Solved

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

Posted on 2016-07-19
7
454 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
  • 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 17

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 11

Expert Comment

by: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 17

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint integration. 1 62
Cloud / Hybrid file storage & collaboration 5 83
User Profile Issue in SHarePoint 9 64
Forcing check-in on SharePoint 2010 4 29
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 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