Progress KB - Site shows downgrade error after upgrade




Feedback
Did this article resolve your question/issue?

   

Article

Site shows downgrade error after upgrade

« Go Back

Information

 
TitleSite shows downgrade error after upgrade
URL Namesite-shows-downgrade-error-after-upgrading-another-environment
Article Number000187995
EnvironmentProduct: Sitefinity
Version: 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, 11.x, 12.x
OS: All supported OS versions
Database: All supported Microsoft SQL Server versions
Question/Problem Description
Site shows errors after upgrading another Sitefinity site environment, showing an error referencing downgrade.
Steps to Reproduce
Clarifying Information
Error MessageThe database schema version xxx is higher than the running Sitefinity version xxx. Downgrade is not allowed.
Defect/Enhancement Number
Cause
The error is due to the database version and Sitefinity version not being equal.

This occurs due to an upgrade process that has been initiated in a second environment while using the database from the first environment. As a result, this will cause the version stored in the database to be different from the version on the site from the first environment.
<add connectionString="data source=.\SQL2014;Integrated Security=SSPI;initial catalog=Database"
name="Sitefinity" IgnoreDowngradeExceptions="true" />
Resolution

The following options are available in order to restore the site functionality:

  • Restore a copy of the database before upgrading the second environment as a separate database, then connect the first environment to this database.
  • Upgrade the failing environment to the same version of Sitefinity as the error mentions.
  • If the site runs Sitefinity 8.2.5900 it can ignore the downgrade exceptions in order to prevent this error and give time to the site admins to make the version of Sitefinity assemblies and the database the same. To use ignoreDowngradeExceptions functionality refer to this Sitefinity documentation, upgrades and database¬†https://docs.sitefinity.com/upgrades-and-database. NOTE:¬†the connection string must reside in App_Data/Sitefinity/Configuration/DataConfig.config to use this parameter.
<add connectionString="data source=.;Integrated Security=SSPI;initial catalog=Database"
name="Sitefinity" IgnoreDowngradeExceptions="true" />


 
Workaround
Notes
Last Modified Date3/31/2020 5:33 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.