2

After installing the latest Cumulative Update for SharePoint 2016, I tried to upgrade content database but It gives an error each time.

100.00% : SPContentDatabase Name=WSS_Content Finalizing the upgrade...

Upgrade-SPContentDatabase : Invalid column name 'TS_LINE_ADDED_IN_TS'. Invalid column name 'TS_LINE_ADDED_IN_TS'. At line:1 char:1 + Upgrade-SPContentDatabase -Identity fe2d6c65-a1d0-49cc-b154-75433ede7 ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Share...ContentDatabase:SPCmdletUpgradeContentDatabase) [Upgrade -SPContentDatabase], SqlException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletUpgradeContentDatabase

Have you ever faced with a like that issue before?

Improve this question

2 Answers 2

Reset to default
3

Try to do the following:

  • Dismount the content database which has the "Invalid Column" issue.
  • Run the SharePoint Configuration Wizard to get the farm patched successfully.
  • Mount the unmounted database again,

  • Then run the below cmdlet 

    Get-SPContentDatabase –Identity WSS_Content_Name | Upgrade-SPContentDatabase

For more details, Please Check

Improve this answer
1
  • 1
    There was a table which name is MSP_TIMESHEET_LINES and one column was missing in that table, I am not sure why it was missing but after adding this column, it is resolved.
    – Onur CAN
    Commented Mar 6, 2020 at 6:00
2

To resolve this issue, you need to upgrade the content database to match the version of the rest of the farm using the PowerShell cmdlet "Upgrade-SPContentDatabase".

Upgrade-SPContentDatabase -Identity <database>
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.