Bugzilla – Full Text Bug Listing
| Summary: | JoinDataSet unable to read output column for joined parameterized DataSet | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Nattapong Sirilappanich <natta> | ||||||||
| Component: | BIRT | Assignee: | Lin Zhu <lzhu> | ||||||||
| Status: | VERIFIED FIXED | QA Contact: | |||||||||
| Severity: | major | ||||||||||
| Priority: | P3 | CC: | bluesoldier, joel, kroll, lchen, lzhu, suwits, zqian | ||||||||
| Version: | 2.3.1 | ||||||||||
| Target Milestone: | 2.3.2 | ||||||||||
| Hardware: | PC | ||||||||||
| OS: | Windows XP | ||||||||||
| Whiteboard: | Obsolete | ||||||||||
| Attachments: |
|
||||||||||
Hi There, Can you have a try of latest BIRT? There are some problem exists in your attached report design. I've made the correction and the report can be now previewed w/o problem. Please see my attachment. Thanks. Lin Created attachment 115536 [details]
Corrected Report Design
(In reply to comment #2) > Created an attachment (id=115536) [details] > Corrected Report Design Hi. The corrected rptdesign is working. About the latest BIRT, do you mean the latest build ? If that's the case, it may takes me a while because my working site has limited bandwidth for downloading. Thanks & Regards Hi There, As far as the correct rptdesign is working, that would be fine. What I curious about is that how the original report design (which is incorrect) is created. Can you stably re-create such a report design? If that is the case we may need further investigation. Thanks. Lin (In reply to comment #4) > Hi There, > As far as the correct rptdesign is working, that would be fine. > What I curious about is that how the original report design (which is > incorrect) is created. Can you stably re-create such a report design? If that > is the case we may need further investigation. > Thanks. > Lin I'll try my best to describe the step i created this rptdesign. 1. File->New->Report->Finish 2. Right click on Data Sources->New Data source->Next->Finish 3. Right click on Report Parameters->New Parameter->Enter name as "maxCredit"->Select data type as "Float"->OK 4. Repeat step 3 with different name and data type as "status" and "String" 5. Right click on Data Sets->New Data set->Next 6. Paste this SQL "select * from CLASSICMODELS.CUSTOMERS where CLASSICMODELS.CUSTOMERS.CREDITLIMIT <= ?" without double quote. 7. Click Finish->Click Parameters->Click param_1->Edit->Change "Linked to report parameter" to "maxCredit"->OK 8. Repeat step 5. 9. Paste this SQL "select * from CLASSICMODELS.ORDERS where CLASSICMODELS.ORDERS.STATUS = ?" without double quote. 10. Click Finish->Click Paramter->Click param_1->Edit->Change "Linked to report parameter" to "status"->OK 11. Right click on Data Sets->New Joint Data set 12. Left topmost combo box choose "Data Set" 13. Right topmost combo box choose "Data Set1" 14. Left list box choose "customerNumber" 15. Right list box choose "customerNumber" 16. Finish->OK After Click "OK" on step 16, the problem can be observed. Hi There, I cannot reproduce problem with BUILD 20081006 so later. I've also tried to use BUILD 20080916 but the problem still does not appear. Can you try a download from eclipse website for latest build to see if that still happens in your environment? Thanks. Lin (In reply to comment #6) > Hi There, > I cannot reproduce problem with BUILD 20081006 so later. I've also tried to use > BUILD 20080916 but the problem still does not appear. > Can you try a download from eclipse website for latest build to see if that > still happens in your environment? > Thanks. > Lin Hi. I'll try to download it from IES website but it usually takes me whole day to complete so i will let you know when it's finished. I don't know what build i'm using but in Help->Software Updates shows almost every BIRT plug-in is 2.3.1.v20080630 (except oda jdbc profile ...) so i assumes it's build 20080630. If you have sometime, please try on this build. Thanks & Regards. Tested on BIRT SDK-2_3_2 build N20081010 No sign of this problem. Seem like the last distro packed in www.eclipse.org/downloads and package IES 3.4.1 can reproduce this bug. Test environment is Vista 64 bits SP1 Thai. As in latest birt build the problem cannot be reproduced, mark the bug as fixed. Verified in build 2.3.2.v20081117 Created attachment 125698 [details]
design with two datasets and a join dataset
I'm having the same problem with 2.3.2RC2 - I've attached the design. To reproduce I created the two datasets and joined them. The resulting
<structure name="cachedMetaData"/>
tag is empty.
correction - this problem does seem fixed, after re-installing everything it seems fine. except that when I create a chart against the resulting dataset, eclipse crashes :-( I'm having a similar problem in BIRT 2.5.0 (BIRT Framework 2.5.0.v20090603-9ODS6GD6DotWJgPXFaYge), and I see the same empty cachedMetaData tag that Joel reported above. I have not yet been able to reproduce it using the sample data source, but the problem is occurring in my production report. My report contains two data sets from different JDBC data sources, one of which contains a report parameter. The joint data set shows no output columns. If I unlink the parameter in the first data set from the report parameter then the joint data set works OK and shows columns. |
Created attachment 115337 [details] The sample Join Data Set which is unusable because no column available Build ID: M20080911-1700 Steps To Reproduce: 1.Create Empty Report 2.Create Sample Data Source 3.Create 2 Data Sets and each Data Set have at least one parameter 4.Create Join Data Set on 2 Data Set created on step 3. More information: The Join Data Set on Step 4 will unusable because it's unable to determine an output column.