Cannot open a project (Can't run it or open with designer)

Ignition
1

Hello,

When I try to open a project I get following error:
GatewayException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@1e3d1c
caused by SException$Jdbc: Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@1e3d1c

I have version 7.5.7
Java: Oracle Corporation 1.7.0_21

If I try to run project I get Internal error 500 etc…

Here is message from console:

ERROR(500): Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@1e3d1c
simpleorm.utils.SException$Jdbc: Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@1e3d1c
at simpleorm.sessionjdbc.SSessionJdbcHelper.retrieveRecord(SSessionJdbcHelper.java:464)
at simpleorm.sessionjdbc.SQueryExecute.findOrCreateFromResultSet(SQueryExecute.java:194)
at simpleorm.sessionjdbc.SQueryExecute.executeQuery(SQueryExecute.java:68)
at simpleorm.sessionjdbc.SSessionJdbc.queryNoFlush(SSessionJdbc.java:489)
at simpleorm.sessionjdbc.SSessionJdbc.query(SSessionJdbc.java:498)
at com.inductiveautomation.ignition.gateway.project.ProjectManagerImpl.loadProjectResources(ProjectManagerImpl.java:482)
at com.inductiveautomation.ignition.gateway.project.ProjectManagerImpl.loadProject(ProjectManagerImpl.java:469)
at com.inductiveautomation.ignition.gateway.project.ProjectManagerImpl.getProject(ProjectManagerImpl.java:385)
at com.inductiveautomation.ignition.gateway.servlets.Gateway.runLoadProject(Gateway.java:1128)
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:438)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: lob is no longer valid
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCBlobClient.length(Unknown Source)
at com.inductiveautomation.ignition.gateway.localdb.persistence.BlobField.queryFieldValue(BlobField.java:59)
at simpleorm.sessionjdbc.SSessionJdbcHelper.retrieveRecord(SSessionJdbcHelper.java:461)
… 24 more
Caused by: org.hsqldb.HsqlException: lob is no longer valid
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.persist.LobManager.getLength(Unknown Source)
at org.hsqldb.Session.performLOBOperation(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
at org.hsqldb.types.BlobDataID.length(Unknown Source)
… 27 more

What I have done:

Reboot computer
Delete Java cache
Delete .ignition directory
Reinstall Java
Reinstall Ignition

Nothing has helped so far. I can’t open project or continue working with it.

2

It sounds like you might have a corrupt installation of Ignition. A couple of questions:
Was your Ignition an upgrade from an older version?
If so, did this happen before the upgrade?
Are you getting this error when opening a Client, a Designer, or both?
Do you have a Gateway Backup from before you started having this problem?

3

i have the same problem but i can’t connect to the gateway, then today download the update of ignition, i can create new projects but the old one is impossible to use in designer or project mode

here is the message

GatewayException: Project loading failed. Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@de08215
caused by SException$Jdbc: Getting Field 12 from simpleorm.sessionjdbc.SSessionJdbcHelper@de08215

Ignition v7.6.4 (b2013112117)
Java: Oracle Corporation 1.7.0_51

please tell me my ptoject is not lost

4

Please call into support and they can help you try and restore from an auto-backup

5

I get the same error! I can’t open my projects and can’t even go to the Projects section under Configure.

AND NO, I didnt upgrade my Ignition or anything!

6

Was anyone able to get their projects back?

7

You may be able to get them from an auto-backup.

Take a look at this thread. While my issue was about tags, this will work for projects as well.

8

antoniocastaeda-
Did you call into support? If so, what was the resolution to the problem?

oxanemi-
Are you still experiencing issues as well? Where you able to restore one of your auto-backups to resolve
the issue?