RRDI / CLMv4.0 unable to connect DW
Hello,
We installed RRDI via the instructions from help and the video here: However, on video 3, there is a configuration that walks through setting up to extract the data from Money That Matters. We followed the video, but at the end where the user Connects to JKE, we are blank. The Data collection area states Failed, but we are trying to see what happened. Where do we start troubleshooting?
|
5 answers
To make sure I understand this correctly, the install and Setup succeeded with no errors. You loaded the report archive (from RTC?) and can see the reports in the Cognos Connection UI. The Public Folders folder isn't empty. When you run a report, it runs fine but the project selection drop down is empty.
If that is right, I would suggest to first verify that the data is in the data warehouse. Look in the PROJECT table (RIODS schema) in your data warehouse. You can use Control Center if you are using DB2. You should see the JKE Banking projects. If you don't, you need to run the data collection jobs. I assume you loaded the MTM data with CLM and can see it in the product UIs. You also need to ensure that the account you've logged in with has access rights to the JKE projects. RRDI will not show data in reports if the user does not have access to the project. This is a security measure, as reporting should not show data that the product itself wouldn't show. Mike |
|
Sterling Ferguson-II (1.6k●8●280●269)
| answered Jul 02 '12, 12:23 p.m.
edited May 18 '22, 10:39 a.m. by Shailee Sinha (11●3)
Michael,
We connected, and can work in each of the MTM databases. We gave etl_user a contributor license and now we only get to view JKE Quality Management. If we select this project, the rest of the columns never fill. We still do not see JKE Change Management.
Here is an image of the RIODS: (again, we can work in the CCM part, but do not see it below.)
|
|
Sorry about the problem with the image. All it really showed was a "JKE Banking (Change Management)" row in the PROJECT table, in addition to the two other JKE Banking rows. As you don't have that in your PROJECT table, then the data isn't in the warehouse correctly which is why you can't report on it.
If you can see and work with the CCM data in RTC, dashboards work and show content, etc, then there is something up with the Data Collection Jobs. Are you sure your etl_user has the right access privileges? This is likely going to need somebody from the RTC area to look at this. I'll send some email about it. Mike |
The ETL User must have Jazz Admin and the Data Collector license. If you make those changes to the ETL user, you will need to run full Common ETL in jts, ccm and qm. |
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
Actually, we retraced our steps and are right here:
https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.rational.rrdi.admin.doc%2Ftopics%2Ft_postinstall_verify_connect_clm.html
No data is given when we view the reports. We cannot pick a project.