Hi, We’ve suddenly got this error when opening a project:
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@68e2aab8at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:328)at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:302)at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:259)at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:800)at com.inductiveautomation.ignition.designer.gateway.DTGatewayInterface.loadProject(DTGatewayInterface.java:398)at com.inductiveautomation.ignition.designer.IgnitionDesigner$StartupProjectDialogHandler$1.run(IgnitionDesigner.java:1814)at java.lang.Thread.run(Unknown Source)Caused by: com.inductiveautomation.ignition.gateway.servlets.gateway.functions.GatewayFunctionException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@68e2aab8at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.Projects.loadProject(Projects.java:683)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(null)at sun.reflect.DelegatingMethodAccessorImpl.invoke(null)at java.lang.reflect.Method.invoke(null)at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:177)at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:343)at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)at org.eclipse.jetty.server.Server.handle(Server.java:497)at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)at java.lang.Thread.run(null)
Ignition v7.7.5 (b2015071516)Java: Oracle Corporation 1.8.0_441
Ignition v7.7.5 (b2015071516)
Java: Oracle Corporation 1.8.0_441
We discovered low disk space.
What can I do to recover?
Thanks,
Tim
Reflowed stacktrace for legibility:
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@68e2aab8
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:328)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:302)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:259)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:800)
at com.inductiveautomation.ignition.designer.gateway.DTGatewayInterface.loadProject(DTGatewayInterface.java:398)
at com.inductiveautomation.ignition.designer.IgnitionDesigner$StartupProjectDialogHandler$1.run(IgnitionDesigner.java:1814)
at java.lang.Thread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.gateway.servlets.gateway.functions.GatewayFunctionException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@68e2aab8
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.Projects.loadProject(Projects.java:683)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(null)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(null)
at java.lang.reflect.Method.invoke(null)
at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:177)
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:343)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)
at java.lang.Thread.run(null)
Ignition v7.7.5 (b2015071516)
Java: Oracle Corporation 1.8.0_441
GatewayFunctionException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@68e2aab8
Something in the internal database is broken. I believe 7.7.5 is so old it predates the SQLite internal database, meaning you're using an older embedded DB called HSQL, which we migrated away from precisely because of corruption issues like this.
HSQLDB is an open source tool - you might be able to download a modern build of it and see whether it can open/explore/recover whatever is wrong in Ignition's internal DB, which is probably going to be in one of the PROJECTS or PROJECT_CHANGES or PROJECT_RESOURCES table(s). But that's entirely a guess on my part; it's been so long that I don't know if there is any meaningful way to 'recover' from an HSQL DB fault.
Another hail mary option would be to upgrade to the latest 7.7 version, which if I remember correctly uses the "new" SQLite internal database. The migration process might be able to cope with upgrading your HSQL DB.
I'll also state this for the record to get ahead of it:
You're using a vintage, 10 year old piece of software that is long out of any maintenance or support window. Any help you receive is going to be via these forums, which are populated with volunteers. I'm IA staff, but there are no SLAs or guarantees of response or anything like that here on the forums.
1 Like
Paul, Thanks for the quick response.
I’ll look at the HSQLDB tool.
If I get version 7.7, can I just restore a gateway backup? Is that where the project is stored?
Will I need a new license? I’m using just SQL Bridge.
Thanks,
Tim
You can upgrade to any version of 7.7 without needing a new license.
Thanks Kathy.
I’ve restored a backup from a month ago and can now open the project. I’ve lost a few days work but could have been worse.
I’m going to upgrade to V7.7.10 from my version 7.7.5.
Is there anything I should be aware of before I do the upgrade.
Thanks again for all the help
Tim
I would take a backup from the existing system and store it, but generally speaking 'minor' version upgrades are pretty safe.
Paul,
Tried your Hail Mary…
Restored the corrupted application and installed 7.7.10
Worked perfectly!!!
Thanks a million 
Tim