RTC BIRT Reports do not see data from the Rational Insight data warehouse
After switching the our CLM servers from local data warehouses to a shared Rational Insight data warehouse, the RTC Shared BIRT reports do not see the data from the Rational Insight warehouse.
The Work Items report "Open Work Items" when run, results in "No work items were found".
The RQM BIRT Reports work fine and the prompts for them are populated. The Rational Insight ETL is running fine, and I have verified the data is in the Rational Insight warehouse. Is there something that needs to be done on the CLM Servers to make the connection to the Rational Insight data warehouse. Other than to change the Data warehouse connection settings. |
One answer
|
Ok, that explains what is happening. I changed the resourceGroup guids in the xdc files, which are used as keys in the ETL_INFO table. This was done to make it easier to tell which rows were for which of the 6 production CLM servers. I will have to change the guids back to the ones from the generated xdc files and update the ETL_INFO table to reflect the changed guids.
Comments Here's a query you can use to get the original ID per repository:
I find that a lot easier than re-downloading the XDC files. |
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
Running the Work Items "Data Collection Job" will populate the prompts for the "Open Work Items" report. But, I don't want to run the Data Collection jobs any more. I want the RTC report prompts to see the latest data in the warehouse when the Rational Insight RTC job is run.
Running the Rational Insight RTC job will update the Rational Insight data warehouse, but the RTC report prompts do not see the new data. What triggers the prompts to get new data from the Rational Insight warehouse?
As you've found, the BIRT reports only run against the RTC repository and RTC warehouse. they will not run against the Insight warehouse.
You say "the BIRT reports run against the RTC repository and RTC warehouse." When you use Rational Insight, then the RTC warehouse is the Rational Insight warehouse. The RTC prompts appear to get their data from the Rational Insight warehouse, but they do not see new data populated into the RI warehouse. It appears the prompt data is cached. The Java ETL must trigger the cache to be refreshed. With Rational Insight, what triggers the cache to be refreshed?
RTC has a mechanism that lets it know that the data in the Insight Warehouse has changed. It basically looks at the CONFIG.ETL_INFO table to know when was the last time the ETL had run successfully.