Eclipse Community Forums: Eclipse Process Manager (Stardust) » Worklist Table not synchron with Activity Table

Home » Archived » Eclipse Process Manager (Stardust) » Worklist Table not synchron with Activity Table(The Worklist Query returns different results than the Activity Query)

Worklist Table not synchron with Activity Table [message #1069251]

Mon, 15 July 2013 10:16

Eclipse User

I have the situation, that the worklist query returns different results than the activity query.

It looks like the table WORKITEM is not synchron with the table ACTIVITY.

Is there a possibility to cleanup the state or synchronize the WORKITEM table with the ACTIVITY table?

Re: Worklist Table not synchron with Activity Table [message #1069285 is a reply to message #1069251]

Mon, 15 July 2013 11:41

Eclipse User

Looks like the following statement did it for me:

UPDATE WORKITEM SET WORKITEM.STATE = (SELECT STATE FROM activity_instance WHERE workitem.activityinstance = activity_instance.OID);

Don't know how it could happen to get out of sync.

Previous Topic:	Camel Application Type / Webmodeler
Next Topic:	NullPointerException in UserUserGroupLink#delete

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 08:37:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter