Hi there,
I recently inherited a Cloud Mango instance and caused a bit of an issue when installing some new updates (evening of August 17th). Long story short, I was able to restart the Mango but all of the previous data points and scripts were lost.
I attempted restoring the most recent H2 backup as described in https://forum.infiniteautomation.com/topic/2748/how-to-restore-a-database-backup/2
This only partially worked. Only the core module remained and none of the previous data points or sources could be seen. I may have been doing something wrong.
I am now at a point where the Mango cannot restart through command line or the web interface. When restarting through the interface the following error pops up:
Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,dp.readPermission,dp.setPermission,dp.templateId,dp.rollup,dp.dataTypeId,dp.settable,ds.name,ds.xid,ds.dataSourceType,ds.editPermission,template.name,template.xid FROM dataPoints AS dp JOIN dataSources ds ON ds.id = dp.dataSourceId LEFT JOIN templates template ON template.id = dp.templateId ORDER BY dp.deviceName, dp.name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "DP.SETTABLE" not found; SQL statement: SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,dp.readPermission,dp.setPermission,dp.templateId,dp.rollup,dp.dataTypeId,dp.settable,ds.name,ds.xid,ds.dataSourceType,ds.editPermission,template.name,template.xid FROM dataPoints AS dp JOIN dataSources ds ON ds.id = dp.dataSourceId LEFT JOIN templates template ON template.id = dp.templateId ORDER BY dp.deviceName, dp.name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY [42122-199]
I guess my first question is the following:
How can I regain the ability to restart, stop and start the Cloud Mango? This way I can start from a blank database and login with admin/admin.
Once I've got that resolved I'll want to get my backup restored :) One step at a time though.
Logs can be found here:
https://drive.google.com/open?id=1Y9h_iw6rC3LiG0nvCL8iWvDBXn049be5
Thank you so much in advance!