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