Solved

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

Posted on 2016-07-19
7
199 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
Comment Utility
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 14

Expert Comment

by:SneekCo
Comment Utility
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
Comment Utility
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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 8

Expert Comment

by:Kevin k
Comment Utility
0
 
LVL 6

Accepted Solution

by:
Duane Lawrence earned 0 total points
Comment Utility
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 14

Expert Comment

by:SneekCo
Comment Utility
Glad  you got it going and thanks for sharing the resolution...
0
 
LVL 6

Author Closing Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

772 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now