Bug 149250 - get NullPointerException during generating csv file from rptdocument file
Summary: get NullPointerException during generating csv file from rptdocument file
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.1.0   Edit
Hardware: PC Windows XP
: P3 critical (vote)
Target Milestone: 2.1.1   Edit
Assignee: Liang Yu CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-29 17:32 EDT by chaohua wang CLA
Modified: 2006-09-29 22:23 EDT (History)
1 user (show)

See Also:


Attachments
rpt design file (54.07 KB, application/octet-stream)
2006-06-29 17:33 EDT, chaohua wang CLA
no flags Details
PDSStudioReportHeader.rptlibrary (10.72 KB, text/plain)
2006-06-30 11:29 EDT, chaohua wang CLA
no flags Details
Selection.rptlibrary (8.67 KB, text/plain)
2006-06-30 11:29 EDT, chaohua wang CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description chaohua wang CLA 2006-06-29 17:32:52 EDT
Hi, I developed a report server applcation using BIRT 2.1 RC5, 
I used to generate the csv format. 
First it generated the rptdocument file,  but when generating csv file from the rptdocument file, it thrown NullPointerException. 

But I tried to use  BIRT 2.1 RC4, there is no this issue. It generated the csv file.

please see the following exception. And I attached the rptdesign file and rptdocumet file. Thank you

Chaohua


2006-06-29 15:22:41,393 102245 INFO [STDOUT] (Thread-44:) Jun 29, 2006 3:22:41 PM com.premierdata.pdssudio.report.service.ReportEngineService getResultSets

SEVERE: java.lang.NullPointerException
java.lang.NullPointerException
        at org.eclipse.birt.report.engine.api.impl.DataExtractionTask.loadResultSetMetaData(DataExtractionTask.java:255)
        at org.eclipse.birt.report.engine.api.impl.DataExtractionTask.prepareMetaData(DataExtractionTask.java:177)
        at org.eclipse.birt.report.engine.api.impl.DataExtractionTask.getResultSetList(DataExtractionTask.java:376)
        at com.premierdata.pdssudio.report.service.ReportEngineService.getResultSets(ReportEngineService.java:734)
        at com.premierdata.pdssudio.report.service.ReportEngineService.generateCSV(ReportEngineService.java:648)
        at com.premierdata.pdssudio.report.service.CSVHandler.execute(CSVHandler.java:38)
        at com.premierdata.pdssudio.report.service.actionhandler.IActionHandler.run(IActionHandler.java:108)
2006-06-29 15:22:41,408 102260 INFO [STDOUT] (Thread-44:) Jun 29, 2006 3:22:41 PM com.premierdata.pdssudio.report.service.Re
CSV
SEVERE:  Failed to get result set
com.premierdata.pdssudio.report.exceptions.ReportEngineException
        at com.premierdata.pdssudio.report.service.ReportEngineService.getResultSets(ReportEngineService.java:790)
        at com.premierdata.pdssudio.report.service.ReportEngineService.generateCSV(ReportEngineService.java:648)
        at com.premierdata.pdssudio.report.service.CSVHandler.execute(CSVHandler.java:38)
        at com.premierdata.pdssudio.report.service.actionhandler.IActionHandler.run(IActionHandler.java:108)
Comment 1 chaohua wang CLA 2006-06-29 17:33:59 EDT
Created attachment 45561 [details]
rpt design file
Comment 2 Liang Yu CLA 2006-06-29 23:46:44 EDT
Hi, chaohua wang

Can you give me the "Selection.rptlibrary" and the "PDSStudioReportHeader.rptlibrary". Because the design file you attached is using these report libraries. The design file cann't work without them.

Otherwise you can try new version BIRT.

Thanks.
Comment 3 chaohua wang CLA 2006-06-30 11:29:08 EDT
Created attachment 45593 [details]
PDSStudioReportHeader.rptlibrary
Comment 4 chaohua wang CLA 2006-06-30 11:29:58 EDT
Created attachment 45594 [details]
Selection.rptlibrary
Comment 5 chaohua wang CLA 2006-06-30 11:35:46 EDT
(In reply to comment #2)
> Hi, chaohua wang
> Can you give me the "Selection.rptlibrary" and the
> "PDSStudioReportHeader.rptlibrary". Because the design file you attached is
> using these report libraries. The design file cann't work without them.
> Otherwise you can try new version BIRT.
> Thanks.

Hi, Liang Yu,

I also tried to use birt designer (2.1 RC5 ) to generate rtpdisgn file. still doesn't wrok. 

Thank you.

Chaohua 
Comment 6 Liang Yu CLA 2006-07-03 04:01:45 EDT
Hi, Chaohua,

We can not connect your private DataSource "jdbc:jtds:sqlserver://localhost/lf_co_blm". It's helpfule if you can give me the DataSource.

> Otherwise you can try new version BIRT.
I means you can use BIRT 2.1 Final or download current BIRT's codes to try it.

Thank you again for helping us to improve the BIRT.
Comment 7 Liang Yu CLA 2006-07-04 05:38:47 EDT
Hi, Chaohua,

I have made some sample design files and test them in birt designer ( both 2.1 RC5 and current version ). I can not reproduce the NullPointerException.
Can you give me your private jdbc DataSource? You can remove the sensitive data before give it to me. I will test it immediately when I get it.

Thanks.
Comment 8 chaohua wang CLA 2006-07-04 11:04:29 EDT
(In reply to comment #7)
> Hi, Chaohua,
> I have made some sample design files and test them in birt designer ( both 2.1
> RC5 and current version ). I can not reproduce the NullPointerException.
> Can you give me your private jdbc DataSource? You can remove the sensitive data
> before give it to me. I will test it immediately when I get it.
> Thanks.

Hi, Liang Yu,

Thank you very mcuh, I will ask DBA to give me permission. he is in vacation right now. Than kyou again.

Chaohua

Comment 9 chaohua wang CLA 2006-07-20 17:17:36 EDT
(In reply to comment #8)
> (In reply to comment #7)
> > Hi, Chaohua,
> > I have made some sample design files and test them in birt designer ( both 2.1
> > RC5 and current version ). I can not reproduce the NullPointerException.
> > Can you give me your private jdbc DataSource? You can remove the sensitive data
> > before give it to me. I will test it immediately when I get it.
> > Thanks.
> Hi, Liang Yu,
> Thank you very mcuh, I will ask DBA to give me permission. he is in vacation
> right now. Than kyou again.
> Chaohua

it thas been fixed in 2.1 final. Thank you. 
Comment 10 Liang Yu CLA 2006-07-21 04:09:39 EDT
Resolved in 2.1Final as confirmed by finder.
Comment 11 Olivier Thomann CLA 2006-09-29 22:23:33 EDT
*** Bug 159243 has been marked as a duplicate of this bug. ***