Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Go to next message
Florian Kammermann is currently offline Florian Kammermann
Messages: 12
Registered: October 2012
Junior Member
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 Go to previous message
Florian Kammermann is currently offline Florian Kammermann
Messages: 12
Registered: October 2012
Junior Member
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:
  


Current Time: Thu Jul 24 04:37:39 EDT 2014

Powered by FUDForum. Page generated in 0.01608 seconds