It's all about the answers!

Ask a question

cannot open a corrupted work item - how can I delete it?

Thomas Rutledge (3167) | asked Aug 01 '12, 9:46 a.m.
edited Aug 08 '12, 1:45 p.m. by Jared Burns (4.5k29)
In an RTC repository, when we try to open a  (BUE Defect) work item, we get:

Error fetching or storing Work Item 89824 | Details: Error opening work item. CRJAZ0350I Error fetching item values. statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID IN statement suffix = parameter[0] = _kgvSxssMEeG2JZh7mBwkeg parameter[1] = _g6NEcMpdEeGQld3p8lQFRA parameter[2] = _g3bdRMpdEeGQld3p8lQFRA parameter[3] = _g7FOOspdEeGQld3p8lQFRA parameter[4] = _WDuqIMpdEeGQld3p8lQFRA

This item seems to be corrupted, so we would like to delete it.  However, it seems the "delete" open is only available to an opened work item...

Anyone have any suggestions?

Accepted answer

permanent link
Daniel Pool (2644) | answered Aug 08 '12, 12:54 p.m.
If you can view the work item in query results you can can delete it from the web UI without opening it. You can do this by clicking the "Edit Multiple Work Items" button. Then select the checkbox to select the work item. Then click the delete button.

See this article on deleting work items for additional info.
Thomas Rutledge selected this answer as the correct answer

Thomas Rutledge commented Aug 09 '12, 9:55 a.m.

Thanks for this update.

I logged in as one of the repo admins, went to the work item list, selected "Edit Multiple Work Items" and then selected the bad item (checked the box). But when I clicked on the Delete link, repo responded with insufficient permission to delete.

I then used the info from your "deleting work items" link to try to add this permission, but I cannot get the "delete work items" option to show in the permissions list.

Any suggestions on this?

I appreciate all the help you can provide.

Daniel Pool commented Aug 09 '12, 12:56 p.m. | edited Aug 09 '12, 12:58 p.m.

You need jazz admin or jazz project admin permissions to delete a work item. The UI for deleting work items does not appear unless you have those permissions. You also need to be logged in with a role that has permissions to delete work items. This generally requires that you modify the project permissions to grant delete work item permissions for some role in the project.

Your repo admin probably had jazz admin or project admin permissions. But not project permissions.

Your regular user probably has delete work item permissions for your role. But not jazz admin/project admin permissions.

Thomas Rutledge commented Aug 14 '12, 7:18 a.m.

Your last directions worked like a charm! The errant work item is not gone.

Thank you!

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.