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:
3 answers
Hello Ryan,
expanding on Jackie's answer, if you were using the default CLM data collection (Java ETL) in 5.0.2, this has been removed in version 6.
In order to populate the data warehouse you need to add the Data Collection Component (DCC) to the CLM installation and configure it.
The recommendation is to have the application on a dedicated server as being better performing than the Java ETL it utilizes more resources and might affect negatively other applications on the same machine.
Best Regards
Francesco Chiossi
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.