Highlighted

Duplicate queues in workspace

Avatar

30-09-2008

Livecycle 8.0.1, JBoss, RH Linux, Oracle 10 database



We imported a workflow from our dev system to our system test system and pushed some process instances through.



Unfortunately, the group queue for one of the user steps had not been set up correctly so five processes stalled at that step.



Using Workbench, I corrected the queue name in the user step to match the group name in the admin UI. I then retried the stalled process instances.



After the retries, in the workspace, each user in the group could see five duplicate copies of the queue, each with one of the previously stalled process instances in it. Completing the tasks did not cause the duplicate queues to go away.



Having had a poke around in the Oracle database, I notice that TB_QUEUE has five rows in it with different id's but the same title. All other data in the rows is the same. Can I just delete the four duplicate rows to make the problem go away? If I do that, it seems I'll have to check TB_ASSIGNMENT to make sure the queue ids are not in use. Do I need to do anything else?

Replies

Avatar

Avatar

Jasmin_Charbonn

Avatar

Jasmin_Charbonn

Jasmin_Charbonn

30-09-2008

Can you clear them from the adminui (under Process Management) instead.



You should never clear items from the database manually.



Jasmin
Highlighted

Avatar

01-10-2008

Clear what from the adminui?



The process instance have long since gone to completion but the duplicate queues remain.



I realise it's generally a bad idea to remove stuff from the database, but we are talking about corruption introduced by a bug in LiveCycle here.