Sql server - compatibility level for this database is lower than the minimum supported version.

0
  I was getting compatibility level error after copying database backup from Production to our test server. Both have sql server 2016 but had different compatibility level for the Mendix database. I fixed compatibility level using following query:   SELECT name, compatibility_level FROM sys.databases; ALTER DATABASE MendixDB SET COMPATIBILITY_LEVEL = 130; GO   After this fix, the app. started to move forward with compilation, but then started to get following error upon hitting Synchronize database button:   Mendix.Modeler.M2EEConnector.M2EEException: The server encountered an error.    at Mendix.Modeler.M2EEConnector.M2EEResponse.CheckSuccess() in C:\jenkins-ci\workspace\AppStudio3.0-Build@2\modeler\Mendix.Modeler.M2EEConnector\M2EEResponse.cs:line 57    at Mendix.Modeler.M2EEConnector.StartupManager.StartRuntime(IM2EEClient client, StartupInfo info) in C:\jenkins-ci\workspace\AppStudio3.0-Build@2\modeler\Mendix.Modeler.M2EEConnector\StartupManager.cs:line 106    at Mendix.Modeler.M2EEConnector.StartupManager.PerformStartup(StartupInfo info, IM2EEClient client) in C:\jenkins-ci\workspace\AppStudio3.0-Build@2\modeler\Mendix.Modeler.M2EEConnector\StartupManager.cs:line 48    at Mendix.Modeler.M2EEConnector.RuntimeController.Start(StartupInfo info, LogLevel autoSubscribeLogLevel) in C:\jenkins-ci\workspace\AppStudio3.0-Build@2\modeler\Mendix.Modeler.M2EEConnector\RuntimeController.cs:line 133    at Mendix.Modeler.Utility.BackgroundUtil.<>c__DisplayClass1_0`1.<Do>b__0(Object s, DoWorkEventArgs e) in C:\jenkins-ci\workspace\AppStudio3.0-Build@2\modeler\Mendix.Modeler.Utility\BackgroundUtil.cs:line 28    at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)    at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
asked
1 answers
0

I guess we found the problem was with having different versions withing the major version of 2016 sql server. Our production environment has a slightly higher version (13.0.5081.1) and test env. has 13.0.5026.0.

It’s still a pain though.

answered