Changing BIRT report from RTC 2.x to 4.x - where's the data?
I have a BIRT report from 2.x that no longer runs in 4.x. It appears one of the tables is no longer there:
Cannot set statement property. org.eclipse.datatools.connectivity.oda.OdaException: Table not found TABLE NAME: CONTRIBUTOR_ASSIGNMENT FACT_ID TIME_ID PROJECT_AREA_ID TEAM_AREA_ID DEV_LINE_ID CONTRIBUTOR_ID ASSIGNMENT If I edit the data set, I discover the table does in fact no longer exist. Instead, there is the following table: TABLE NAME: LIVE_CONTRIBUTOR_ASSIGNMENT CONTRIBUTOR_ITEMID ASSIGNMENT Surname Much is missing from that other table that I need for this report. Where did all that data move to? And before someone mentions it, I am aware of RRDI. It will be months before we have an RRDI server approved and setup. |
One answer
Hi Mike,
as mentioned in https://jazz.net/wiki/bin/view/Main/ReportsMigrating20To30 : "When moving from RTC 2.x to RTC 3.0, some changes may need to be made to your existing custom BIRT reports in order for them to function correctly" Regards, Stéphane Comments I am aware there have been changes. The one table I need is gone and I have no idea where to find the data. The page you linked to says, "The table APT_SNAPSHOT.CONTRIBUTOR_ASSIGNMENT is no longer in the schema. APT_SNAPSHOT.LIVE_CONTRIBUTOR_ASSIGNMENT is still there." Ok, great, where did that data move to? The "LIVE" version of the table doesn't have all the fields. Is there a cross-reference - like "if you used this, now use THIS"?
|
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
Like the question. I had a similar one some weeks ago
https://jazz.net/forum/questions/95422/create-a-birt-report-showing-team-work-allocation