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.
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
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"?
Comments
Erwin Kunz
Jan 18 '13, 4:12 a.m.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