Data warehouse problems after upgrade
We updated from CLM 5.0.2 to 6.0.3 recently and soon noticed our data warehouse started to malfunction. I discovered the problem when my Cognos reports that summarized data from the Timesheet table of the data model started coming up empty the day after the upgrade. I attempted to fix it by downloading what I assumed was the new data model for version 6, but soon got hung up there. The details on that attempt are found in this forum post:
Then, we discovered that the Burndown widget reports in RTC also stopped working on this same upgrade date. These two problems have to be related somehow; both reports get data from the data warehouse. However, I doubt that the burndown reports are related to the data model download I tried for the timesheet problem.
We will submit a support request to IBM, to see if we missed anything in our upgrade steps, but I thought I'd ask the community if they could give us any help.
Appreciative of any help or ideas,
Ryan
|
3 answers
Hello Ryan,
|
Are your DCC jobs to populate the warehouse running correctly, with no errors?
|
|
Jackie, Yes, our DCC jobs are running successfully every night. Only reports which gather timesheet data, and now the burndown reports from the out-of-the-box widgets, do not work (as far as I know). The data warehouse otherwise appears to be working fine.
Francesco,
We have DCC installed and configured. You said that the default CLM data collection was removed. We have DCC though, so this shouldn't be my problem, right? As I said, there is data in the data warehouse, it just appears that some of it is missing.
Thanks for your responses,
Ryan
|
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.