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
![]() 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.
|
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)?