I’m getting a handful of repeating errors revolving around HSQLDataStore …
… the message for the HSQLDataStore - Error creating data cache db is …
[quote]com.inductiveautomation.ignition.gateway.web.pages.config.systemconsole.LogViewer$SerializableLoggingEvent$ClonedThrowable: error in script file line: 20 file input/output errorerror file input/output error C:\PROGRA~1\INDUCT~1\Ignition\contexts\main\datacache\PLRM\PLRM.data (The requested operation cannot be performed on a file with a user-mapped section open) C:\PROGRA~1\INDUCT~1\Ignition\contexts\main\datacache/PLRM/PLRM.backup opening file - file C:\PROGRA~1\INDUCT~1\Ignition\contexts\main\datacache/PLRM/PLRM.data
org.hsqldb.jdbc.Util.sqlException(Util.java:363)
org.hsqldb.jdbc.Util.sqlException(Util.java:103)
org.hsqldb.jdbc.JDBCConnection.(JDBCConnection.java:3233)
org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:245)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.inductiveautomation.ignition.gateway.history.stores.HSQLDataStore.createInitialDatabase(HSQLDataStore.java:124)
com.inductiveautomation.ignition.gateway.history.stores.HSQLDataStore.initialize(HSQLDataStore.java:54)
com.inductiveautomation.ignition.gateway.history.sinks.AbstractSink.tryToInit(AbstractSink.java:81)
com.inductiveautomation.ignition.gateway.history.sinks.AbstractSink.isAccepting(AbstractSink.java:98)
com.inductiveautomation.ignition.gateway.history.ForwarderThread.run(ForwarderThread.java:74)
com.inductiveautomation.ignition.gateway.web.pages.config.systemconsole.LogViewer$SerializableLoggingEvent$ClonedThrowable: error in script file line: 20 file input/output errorerror file input/output error C:\PROGRA~1\INDUCT~1\Ignition\contexts\main\datacache\PLRM\PLRM.data (The requested operation cannot be performed on a file with a user-mapped section open) C:\PROGRA~1\INDUCT~1\Ignition\contexts\main\datacache/PLRM/PLRM.backup opening file - file C:\PROGRA~1\INDUCT~1\Ignition\contexts\main\datacache/PLRM/PLRM.data
org.hsqldb.error.Error.error(Error.java:112)
org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:129)
org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:65)
org.hsqldb.persist.Log.processScript(Log.java:786)
org.hsqldb.persist.Log.open(Log.java:223)
org.hsqldb.persist.Logger.openPersistence(Logger.java:233)
org.hsqldb.Database.reopen(Database.java:265)
org.hsqldb.Database.open(Database.java:237)
org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:225)
org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:148)
org.hsqldb.jdbc.JDBCConnection.(JDBCConnection.java:3216)
org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:285)
org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:245)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.inductiveautomation.ignition.gateway.history.stores.HSQLDataStore.createInitialDatabase(HSQLDataStore.java:124)
com.inductiveautomation.ignition.gateway.history.stores.HSQLDataStore.initialize(HSQLDataStore.java:54)
com.inductiveautomation.ignition.gateway.history.sinks.AbstractSink.tryToInit(AbstractSink.java:81)
com.inductiveautomation.ignition.gateway.history.sinks.AbstractSink.isAccepting(AbstractSink.java:98)
com.inductiveautomation.ignition.gateway.history.ForwarderThread.run(ForwarderThread.java:74)[/quote]
… I’m working with Ignition 7.0.2.4482 on Windows Server 2003. I can provide more information if requested. Any ideas?