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

**URL:** <https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604>\
**Category:** Ignition\
**Created:** [May 30, 2013, 4:44am UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604 "2013-05-30T04:44:36Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![RandallIron](https://avatars.discourse-cdn.com/v4/letter/r/f9ae1b/32.png) [@RandallIron](https://forum.inductiveautomation.com/u/RandallIron)\
**Post date:** [May 30, 2013, 4:44am UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/1 "2013-05-30T04:44:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [June 26, 2013, 11:40pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/2 "2013-06-26T23:40:15Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![antoniocastaeda](https://avatars.discourse-cdn.com/v4/letter/a/41988e/32.png) [@antoniocastaeda](https://forum.inductiveautomation.com/u/antoniocastaeda)\
**Post date:** [March 5, 2014, 11:09pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/3 "2014-03-05T23:09:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 7, 2014, 7:58pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/4 "2014-03-07T19:58:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![oxanemi](https://avatars.discourse-cdn.com/v4/letter/o/0ea827/32.png) [@oxanemi](https://forum.inductiveautomation.com/u/oxanemi)\
**Post date:** [May 27, 2014, 5:49pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/5 "2014-05-27T17:49:19Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![oxanemi](https://avatars.discourse-cdn.com/v4/letter/o/0ea827/32.png) [@oxanemi](https://forum.inductiveautomation.com/u/oxanemi)\
**Post date:** [May 27, 2014, 6:02pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/6 "2014-05-27T18:02:05Z")

</div>

Was anyone able to get their projects back?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 27, 2014, 8:01pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/7 "2014-05-27T20:01:26Z")

</div>

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

Take a look at [this thread](http://inductiveautomation.com/forum/viewtopic.php?f=72&t=6050&hilit=+context). While my issue was about tags, this will work for projects as well.

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [June 2, 2014, 3:43pm UTC](https://forum.inductiveautomation.com/t/cannot-open-a-project-cant-run-it-or-open-with-designer/6604/8 "2014-06-02T15:43:42Z")

</div>

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?
