[closed] Error while updating CCM application to 4.0.5
![]()
Simon Eickel (1.1k●7●54●57)
| asked Dec 16 '13, 8:50 a.m.
edited Mar 18 '14, 12:37 p.m. by Patrick Remington (201●3)
Hi community,
I'm back again with some curious error. we had the situation (during a training) that some work items filed with a visibility restricted (and access restricted) category where visible to users who where no member of the restricted team. This is the category tree - all categories are restricted. But we take our eyes on "Reihe 4 Category": ![]() Within this team (Core Team/Reihe 4 Team) you see there is no user "eickel_s": ![]() But when I create a query as user "eickel_s" I'm able to see a subset of work items filed against "Reihe 4 Cateroy". ![]() Same for one work item with "Reihe 3 Category". Those work items shouldn't be visible to me as I'm no team member of this team. Other work items of this category are not visible to me - there are some more - but those 3 work items are visible ... why? After this we noticed that the full text search for work items didn't work any more. So I rebuilt all the indexes of ccm and jts but only effect was that the full text search was working again. The visibility problem still existed. As I wanted to update the server to 4.0.5 this weekend I did not think about this error anymore and started the update process. The upgrade failed while adding tables to the ccm database With this error message: ![]() My assumption on this is this: All the work items which are still visible do not have this entry within the context tables. Why? I think those work items where created while the index was corrupt. After rebuilding all the indexes searching was possible again but the entry within the context tables was still missing for those work items. I switched the category for one of those work items to another category and than back to the restricted one and yes - I lost view within the query. This means not - as the index is workin' again - setting the restricted category to the work item creates the entry within the context tables and the visibility protection is set correctly. I'm glad that the update process recognizes such problems and fails in updating until they are repaired. My problem is now - How can we monitor if the index is corrupted and how can we repair such a missing entry in the context tables? - For three work items I can reset the category manually. But if there are more "corrupted work items"? Do I have to set this manually all the way? - Why did the index got corrupted? - How can we ensure that this won't happen again? At the moment we are using 4.0.4 and SQL server database. For answers and ideas on this I would be very thankful. Greetings, Simon |
The question has been closed for the following reason: "The question is answered, right answer was accepted" by eickel Dec 27 '13, 5:01 a.m.
Accepted answer
![]()
I had the same problem and was able to fix it with help of IBM support.
If a server contains a project area that is set to private (an access control setting other than "Everyone") and the list of members with access is empty (such as the project area hierarchy, or an access list), along with the administrator list, then that project area can sometimes be seen as an invalid context. This causes errors during upgrading. I restored DB and started old CCM. Then I checked all my project areas, also the archived ones. I found one archived PA with NO projectarea members and NO administrator assigned. I also found three archived project areas without projectarea members but with administrators defined. I added a member to all four archived PA's and restarted the upgrade. This time it run though without an error. here the answer from IBM support I got:
Simon Eickel selected this answer as the correct answer
Comments Hi Guido,
Guido,
The "com.ibm.team.repository.service.internal.diagnostic.DiagnosticRestService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.diagnostic.IDiagnosticEmailService", failed to be activated.ID CRJAZ1972E
Caused by:
The "com.ibm.team.repository.service.internal.diagnostic.DiagnosticEmailService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.diagnostic.IDiagnosticResultService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceReg
|
One other answer
![]()
Hi Simon,
I believe that more users than you have already such issue. See e.g. https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=294764 - How can we monitor if the index is corrupted and how can we repair such a missing entry in the context tables? You can check it in server diagnostic page under JFS Indexs section: https://your-server:9443/ccm/admin#action=com.ibm.team.repository.admin.serverDiagnostics https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=155003 - For three work items I can reset the category manually. But if there are more "corrupted work items"? Do I have to set this manually all the way? I would create new dummy category, run the query for searching all work items from restricted category and change the category to the dummy one (see answer for Guido Schneider how to bulk modify workitems: https://jazz.net/forum/questions/87399/i-am-using-rtc-3012-is-there-any-way-of-deleting-multiple-workitems-at-one-go) and then rollback to old category. - Why did the index got corrupted? Good question :) It might have been any outage, someone has been modified your index files or simply it might be any (unknown) defect in the product. As you have already opened PMR for that, please deliver your jts and ccm log files and let us know when you have observed first the issue with searching. - How can we ensure that this won't happen again? We need to know why the index got corrupted to know how we can avoid it in the future. What you can do is checking regularly server diagnostic page. How to check if the index or some other things are corrupted within database is possible with the "repotool -verify" command. Once we determine what and why exactly is corrupted, we can consider creating the diagnostic tool to check that. Even after setting the restriction correctly the problem still exists. We already unrestricted all categories and at least deleted all work items but the upgrade progress still fails... Any idea how to fix this error within the database tables? See defect 294764 with troubleshooting steps: Please run following query on RQM to find the projects in this state: SELECT ER.ITEM_ID, 54 from EXECUTION.EXECUTION_RECORD ER LEFT JOIN REPOSITORY.ITEM_TYPES IT ON ER.ITEM_ID = IT.ITEM_UUID WHERE IT.ITEM_UUID IS NULL and on RTC: select NAME_COL from PROCESS.PROCESS_AREA where JZ_DISCRIMINATOR=1 and CONTEXT_ID not in (select X.CONTEXT_UUID from REPOSITORY.CONTEXT_MEMBERS X UNION select Y.CONTEXT_UUID from REPOSITORY.CONTEXT_SUBCONTEXTS Y) if there are no results for the query above, please run following query to find possible JZ_DISCRIMINATOR values: select ITEM_ID, JZ_DISCRIMINATOR from PROCESS.PROCESS_AREA The query select NAME_COL from PROCESS.PROCESS_AREA ... will return you all private project areas with no members. There is known defect and the work around is to add any member to these project areas. Please let me know if my tips helped you. Comments Hi Christoph,
How to fix:
on database
|
Comments
How to check if the index or some other things are corrupted within database is possible with the "repotool -verify" command.
But still we're facing the problem - how to fix this?
just one more information:
Even after setting the restriction correctly the problem still exists.
We already unrestricted all categories and at least deleted all work items but the upgrade progress still fails...
Any idea how to fix this error within the database tables?
During my 405 upgrade preparation I run into same problem on my staging machine.
For me it would also be interesting, how serious the issue is. The DB seems to be migrated but unstable. Does this mean, just this problem is still in the DB, but the it's not worse than before the upgrade?
@@Simon: have you solved the problem on your site? Will you proceed with 405 upgrade?
Hi Guido,
sorry for my late reply but I was on holiday :)
Please see my answer as comment to your answer.