cannot open a corrupted work item - how can I delete it?
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
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!