Eclipse Community Forums: BIRT » DataException: The new column name or alias...

Home » Archived » BIRT » DataException: The new column name or alias...

DataException: The new column name or alias... [message #646002]

Tue, 21 December 2010 09:35

Eclipse User

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 09:57] by Moderator

Re: The new column name or alias... [message #646021 is a reply to message #646002]

Tue, 21 December 2010 10:33

Eclipse User

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 12:06

Eclipse User

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 13:07

Eclipse User

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 02:09

Eclipse User

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:

-=] Back to Top [=-

Current Time: Tue Jul 22 23:49:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter