I'm working on a gateway that doesn't start, with the message "Gateway is faulted" after upgrading from v7.7.6 to v8.1.31.
This are last entries in wrapper log:
INFO | jvm 1 | 2023/10/18 13:14:04 | I [IgnitionServer ] [16:14:04]: Could not generate subject alt names, the self generated certificate will not have any metadata
INFO | jvm 1 | 2023/10/18 13:14:04 | java.net.URISyntaxException: Illegal character in hostname at index 7: uri://C_ignitioncam/metro
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI$Parser.fail(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI$Parser.parseHostname(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI$Parser.parseServer(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI$Parser.parseAuthority(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI$Parser.parseHierarchical(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI$Parser.parse(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI.<init>(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.net.URI.<init>(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer.buildSelfSignedCertificate(IgnitionServer.java:1574)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer.generateKeyStore(IgnitionServer.java:1479)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer.generateMetroKeystore(IgnitionServer.java:1418)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer$MetroServerConnectorWrapper.createConnectionFactory(IgnitionServer.java:526)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer$MetroServerConnectorWrapper.createConnector(IgnitionServer.java:604)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer$HttpServerConnectorWrapper.<init>(IgnitionServer.java:408)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer$MetroServerConnectorWrapper.<init>(IgnitionServer.java:510)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.IgnitionServer$WebServerChangeListener.onWebServerConfigChange(IgnitionServer.java:987)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.eventbus.Subscriber.invokeSubscriberMethod(Subscriber.java:85)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.eventbus.Subscriber$SynchronizedSubscriber.invokeSubscriberMethod(Subscriber.java:142)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.eventbus.Subscriber.lambda$dispatchEvent$0(Subscriber.java:71)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:31)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.eventbus.Subscriber.dispatchEvent(Subscriber.java:68)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.eventbus.Dispatcher$PerThreadQueuedDispatcher.dispatch(Dispatcher.java:109)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.google.common.eventbus.EventBus.post(EventBus.java:270)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.ignition.gateway.server.WebServerManager.setPrimaryPorts(WebServerManager.java:388)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.ignition.gateway.commissioning.resources.ConnectionsResource.saveProperties(ConnectionsResource.java:159)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.ignition.gateway.commissioning.CommissioningContext.lambda$save$5(CommissioningContext.java:636)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.util.LinkedHashMap$LinkedValues.forEach(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.ignition.gateway.commissioning.CommissioningContext.save(CommissioningContext.java:636)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.ignition.gateway.servlets.CommissioningServlet.handleFinish(CommissioningServlet.java:698)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.ignition.gateway.servlets.CommissioningServlet.doPost(CommissioningServlet.java:211)
INFO | jvm 1 | 2023/10/18 13:14:04 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:523)
INFO | jvm 1 | 2023/10/18 13:14:04 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1410)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:131)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:578)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:223)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1384)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1306)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
INFO | jvm 1 | 2023/10/18 13:14:04 | at com.inductiveautomation.catapult.handlers.RemoteHostNameLookupHandler.handle(RemoteHostNameLookupHandler.java:121)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:51)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:141)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.Server.handle(Server.java:563)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)
INFO | jvm 1 | 2023/10/18 13:14:04 | at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)
INFO | jvm 1 | 2023/10/18 13:14:04 | at java.base/java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:04 | I [o.e.j.s.AbstractConnector ] [16:14:04]: Started ServerConnector@c2b9cec{SSL, (ssl, http/1.1)}{0.0.0.0:8060}
INFO | jvm 1 | 2023/10/18 13:14:04 | I [o.e.j.s.h.ContextHandler ] [16:14:04]: Stopped o.e.j.w.WebAppContext@20230ac{Commissioning,/,file:///C:/Program%20Files/Inductive%20Automation/Ignition/webserver/webapps/commissioning/,STOPPED}
INFO | jvm 1 | 2023/10/18 13:14:04 | I [Commissioning ] [16:14:04]: Commissioning State updated from needs_commissioning to commissioned
INFO | jvm 1 | 2023/10/18 13:14:05 | 13:14:04,934 |-INFO in ch.qos.logback.classic.servlet.LogbackServletContainerInitializer@35f3e41b - Due to deployment instructions will NOT register an instance of class ch.qos.logback.classic.servlet.LogbackServletContextListener to the current web-app
INFO | jvm 1 | 2023/10/18 13:14:05 | W [o.e.j.u.DeprecationWarning ] [16:14:04]: Using @Deprecated Class org.eclipse.jetty.servlet.listener.ELContextCleaner
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.Application ] [16:14:05]: [WicketFilter] init: Wicket core library initializer
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.RequestListenerInterface] [16:14:05]: registered listener interface [RequestListenerInterface name=IBehaviorListener, method=public abstract void org.apache.wicket.behavior.IBehaviorListener.onRequest()]
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.RequestListenerInterface] [16:14:05]: registered listener interface [RequestListenerInterface name=IFormSubmitListener, method=public abstract void org.apache.wicket.markup.html.form.IFormSubmitListener.onFormSubmitted()]
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.RequestListenerInterface] [16:14:05]: registered listener interface [RequestListenerInterface name=ILinkListener, method=public abstract void org.apache.wicket.markup.html.link.ILinkListener.onLinkClicked()]
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.RequestListenerInterface] [16:14:05]: registered listener interface [RequestListenerInterface name=IOnChangeListener, method=public abstract void org.apache.wicket.markup.html.form.IOnChangeListener.onSelectionChanged()]
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.RequestListenerInterface] [16:14:05]: registered listener interface [RequestListenerInterface name=IRedirectListener, method=public abstract void org.apache.wicket.IRedirectListener.onRedirect()]
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.RequestListenerInterface] [16:14:05]: registered listener interface [RequestListenerInterface name=IResourceListener, method=public abstract void org.apache.wicket.IResourceListener.onResourceRequested()]
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.Application ] [16:14:05]: [WicketFilter] init: Wicket extensions initializer
INFO | jvm 1 | 2023/10/18 13:14:05 | I [IgnitionGateway ] [16:14:05]: Ignition[state=STOPPED] ContextState = STARTING
INFO | jvm 1 | 2023/10/18 13:14:05 | I [IgnitionGateway ] [16:14:05]: Starting Ignition 8.1.31 (b2023081007)
INFO | jvm 1 | 2023/10/18 13:14:05 | I [IgnitionGateway ] [16:14:05]: Reloading JDBC classloader.
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.a.w.p.h.WebApplication ] [16:14:05]: [WicketFilter] Started Wicket version 6.30.0 in DEPLOYMENT mode
INFO | jvm 1 | 2023/10/18 13:14:05 | I [R.S.S.InternalDb ] [16:14:05]: Internal db synchronizer disk cache initialized. State id= redundant-provider=internaldb
INFO | jvm 1 | 2023/10/18 13:14:05 | I [R.StateMonitoring ] [16:14:05]: Redundancy state changed: Role=Independent, Activity level=Active, Project state=Good, History level=Full redundant-provider=system
INFO | jvm 1 | 2023/10/18 13:14:05 | I [g.InternalDatabaseManager ] [16:14:05]: Detected internal database engine change. Beginning conversion process.
INFO | jvm 1 | 2023/10/18 13:14:05 | I [g.I.HSQL ] [16:14:05]: Looking for existing internal database "settings"...
INFO | jvm 1 | 2023/10/18 13:14:05 | I [o.e.j.s.h.ContextHandler ] [16:14:05]: Started c.i.c.MainWebAppContext@3fa150f1{Ignition,/,file:///C:/Program%20Files/Inductive%20Automation/Ignition/webserver/webapps/main/,AVAILABLE}
INFO | jvm 1 | 2023/10/18 13:14:06 | E [g.I.HSQL ] [16:14:06]: Startup of internal database "settings" failed, autobackups disabled.
INFO | jvm 1 | 2023/10/18 13:14:06 | java.sql.SQLException: error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.dbExists(HsqlDbManager.java:436)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.startupInternal(HsqlDbManager.java:325)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.startup(HsqlDbManager.java:222)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl.executeConversion(LocalDBManagerImpl.java:188)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl.setup(LocalDBManagerImpl.java:142)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.IgnitionGateway.startupInternal(IgnitionGateway.java:973)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:301)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.IgnitionGateway.initRedundancy(IgnitionGateway.java:756)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.IgnitionGateway.lambda$initInternal$0(IgnitionGateway.java:690)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:544)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | Caused by: org.hsqldb.HsqlException: error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.error.Error.error(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.scriptio.ScriptReaderText.readAll(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.persist.Log.processScript(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.persist.Log.open(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.persist.Logger.open(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Database.reopen(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Database.open(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.DatabaseManager.newSession(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | ... 21 common frames omitted
INFO | jvm 1 | 2023/10/18 13:14:06 | Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.error.Error.error(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.error.Error.error(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.getMethods(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.getMethod(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.resolveReferences(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.resolve(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserRoutine.readCreateProcedureOrFunction(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserRoutine.compileCreateProcedureOrFunction(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserCommand.compilePart(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Session.compileStatement(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | ... 30 common frames omitted
INFO | jvm 1 | 2023/10/18 13:14:06 | E [IgnitionGateway ] [16:14:06]: Error during context startup.
INFO | jvm 1 | 2023/10/18 13:14:06 | com.inductiveautomation.ignition.gateway.localdb.DBStartupException: Error loading internal database "settings"
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.startup(HsqlDbManager.java:274)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl.executeConversion(LocalDBManagerImpl.java:188)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.LocalDBManagerImpl.setup(LocalDBManagerImpl.java:142)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.IgnitionGateway.startupInternal(IgnitionGateway.java:973)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:301)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.IgnitionGateway.initRedundancy(IgnitionGateway.java:756)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.IgnitionGateway.lambda$initInternal$0(IgnitionGateway.java:690)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:544)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.base/java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | Caused by: java.sql.SQLException: error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.dbExists(HsqlDbManager.java:436)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.startupInternal(HsqlDbManager.java:325)
INFO | jvm 1 | 2023/10/18 13:14:06 | at com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlDbManager.startup(HsqlDbManager.java:222)
INFO | jvm 1 | 2023/10/18 13:14:06 | ... 13 common frames omitted
INFO | jvm 1 | 2023/10/18 13:14:06 | Caused by: org.hsqldb.HsqlException: error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.error.Error.error(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.scriptio.ScriptReaderText.readAll(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.persist.Log.processScript(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.persist.Log.open(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.persist.Logger.open(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Database.reopen(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Database.open(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.DatabaseManager.newSession(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | ... 21 common frames omitted
INFO | jvm 1 | 2023/10/18 13:14:06 | Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.error.Error.error(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.error.Error.error(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.getMethods(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.getMethod(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.resolveReferences(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Routine.resolve(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserRoutine.readCreateProcedureOrFunction(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserRoutine.compileCreateProcedureOrFunction(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserCommand.compilePart(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | at org.hsqldb.Session.compileStatement(Unknown Source)
INFO | jvm 1 | 2023/10/18 13:14:06 | ... 30 common frames omitted
INFO | jvm 1 | 2023/10/18 13:14:06 | I [IgnitionGateway ] [16:14:06]: Ignition[state=STARTING] ContextState = FAULTED
In C:\Program Files\Inductive Automation\Ignition\data\db\faulted_20231018_131405 there are a file settings.app with this information:
2020-06-26 10:59:33.797 ERROR ScriptWriter synch error: org.hsqldb.persist.Logger.logWarningEvent java.io.FileDescriptor. sync java.io.SyncFailedException: sync failed
2020-06-26 16:06:18.923 ERROR ScriptWriter synch error: org.hsqldb.persist.Logger.logWarningEvent java.io.FileDescriptor. sync java.io.SyncFailedException: sync failed
2022-01-27 13:02:12.821 ERROR ScriptWriter synch error: org.hsqldb.persist.Logger.logWarningEvent java.io.FileDescriptor. sync java.io.SyncFailedException: sync failed
2023-10-18 16:14:05.793 ERROR error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions org.hsqldb.persist.Logger.logSevereEvent org.hsqldb.error.Error. error org.hsqldb.HsqlException: error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
2023-10-18 16:14:05.793 WARNING Script processing failure org.hsqldb.persist.Logger.logWarningEvent org.hsqldb.error.Error. error org.hsqldb.HsqlException: error in script file line: 35 org.hsqldb.HsqlException: user lacks privilege or object not found: com.inductiveautomation.ignition.gateway.localdb.HSQLUtilFunctions
I can’t seem to work out of.
Thanks in advance.