Error while starting up Mendix App

1
Could anyone help me understanding this issue? Many thanks in advance     code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error no such table: _MetaData    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)    at System.Data.SQLite.SQLiteCommand.BuildNextCommand()    at System.Data.SQLite.SQLiteDataReader.NextResult()    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)    at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)    at Mendix.Modeler.Utility.DbConnectors.DbConnector.<>c__DisplayClass12_0.<ExecuteReader>b__0(DbCommand c) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 155    at Mendix.Modeler.Utility.DbConnectors.DbConnector.CommandDo(String query, Object[] values, Action`1 action) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 173    at Mendix.Modeler.Utility.DbConnectors.DbConnector.ExecuteReader(String query, Object[] values) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 156    at Mendix.Modeler.Storage.Mpr.MprLoader.LoadMetadata(IDbConnector db, IProgressInfo info) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Storage\Mpr\MprLoader.cs:line 58    at Mendix.Modeler.Storage.Mpr.MprLoader.<>c__DisplayClass0_0.<LoadMpr>b__0(IDbConnector db) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Storage\Mpr\MprLoader.cs:line 18    at Mendix.Modeler.Utility.DbConnectors.SQLiteConnector.<>c__DisplayClass4_0.<Do>b__0(IDbConnector c) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\SQLiteConnector.cs:line 42    at Mendix.Modeler.Utility.DbConnectors.DbConnector.WithoutTransactionDo[TResult](Func`1 action) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 64    at Mendix.Modeler.Utility.DbConnectors.SQLiteConnector.Do[TResult](String filePath, Boolean useTransaction, Func`2 action) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\SQLiteConnector.cs:line 56    at Mendix.Modeler.Storage.Mpr.MprLoader.LoadMpr(String filePath, IProgressInfo info, Boolean loadContents) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Storage\Mpr\MprLoader.cs:line 22    at Mendix.Modeler.VersionControl.Status.RevStatusCache.DoRefresh(IProgressInfo info) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Core\VersionControl\Status\RevStatusCache.cs:line 69    at Mendix.Modeler.VersionControl.Status.StatusCacheManager.Initialize(IProject project, IProgressInfo info) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Core\VersionControl\Status\StatusCacheManager.cs:line 49    at Mendix.Modeler.UIFramework.Progress.ProcessRunner.RunStep(Step step) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 83    at Mendix.Modeler.UIFramework.Progress.ProcessRunner.OnDoWork(Object sender, DoWorkEventArgs e) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 63    at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)    at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
asked
2 answers
1

This looks like a corrupt local database. You could try to Clean deployment directory. If that does not help just delete the deployment / data / database directory. Note that you loose all your data this way. You could also make a copy first to a safe place before doing this.

Regards,

Ronald

 

answered
0

Also shows this error..

 

Mendix.Modeler.Utility.Progress.ProgressException ---> System.Data.SQLite.SQLiteException: SQL logic error
no such table: _MetaData
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at Mendix.Modeler.Utility.DbConnectors.DbConnector.<>c__DisplayClass12_0.<ExecuteReader>b__0(DbCommand c) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 155
   at Mendix.Modeler.Utility.DbConnectors.DbConnector.CommandDo(String query, Object[] values, Action`1 action) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 173
   at Mendix.Modeler.Utility.DbConnectors.DbConnector.ExecuteReader(String query, Object[] values) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 156
   at Mendix.Modeler.Storage.Mpr.MprLoader.LoadMetadata(IDbConnector db, IProgressInfo info) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Storage\Mpr\MprLoader.cs:line 58
   at Mendix.Modeler.Storage.Mpr.MprLoader.<>c__DisplayClass0_0.<LoadMpr>b__0(IDbConnector db) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Storage\Mpr\MprLoader.cs:line 18
   at Mendix.Modeler.Utility.DbConnectors.SQLiteConnector.<>c__DisplayClass4_0.<Do>b__0(IDbConnector c) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\SQLiteConnector.cs:line 42
   at Mendix.Modeler.Utility.DbConnectors.DbConnector.WithoutTransactionDo[TResult](Func`1 action) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\DbConnector.cs:line 64
   at Mendix.Modeler.Utility.DbConnectors.SQLiteConnector.Do[TResult](String filePath, Boolean useTransaction, Func`2 action) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Utility\DbConnectors\SQLiteConnector.cs:line 56
   at Mendix.Modeler.Storage.Mpr.MprLoader.LoadMpr(String filePath, IProgressInfo info, Boolean loadContents) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Storage\Mpr\MprLoader.cs:line 22
   at Mendix.Modeler.VersionControl.Status.RevStatusCache.DoRefresh(IProgressInfo info) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Core\VersionControl\Status\RevStatusCache.cs:line 69
   at Mendix.Modeler.VersionControl.Status.StatusCacheManager.Initialize(IProject project, IProgressInfo info) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Core\VersionControl\Status\StatusCacheManager.cs:line 49
   at Mendix.Modeler.UIFramework.Progress.ProcessRunner.RunStep(Step step) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 83
   at Mendix.Modeler.UIFramework.Progress.ProcessRunner.OnDoWork(Object sender, DoWorkEventArgs e) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 63
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
   --- End of inner exception stack trace ---
   at Mendix.Modeler.UIFramework.Progress.ProcessRunner.Run() in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 45
   at Mendix.Modeler.ModelerGui.SetProject(IProject project, Boolean isNewProject) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.Core\Core\Gui\ModelerGui.cs:line 157
   at Mendix.Modeler.ProjectHandling.Openers.ProjectFileOpenerUI.DoOpenProject() in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.ProjectHandling\Openers\ProjectFileOpenerUI.cs:line 162
   at Mendix.Modeler.ProjectHandling.Openers.ProjectFileOpenerUI.OpenProject() in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.ProjectHandling\Openers\ProjectFileOpenerUI.cs:line 128
   at Mendix.Modeler.ProjectHandling.Openers.ProjectOpenerUI.OpenProject(ISprintrProject sprintrProject) in C:\jenkins-ci\workspace\AppStudio4.0-Build\modeler\Mendix.Modeler.ProjectHandling\Openers\ProjectOpenerUI.cs:line 146

answered