RIODS tables/views do not exits after upgrade from 6.0.1 to 6.0.3. Do I just re-run the repotools-ccm -createWarehouse again?
I upgraded RTC from 6.0.1 to 6.0.3.
The system testers report that they can no longer get any data from JRS.
The only errors that I see are:
RIODS.Team_Resource_Lookup table/view does not exist.
and
RIODS.Request_Category_Team_Lookup table/view does not exist.
This is on Win Server 2008. IBM WAS 8.5.5.11.
Derby database. Using JTS, RM, QM, JRS, DCC, CCM.
We are not using LQE. Not sure what that even provides...
|
2 answers
Hi Michael,
Comments
Michael Johnson
commented May 17 '17, 8:07 a.m.
Hey Kenji, Thanks for the quick response. I checked the data source location and all appears correct and matches what you specified. Almost all of the data collection jobs finish successfully with the exception of: - Change and Configuration Management - Work Item Metrics - Jazz Foundation Services - Project Area (Part 1) - Jazz Foundation Services - Core These 3 jobs fail - it seems - due to tables/views not existing. All other jobs seem to run just fine. Very odd. I have rerun the jobs multiple times, with no success.
Kenji Sarai
commented May 18 '17, 2:52 a.m.
Hi Michael,
Michael Johnson
commented May 18 '17, 8:20 a.m.
Hey Kenji, Thanks so much for the guidance. I do still have the 6.0.1 backup. I will look over my steps and try to determine what went wrong and then run the scripts again. I will post back and let you know the outcome. Thanks! Michael
Michael Johnson
commented Jun 04 '17, 10:46 a.m.
Hey Kenji,
I re-ran the scripts as you suggested and see no change at all. The same ETL Jobs are failing. I am at a bit of a loss as what to do.
Can I re-run all of the steps? Will this over-write data that is already present?
Thanks!
Michael
|
There seems to have been a bit of corruption that occurred during the upgrade process. I have run several repotools commands:
- create tables
- reindex
- recreateTextIndices
Nothing I tried seemed to have any effect on the errors. I am chalking this up to an expensive lesson in upgrading. Although I am not sure what I would have done different in the procedures.
However, my answer to this question is this:
Ensure you have a good post-test process that exercises all parts of the system before informing production that all is good to go. A simple re-running of the DCC jobs would have alerted me to the failures. As this is on a completely virtualized environment, all I would have had to do is swallow my pride, copy over the log files onto a different machine (for post mortem analysis) and revert the snapshots that I taken at the beginning of the process.
|
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.
Comments
Is it possible that the fact we are NOT using LQE is the cause of this? If so, why did it not manifest itself in earlier versions? Is it something we can just install now (this late in the game)?