Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Duplicate queues in workspace

Avatar

Former Community Member
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?
2 Replies

Avatar

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



You should never clear items from the database manually.



Jasmin

Avatar

Former Community Member
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.