Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » erroneous repeating row values in SQL Results view
erroneous repeating row values in SQL Results view [message #56748] Tue, 02 June 2009 12:48 Go to next message
No real name is currently offline No real name
Messages: 121
Registered: July 2009
Senior Member
Hi,
When I perform a join on two tables (each table has ~3400 rows), a
number of rows are copiously repeated towards the end of the displayed
result set. For example, there will be 12 "John Smith" rows followed by
7 "John Doe" rows. I know that these rows really do not occur in
duplicate in the tables, I suspect something is wrong in the result set
processing.

The join statement is nothing crazy:
select app.id.cn,app.hr.hrnum from app.id join app.hr on app.id.empnum =
app.hr.hrnum

In the Data Management Preferences, I have set max row count and max
display row count both to 4000. It is as if the result view fills up the
empty rows at the end with duplicates from the result set. That is,
fills up all 4000 rows even though result set was some 3000 rows.

I am using a ganymede birt build from eclipse.org with these versions:
BIRT 2.3.2
DTP 1.6.2
Eclipse 3.4.2
EMF 2.4.2

Has anyone else also seen this behavior?

Thanks, chris
Re: erroneous repeating row values in SQL Results view [message #56829 is a reply to message #56748] Tue, 02 June 2009 17:47 Go to previous messageGo to next message
Eclipse User
Originally posted by: brianf.sybase.com

Hi Chris...

The people who would typically respond to your question are on holiday at
the moment. Please be patient and I'm sure they'll respond when they get
back next week.

--Fitz

"Chris Giblin" <cgi@zurich.ibm.com> wrote in message
news:h0372v$96d$1@build.eclipse.org...
> Hi,
> When I perform a join on two tables (each table has ~3400 rows), a number
> of rows are copiously repeated towards the end of the displayed result
> set. For example, there will be 12 "John Smith" rows followed by 7 "John
> Doe" rows. I know that these rows really do not occur in duplicate in the
> tables, I suspect something is wrong in the result set processing.
>
> The join statement is nothing crazy:
> select app.id.cn,app.hr.hrnum from app.id join app.hr on app.id.empnum =
> app.hr.hrnum
>
> In the Data Management Preferences, I have set max row count and max
> display row count both to 4000. It is as if the result view fills up the
> empty rows at the end with duplicates from the result set. That is, fills
> up all 4000 rows even though result set was some 3000 rows.
>
> I am using a ganymede birt build from eclipse.org with these versions:
> BIRT 2.3.2
> DTP 1.6.2
> Eclipse 3.4.2
> EMF 2.4.2
>
> Has anyone else also seen this behavior?
>
> Thanks, chris
Re: erroneous repeating row values in SQL Results view [message #499647 is a reply to message #56748] Mon, 23 November 2009 15:38 Go to previous message
Dominik is currently offline Dominik
Messages: 4
Registered: November 2009
Junior Member
Hi Chris,

could you solve the problem in the mean time?
We are struggling right now with a problem that might be related to yours: Our Birt reports are filled up with duplicate rows when produced with the Birt web viewer. The local previews in Eclipse are fine.

Does anyone have an idea what might be the reason for this behavior?

Thanks,
Dominik
Re: erroneous repeating row values in SQL Results view [message #595914 is a reply to message #56748] Tue, 02 June 2009 17:47 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Hi Chris...

The people who would typically respond to your question are on holiday at
the moment. Please be patient and I'm sure they'll respond when they get
back next week.

--Fitz

"Chris Giblin" <cgi@zurich.ibm.com> wrote in message
news:h0372v$96d$1@build.eclipse.org...
> Hi,
> When I perform a join on two tables (each table has ~3400 rows), a number
> of rows are copiously repeated towards the end of the displayed result
> set. For example, there will be 12 "John Smith" rows followed by 7 "John
> Doe" rows. I know that these rows really do not occur in duplicate in the
> tables, I suspect something is wrong in the result set processing.
>
> The join statement is nothing crazy:
> select app.id.cn,app.hr.hrnum from app.id join app.hr on app.id.empnum =
> app.hr.hrnum
>
> In the Data Management Preferences, I have set max row count and max
> display row count both to 4000. It is as if the result view fills up the
> empty rows at the end with duplicates from the result set. That is, fills
> up all 4000 rows even though result set was some 3000 rows.
>
> I am using a ganymede birt build from eclipse.org with these versions:
> BIRT 2.3.2
> DTP 1.6.2
> Eclipse 3.4.2
> EMF 2.4.2
>
> Has anyone else also seen this behavior?
>
> Thanks, chris
Re: erroneous repeating row values in SQL Results view [message #596839 is a reply to message #56748] Mon, 23 November 2009 15:38 Go to previous message
Dominik is currently offline Dominik
Messages: 4
Registered: November 2009
Junior Member
Hi Chris,

could you solve the problem in the mean time?
We are struggling right now with a problem that might be related to yours: Our Birt reports are filled up with duplicate rows when produced with the Birt web viewer. The local previews in Eclipse are fine.

Does anyone have an idea what might be the reason for this behavior?

Thanks,
Dominik
Previous Topic:Is there an ODA datasource visualizer available?
Next Topic:Data Soruce Explorer, No tables, only Schemas visible
Goto Forum:
  


Current Time: Thu Oct 02 12:38:49 GMT 2014

Powered by FUDForum. Page generated in 0.01733 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software