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 Work Items report "Work Item Comparison" has no data in the Team Areas, Timeline or Iteration prompts.
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
Comments
Here's a query you can use to get the original ID per repository:
| https://localhost:9443/ccm/rpt/repository/generic?fields=generic/com.ibm.team.repository.RepositoryRoot/itemId |
I find that a lot easier than re-downloading the XDC files.
Comments
Steve Mulligan
Dec 17 '13, 2:10 p.m.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?
sam detweiler
Dec 17 '13, 2:47 p.m.As you've found, the BIRT reports only run against the RTC repository and RTC warehouse. they will not run against the Insight warehouse.
Steve Mulligan
Dec 17 '13, 3:30 p.m.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?
Rafik Jaouani
JAZZ DEVELOPER Dec 17 '13, 3:45 p.m.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.
1 vote