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

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Mon, 15 July 2013 10:16

Florian Kammermann
Messages: 11
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?

Report message to a moderator

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

Mon, 15 July 2013 11:41

Florian Kammermann
Messages: 11
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 07 16:10:51 EDT 2013