Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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?

0 votes


Accepted answer

Permanent link
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

2 votes

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

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 369

Question asked: Aug 01 '12, 9:46 a.m.

Question was seen: 10,286 times

Last updated: Aug 14 '12, 7:18 a.m.

Confirmation Cancel Confirm