An error occurs when opening the business process definition in Process Designer for WebSphere Lombardi Edition

In the tw-error.log file, you might see messages that are similar to the following text:
2012-09-04 09:57:22,317 [ORB.thread.pool : 0] ERROR com.lombardisoftware.server.ejb.persistence.PersistenceServicesBean  - Exception in EJB call  com.lombardisoftware.client.persistence.common.ObjectNotFoundException: Snapshot.f4220970-c28b-4bea-ae0e-1550f67d140f
   at java.lang.Throwable.<init>(Throwable.java:67)
   at com.lombardisoftware.core.TeamWorksRuntimeException.<init>(TeamWorksRuntimeException.java:11)
   at com.lombardisoftware.client.persistence.common.versioning.VersioningContext$Snapshot.getBranchId(VersioningContext.java:308)
   at com.lombardisoftware.server.ejb.persistence.versioning.BranchManager.readAccess(BranchManager.java:218)
   at com.lombardisoftware.server.ejb.persistence.PersistenceServicesCore.findAll(PersistenceServicesCore.java:98)
   at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)

The cause of this error message is often traced back to the authoring environment experiencing an issue, such as the loss of a server connection, while an unnamed snapshot is being saved to the database. The new TIP_SNAPSHOT_ID is referenced in the LSW_BRANCH table, but the corresponding snapshot is never created in the LSW_SNAPSHOT table.

When you query your LSW_SNAPSHOT table you do not see that snapshot present. For example, use the following query and you will not see the snapshot:

select * from LSW_SNAPSHOT where
SNAPSHOT_ID='622aa140-a5ba-4aaa-9854-66e490264346'

To resolve this problem, complete the following steps:

1. Determine which branch has your snapshot set as the TIP. For example, use the following query:
   Select * from LSW_BRANCH where
   TIP_SNAPSHOT_ID='622aa140-a5ba-4aaa-9854-66e490264346' or
   BASE_SNAPSHOT_ID='622aa140-a5ba-4aaa-9854-66e490264346'
   
   
2. Get a list of the last 20 snapshots that are associated with that process application. For example, use the following query:
   select top 20 s.SNAPSHOT_ID, s.REPOSITORY_BRANCH_ID, s.CREATED_BY_USER_ID, s.CREATED_ON, s.NAME, s.BRANCH_ID, s.PROJECT_ID, s.IS_ACTIVE, s.IS_INSTALLED, s.IS_DEFAULT, s.ERROR_COUNTER, s.ORIG_CREATED_ON, s.IS_ARCHIVED, s.ARCHIVED_ON from lsw_snapshot s inner join lsw_branch b on b.PROJECT_ID = s.PROJECT_ID and b.TIP_SNAPSHOT_ID = (select tip_snapshot_id from LSW_BRANCH k, lsw_project l where k.PROJECT_ID = l.PROJECT_ID and l.NAME = '[PROCESS_APP_NAME]') order by s.CREATED_ON desc
   
   
3. Update the TIP snapshot of that Project ID. For example, use the following query:
   UPDATE LSW_BRANCH
   SET TIP_SNAPSHOT_ID = '[MOST_RECENT_TIP_SNAPSHOT]'
   WHERE PROJECT_ID = '[PROJECT_ID]'

Your TIP (working) snapshot is reverted back to the last saved version of your process application. You can continue editing your project.