Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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 messageGo to next 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
Re: The new column name or alias... [message #1800546 is a reply to message #646052] Wed, 02 January 2019 07:09 Go to previous message
Thushara Buddhika is currently offline Thushara BuddhikaFriend
Messages: 1
Registered: January 2019
Junior Member
Found walk around.
Copy and Paste the same Date Source.
Then Double click the Data Set.
Go to Date Source Tab.
Change it to New Date Source.
Save.
Again Double click the Data Set.
Go to Date Source Tab.
Change it to Old Date Source.
Save.
Report worked for me.
Previous Topic:Report Generation not working when creating a WAR
Next Topic:Calculate Cumulative value in cross tab
Goto Forum:
  


Current Time: Thu Apr 25 00:52:48 GMT 2024

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

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

Back to the top