Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » DataException: The new column name or alias...
DataException: The new column name or alias... [message #646002] Tue, 21 December 2010 14:35 Go to next message
Helmut is currently offline HelmutFriend
Messages: 2
Registered: December 2010
Junior Member
Hi all,

what does this error message means?

"The new column name or alias abc is already used by the column at index x"

I get this message several times when I run my report against another database, not the one used to create the report. The tables are identical but the column order is different.

I'm using Birt 2.5.2.

Please help

Regards
Helmut

[Updated on: Tue, 21 December 2010 14:57]

Report message to a moderator

Re: The new column name or alias... [message #646021 is a reply to message #646002] Tue, 21 December 2010 15:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Does the dataset have an alias on the columns?

Jason

On 12/21/2010 9:35 AM, swaczinna@wlp-systems.de wrote:
> Hi all,
>
> what does this error messager maens?
>
> "The new column name or alias abc is already used by the column at index x"
>
> I get this message several times when I run my report against another
> database, not the one used to create the report. The tables are
> identical but the column order is different.
>
> I'm using Birt 2.5.2.
>
> Please help
>
> Regards
> Helmut
Re: The new column name or alias... [message #646039 is a reply to message #646021] Tue, 21 December 2010 17:06 Go to previous messageGo to next message
Helmut is currently offline HelmutFriend
Messages: 2
Registered: December 2010
Junior Member
Hi Jason!

No, the query ist really simple:

select *
from hsverf_dreh
where hsv_f_pan = ?
and hsv_geloescht = 0
order by hsv_sort

In the meantime I found a workaround. I listed all columns in the select clause instead of using *. Now the column order is always the same. But using * is more convenient. I would think of a bug in BIRT 2.5.2.

Regards
Helmut
Re: The new column name or alias... [message #646052 is a reply to message #646039] Tue, 21 December 2010 18:07 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

This sounds like a bug. Can you log it?

Jason

On 12/21/2010 12:06 PM, swaczinna@wlp-systems.de wrote:
> Hi Jason!
>
> No, the query ist really simple:
>
> select *
> from hsverf_dreh
> where hsv_f_pan = ?
> and hsv_geloescht = 0
> order by hsv_sort
>
> In the meantime I found a workaround. I listed all columns in the select
> clause instead of using *. Now the column order is always the same. But
> using * is more convenient. I would think of a bug in BIRT 2.5.2.
>
> Regards
> Helmut
Previous Topic:Hidden Report Paremeter
Next Topic:Checking repeated group header - BIRT 2.5.1
Goto Forum:
  


Current Time: Wed Nov 26 00:44:40 GMT 2014

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

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