Internal Error in a BIRT report with a cascaded parameter group (based on multiple datasets)
Hello all
we are on RTC 3.0.1.4 and BIRT 2.5.2
In eclipse BIRT I have created a report with the two datasources:
- LIVE_SNAPSHOT
- WORKITEMS_SNAPSHOT
Based on these I have created
- the two parameter datasets
- Project Parameter dataset
- based on the LIVE_WORKITEM_CNT table
- with the selected the output columns PROJECT_AREA_NAME, PROJECT_AREA_ITEMID and CONTRIBUTOR_ITEMID
-
the default value of the parameter CONTRIBUTOR_ITEMID is set to '{Current Contributor}'
- Query Parameter dataset
- based on the com.ibm.team.workitem.query.QueryDescriptor table
- with the selected output columns itemId, name, projectArea.itemId and creator.itemId
- the default value of the parameter creator.itemId is set to '{Current Contributor}'
- the parameter projectArea.itemId is linked to the Project parameter of the cascaded Parameter Group Project - Query
- a cascaded parameter group Project - Query based on multiple datasets with the two parameters
- Project
- based on the dataset Project Parameter
- display type List Box
- value set to PROJECT_AREA_ITEMID
- display text set to PROJECT_AREA_NAME
- Query
- based on the dataset Query Parameter
- display type List Box
- value set to itemId
- display text set to name
In the eclipse BIRT designer and on our RTC training environment this report is running successful.
As expected I can select only Projects where I am assigned to work. Selecting a project I can only select the queries I have created for the selected project. All works like I have expected.
When I publish exactly the same report design into our RTC Production environment the report is not running. I get an internal error. Neither the project nor the query can be selected.
May I ask you to help me in this issue?
Thanks,
Hansruedi
One answer
Comments
Hello Vladimir, do you have implemented a workaround? if yes how? Thanks for some more details, Hansruedi
I was lucky to find one dataset which contained all needed data for cascaded parameters)
Hello Vladimir, what I do not understand is why my cascaded report is successfully running on our RTC Training system and on the RTC Production system not. Any idea why?
Does you training environment based on 3.0.1.4 too? Only idea that comes to mind is difference in data. Sometimes I get intenal error when there are too much values in parameter tree. Are project areas and queries identical on both environments?
The Training and Production environment are both on 3.0.1.4. Project areas and queries are not identical. On the Production server the number of projects and queries is much greater.
Then the number of returned rows is likely cause. Only way to verify is to re-create project areas and queries (just save them without setting all conditions) in training environment manually and reproduce the issue. Also you can clone production DB, but in this case you have to isolate training environment from production one (to work with same Public URL).