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
Atul Deora
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.