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?
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.