Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 322334

Summary: Designer-Crash with SQLite DB after migrating from 2.3 to 2.6.0
Product: z_Archived Reporter: tec_1 <ak>
Component: BIRTAssignee: Birt-Data-inbox <Birt-Data-inbox>
Status: CLOSED FIXED QA Contact: Xiaoying Gu <bluesoldier>
Severity: critical    
Priority: P3 CC: bluesoldier, zqian
Version: 2.6.0   
Target Milestone: 2.6.1   
Hardware: PC   
OS: Windows All   
Whiteboard: Obsolete
Attachments:
Description Flags
Crash-Logfile, sample report, database file
none
Crash-Logfile, sample report, database file none

Description tec_1 CLA 2010-08-11 06:25:28 EDT
Hello,

I'am working with BIRT 2.3 (all in one) and a sqlite data base. Everything works fine.
After starting BIRT 2.6.0 (all in one) and opening the report the Birt designer crash after some changes on the report. If I restart BIRT 2.6 Designer, it crash's after one click on the report. Same crashes on BIRT 2.5.2.

I have attached a logfile from eclipse, a sample report design file, a sample database and the jdbc driver.
Comment 1 tec_1 CLA 2010-08-11 06:28:06 EDT
Created attachment 176321 [details]
Crash-Logfile, sample report, database file

Crash-Logfile, sample report, database file
Comment 2 tec_1 CLA 2010-08-11 06:29:55 EDT
download location of sqlite jdbc driver: http://files.zentus.com/sqlitejdbc/sqlitejdbc-v056.jar
Comment 3 tec_1 CLA 2010-08-11 06:32:38 EDT
Crashes occurs after editing of data source in sample design file. If you added the correct path to sample db file and opens some working datasets a crash should occur.
Comment 4 tec_1 CLA 2010-08-11 06:57:28 EDT
Created attachment 176323 [details]
Crash-Logfile, sample report, database file
Comment 5 tec_1 CLA 2010-08-11 06:58:34 EDT
Comment on attachment 176321 [details]
Crash-Logfile, sample report, database file

file are corrupt
Comment 6 Xiaoying Gu CLA 2010-08-12 04:06:05 EDT
I can not reproduce this issue with 2.6.0 release.

I can preview the dataset using the attached db and report design.
Comment 7 tec_1 CLA 2010-08-12 04:32:17 EDT
Hello,

my sample report crashes after open the second dataset in "Data Explorer" view. The first data set named "Mandant_und_Stichtag" opens correctly. If I try to open data set "WP-Klasse" or change something on the charts it crashes. On Suse Linux I get no crashes.
Comment 8 Xiaoying Gu CLA 2010-08-12 05:56:27 EDT
(In reply to comment #7)
> Hello,
> my sample report crashes after open the second dataset in "Data Explorer" view.
> The first data set named "Mandant_und_Stichtag" opens correctly. If I try to
> open data set "WP-Klasse" or change something on the charts it crashes. On Suse
> Linux I get no crashes.

Do you have the crash on windows after restart the eclipse?
I do met the crash in 2.6.0 release on windows, but only for the first time. After restart eclipse, the crash can not be reproduce.
Comment 9 tec_1 CLA 2010-08-12 06:01:59 EDT
Yes, it crashes after restart. I have reproduced this on Windows XP and Windows Vista.
Comment 10 Xiaoying Gu CLA 2010-08-12 06:14:59 EDT
(In reply to comment #9)
> Yes, it crashes after restart. I have reproduced this on Windows XP and Windows
> Vista.

It's strange that I can not stably reproduce the crash in my env (windows xp).
I tried the latest 2.6.1 build and I don't met the crash.
Do you have any chance to try the latest 2.6.1 build to see if it has been fixed?
Comment 11 tec_1 CLA 2010-08-12 06:51:23 EDT
Yes, I would test BIRT 2.6.1. Where can I download BIRT 2.6.1?
Comment 12 Xiaoying Gu CLA 2010-08-12 23:48:56 EDT
BIRT 2.6.1 nightly build can be found on:
http://download.eclipse.org/birt/downloads/build_list.php
Comment 13 tec_1 CLA 2010-08-13 09:37:38 EDT
In Birt 2.6.1 nightly build I cant reproduce this crash. It seems to be fixed :-)
Comment 14 Xiaoying Gu CLA 2010-08-15 22:32:28 EDT
The issue fixed in 2.6.1.
Comment 15 Xiaoying Gu CLA 2010-09-08 23:33:18 EDT
Close the bug based on comment 13