Can anyone help me with this one?
Redundant gateway, both are faulted.
Unclear. Share the entire wrapper log with support.
Share what else might have changed. Deserialization errors are typically caused by module removals or attempts to restore a backup from a newer system.
wrapper.log (7.9 MB)
The problem happened when I was restoring a database to a remote computer.
Any other file that I can share?
No. There’s some truly evil badness going on there. I don’t understand how a PostgreSQL object instance could have gotten serialized into the internal DB, but it certainly cannot be extracted. On top of that, there’s an infinite recursion bug in the OPC stack somewhere. You really need IA support to look over your shoulder. Or revert to your last know good gateway backup and wash your hands of the situation.
And it’s an end-of-life Ignition version. ):
Thank you very much! I am on the phone with tech support now.
Lots of issues in the logs, but ultimately the startup failure looks like this:
| java.lang.NullPointerException: null | at java.base/java.io.ByteArrayInputStream.<init>(Unknown Source) | at com.inductiveautomation.ignition.common.xmlserialization.deserialization.XMLDeserializer.deserialize(XMLDeserializer.java:241) | at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.lambda$initializeQueries$0(NamedQueryExecutor.java:96) | at java.base/java.util.ArrayList.forEach(Unknown Source) | at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.initializeQueries(NamedQueryExecutor.java:92) | at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.initializeQueries(NamedQueryExecutor.java:82) | at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.<init>(NamedQueryExecutor.java:76) | at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager$NamedQueryLifeCycle.onStartup(GatewayNamedQueryManager.java:326) | at com.inductiveautomation.ignition.gateway.project.ProjectLifecycle.onStartup(ProjectLifecycle.java:38) | at com.inductiveautomation.ignition.common.lifecycle.AbstractLifecycle.startup(AbstractLifecycle.java:18) | at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory$1.maybeStartLifecycle(ProjectLifecycleFactory.java:234) | at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory$1.lambda$projectAdded$0(ProjectLifecycleFactory.java:124) | at java.base/java.util.Optional.ifPresent(Unknown Source) | at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory$1.projectAdded(ProjectLifecycleFactory.java:124) | at java.base/java.util.ArrayList.forEach(Unknown Source) | at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory.onStartup(ProjectLifecycleFactory.java:47) | at com.inductiveautomation.ignition.common.lifecycle.AbstractLifecycle.startup(AbstractLifecycle.java:18) | at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager.onStartup(GatewayNamedQueryManager.java:57) | at com.inductiveautomation.ignition.common.lifecycle.AbstractLifecycle.startup(AbstractLifecycle.java:18) | at com.inductiveautomation.ignition.gateway.IgnitionGateway.startupInternal(IgnitionGateway.java:1094) | at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:293) | at com.inductiveautomation.ignition.gateway.IgnitionGateway.initRedundancy(IgnitionGateway.java:710) | at com.inductiveautomation.ignition.gateway.IgnitionGateway.lambda$initInternal$0(IgnitionGateway.java:644) | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:518) | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) | at java.base/java.util.concurrent.FutureTask.run(Unknown Source) | at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) | at java.base/java.lang.Thread.run(Unknown Source)
Did you restore a gateway backup from a newer version of Ignition?
Not sure if you were able to get this resolved already, but as Kevin was alluding to this error typically occurs after moving named queries from 8.1.7 or later to a pre-8.1.7 gateway. To resolve this you can either upgrade your gateways, or delete any named queries that use .sql files instead of .bin. In your case, it looks like the last project being loaded was SPREE_H6_LSS, so I would start with named queries in that project.
Thank you very much all of you. I have had help from the local tech support. I must say they were superb and brought both gateways back to life.
You guys here also helped a lot. Your messages were spot-on. I have been importing named queries developed on 8.1 from other projects into this one. Those queries were removed and then rewritten in the 8.0.17 designer.
The system is up and running.
Thank you! The tech support helped me remove some queries that I imported from a system running on 8.1.7.
Hi. Spot on! Thank you!