Troubleshooting
Problem
After you open the business process definition (BPD) in Process Designer, you see persistence-related messages in the tw-error.log file.
Symptom
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)
Cause
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.
Diagnosing The Problem
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'
Resolving The Problem
To resolve this problem, complete the following steps:
- 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'
- 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
- 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.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21616682