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

Technote (troubleshooting)


Problem(Abstract)

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:

  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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Lombardi Edition
Authoring Enviornment (AE)

Software version:

7.1, 7.2

Operating system(s):

Platform Independent

Software edition:

All Editions

Reference #:

1616682

Modified date:

2013-01-17

Translate my page

Machine Translation

Content navigation