cannot open a corrupted work item - how can I delete it?
Thomas Rutledge (3●1●6●7)
| asked Aug 01 '12, 9:46 a.m.
edited Aug 08 '12, 1:45 p.m. by Jared Burns (4.5k●2●9)
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
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
Comments 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. 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. Your last directions worked like a charm! The errant work item is not gone. Thank you! |
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.