Lost requirement - looked in database - issoftdeleted = 1
ENV: Jazz 3.0.1.2, RHEL, Oracle DB, WAS, IHS reverse-proxy
We have a requirements collection that is missing one of its requirements. If I look in the db
I have a few questions:
Thanks!
Joseph
|
Accepted answer
Benjamin Silverman (4.1k●6●10)
| answered Aug 16 '12, 2:58 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Joseph,
Requirements are marked as soft deleted in the Data Warehouse when the application API returns TRUE that the artifact has been deleted. In the case of Requirements Composer, the publishing/reporting API uses a flag called "IsDeleted", which returns true for requirements that have been deleted. To answer your questions: 1) See above 2) Setting issoftdeleted=0 in the data warehouse will not make data re-appear in RRC. RRC does not rely on data in the data warehouse for application data 3) When you create a requirement in RRC, you must execute the Requirements ETL in order for it to be loaded in to the data warehouse 4) You can tell who deleted the resource by getting the latest revision of the artifact and looking at the most recent change. It should say something like "Bob changed: "Resource removed". Here's how you can do that... a) Get the URI of the artifact. If you've already found the record in the operational data store -> Requirement table, it's the "External Key 2" field (ie - https://clmweb.ibm.com:9443/resources/_lQbhMOfSEeGL5YOIvjHU3g) b) In your browser, enter a query to get the revisions of the artifact: https://clmweb.ibm.com:9443/rm/revisions?private=true&accept=*&url=https://clmweb.ibm.com:9443/rm/resources/_lQbhMOfSEeGL5YOIvjHU3g c) The query should return a feed showing all the revisions, from most recent to the initial creation. d) Click on the link for the most recent revision. It should be the first one listed at the top of the page. This will bring you in to the artifact history viewer where you can hover over the blue box to the far left (most recent revision) and click "Show More" to see who deleted the artifact. Hope it helps, Joseph van Blokland selected this answer as the correct answer
Comments
Joseph van Blokland
commented Aug 16 '12, 4:12 p.m.
Great answer - helped me understand the Jazz and the db a bit more. Found out who removed the requirement :) Can I revert to the previous version of the requirement? You did not indicate the tables that host the revisions and the actual requirement. Thanks for all your help! |
2 other answers
Benjamin Silverman (4.1k●6●10)
| answered Aug 16 '12, 6:21 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
The tables are much more complicated for the application, so it's not as simple as flipping a bit in the back end like you saw for the data warehouse. Is it not possible to re-create the artifact based on the latest revision you're able to see from the steps above? You should have access to all the content/attributes/links etc through the steps above. You could even create a snapshot and specify the exact date/time you want to visualize if you wanted to see other deleted artifacts without going through the exercise above. Hope it helps,
Comments 1
Thanks again for your answer. Yes we did recover the information in the above fashion. I was just hoping for a Ctrl-Z solution :) BTW creating a snapshot of the past blows away my understanding of time and space. |
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.