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 14: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 15: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: Tue Oct 21 07:23:04 GMT 2014

Powered by FUDForum. Page generated in 0.02188 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software