Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Exception in a Lib with a Table using group & aggregation
Exception in a Lib with a Table using group & aggregation [message #640599] Mon, 22 November 2010 15:23 Go to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
Hello,

On a report I made table with a group (bases on a data set computed column). In group Header of my table i make an aggregation Sum on a colomn of my data Set.

Birt 2.6 (Actuate 11)

when I put this on a libarie it does not work anymore. I have an exception saying the group I defined does not exist. I do not understand because it works when it's in the report and not in a library.

ERROR :
Group "groupSreadCommRate" used in column Aggr-Sum-SpreadCommRate-Notional does not exist.



Re: Exception in a Lib with a Table using group & aggregation [message #640679 is a reply to message #640599] Mon, 22 November 2010 18:57 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Is the dataset in a library?

On 11/22/2010 10:23 AM, Anthony S wrote:
> Hello,
>
> On a report I made table with a group (bases on a data set computed
> column). In group Header of my table i make an aggregation Sum on a
> colomn of my data Set.
> Birt 2.6 (Actuate 11)
>
> when I put this on a libarie it does not work anymore. I have an
> exception saying the group I defined does not exist. I do not understand
> because it works when it's in the report and not in a library.
>
> ERROR : Group "groupSreadCommRate" used in column
> Aggr-Sum-SpreadCommRate-Notional does not exist.
>
>
>
>
Re: Exception in a Lib with a Table using group & aggregation [message #640861 is a reply to message #640679] Tue, 23 November 2010 11:20 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
Yes, Data set is in a library (used several times in my report)
which is used and referenced by my library containing my grid & my table. This library is set in my report.


ReportDesign ----> Grid-TableLibrary ---> DataSetLibrary
Re: Exception in a Lib with a Table using group & aggregation [message #640966 is a reply to message #640599] Tue, 23 November 2010 17:26 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
I made some tests


My library containing my Table using a group with an aggregation is in a Grid :
Library : Grid
Row ---- col ---- Table
Row ---- col ---- (empty : will be filled later)

In this configuration I have an error that group in my Table does not exists.

I tried this : Library : Table (no grid, nothin else)

and it works.

It seems the problem is linked to the fact my Table is embedded in a Grid. Have you ever seen this problem ?

Is there another solution than do not use the Grid and only put directly the Table ?

Re: Exception in a Lib with a Table using group & aggregation [message #640978 is a reply to message #640966] Tue, 23 November 2010 17:55 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you email me the library and the report design? Or preferably build
a library and report off the sample db that shows the problem and post them?

Jason

On 11/23/2010 12:26 PM, Anthony S wrote:
> I made some tests
>
>
> My library containing my Table using a group with an aggregation is in a
> Grid : Library : Grid Row ---- col ---- Table
> Row ---- col ---- (empty : will be filled later)
>
> In this configuration I have an error that group in my Table does not
> exists.
>
> I tried this : Library : Table (no grid, nothin else)
>
> and it works.
>
> It seems the problem is linked to the fact my Table is embedded in a
> Grid. Have you ever seen this problem ?
> Is there another solution than do not use the Grid and only put directly
> the Table ?
>
>
Re: Exception in a Lib with a Table using group & aggregation [message #641004 is a reply to message #640599] Tue, 23 November 2010 20:17 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
For privacy reasons I cannot send my work directly. I have an idea. I can try we the sample database and check if there is the same pb and send you that.
Re: Exception in a Lib with a Table using group & aggregation [message #641121 is a reply to message #641004] Wed, 24 November 2010 10:28 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
I made a report sample using the Birt sample database.

I have also the problem if there is a grid in which I put a table with a group and an aggregation.

In my I made a report design with a simple Grid and two libraries. First library is a Grid containing my table and reproducing the problem. second library is just the table without changing anything : it works.

I do not understand why there is this trouble.
Re: Exception in a Lib with a Table using group & aggregation [message #641122 is a reply to message #641121] Wed, 24 November 2010 10:31 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
Jason, how can I send you by mail, there is no MP button on you profile ? It seemed I cannot (authorization) send mail or MP for this forum.

[Updated on: Wed, 24 November 2010 10:37]

Report message to a moderator

Re: Exception in a Lib with a Table using group & aggregation [message #641215 is a reply to message #641122] Wed, 24 November 2010 14:58 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you email it to jasonweathersby at windstream dot net?

On 11/24/2010 5:31 AM, Anthony S wrote:
> Jason Weathersby How can I send you by mail, there is no MP button on
> you profile ?
Re: Exception in a Lib with a Table using group & aggregation [message #641680 is a reply to message #641215] Fri, 26 November 2010 16:50 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
No solution or explanation for the moment. Is it a bug ?
Re: Exception in a Lib with a Table using group & aggregation [message #641878 is a reply to message #641680] Mon, 29 November 2010 04:31 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I just sent you an email.

Jason

On 11/26/2010 11:50 AM, Anthony S wrote:
> No solution or explanation for the moment. Is it a bug ?
Re: Exception in a Lib with a Table using group & aggregation [message #641933 is a reply to message #641878] Mon, 29 November 2010 10:05 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
Which mail ?
Can you send it again to :
- anthony DOT serfati-ext AT sgcib DOT com
- neozerabbit AT hotmail DOT com

Re: Exception in a Lib with a Table using group & aggregation [message #642027 is a reply to message #641933] Mon, 29 November 2010 15:29 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I sent it to
anthonyserfati at hotmail dot com
I Tried the jar you sent me ( two report libraries and a report) and ran
it in 2.6.1 and it ran for me. Are you using 2.6.1 or 2.6.0?

Jason

On 11/29/2010 5:05 AM, Anthony S wrote:
> Which mail ?
> Can you send it again to :
> - anthony DOT serfati-ext AT sgcib DOT com
> - neozerabbit AT hotmail DOT com
>
>
Re: Exception in a Lib with a Table using group & aggregation [message #642108 is a reply to message #642027] Mon, 29 November 2010 21:12 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
2.6.0 & 2.6.1

I finaly received it in the afternoon (France).
I do not undersand why you don't have the trouble it is very strange. We have constated it with Birt/Actuate Team.

The following versions are

OPEN SOURCE :
BIRT Chart Framework
Version: 2.6.0.v20100617-7f9T0FQCnv7wz02TTZ0LE1
Build id: v20100609-1613

EMF Mapping
Version: 2.6.0.v20100614-1136
Build id: R201006141136

Eclipse Plug-in Development Environment
Version: 3.6.0.v20100525-7b7mFKtFEx2XmfZ4_B7NUJA
Build id: I20100608-0911


ACTUATE TRIAL VERSION
-------------------------------------
Actuate Open Data Access (ODA) and Adapter
Version : 11.0.0

EMF Mapping
Version: 2.6.0.v20100914-1218
Build id: R201009141218

Eclipse Platform
Version: 3.6.1.r361_v20100909-9gF78GrkFqw7GrsZnvz0JWNTeb6fue6896L
Build id: M20100909-0800

[Updated on: Tue, 30 November 2010 09:07]

Report message to a moderator

Re: Exception in a Lib with a Table using group & aggregation [message #642257 is a reply to message #642108] Tue, 30 November 2010 15:49 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I used 2.6.1 and did not see the issue. Do you have a support case open
with Actuate?

Jason

On 11/29/2010 4:12 PM, Anthony S wrote:
> I finaly received it in the afternoon (France). I do not undersand why
> you don't have the trouble it is very strange. We have constated it with
> Birt/Actuate Team.
>
> The following version are
> OPEN SOURCE : BIRT Chart Framework
> Version: 2.6.0.v20100617-7f9T0FQCnv7wz02TTZ0LE1
> Build id: v20100609-1613
>
> Eclipse Plug-in Development Environment
> Version: 3.6.0.v20100525-7b7mFKtFEx2XmfZ4_B7NUJA
> Build id: I20100608-0911
>
>
> ACTUATE TRIAL VERSION Actuate Open Data Access (ODA) and Adapter Version
> : 11.0.0
>
> Eclipse Platform
> Version: 3.6.1.r361_v20100909-9gF78GrkFqw7GrsZnvz0JWNTeb6fue6896L
> Build id: M20100909-0800
>
>
>
Re: Exception in a Lib with a Table using group & aggregation [message #642289 is a reply to message #642257] Tue, 30 November 2010 17:11 Go to previous messageGo to next message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
No support cas opened for the moment bu some internal discussion bt mail.

We are developping a reporting prototype with Actuate people.

I made the test with Birt 2.5 : it works.

So what next ? It seems this issue is not for all 2.6.0 and 2.6.1.

[Updated on: Tue, 30 November 2010 17:13]

Report message to a moderator

Re: Exception in a Lib with a Table using group & aggregation [message #642306 is a reply to message #642289] Tue, 30 November 2010 17:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

It would be good if you could get a support case opened for it.

Jason

On 11/30/2010 12:11 PM, Anthony S wrote:
> No support cas opened for the moment bu some internal discussion bt mail.
>
> I made the test with Birt 2.5 : it works.
>
> So what next ? It seems this issue is not for all 2.6.0 and 2.6.1.
Re: Exception in a Lib with a Table using group & aggregation [message #642342 is a reply to message #642306] Tue, 30 November 2010 20:58 Go to previous message
Anthony S is currently offline Anthony SFriend
Messages: 19
Registered: September 2010
Junior Member
ok. I need to make someone in Actuate or Birt Resource in order to make it took in count.

Previous Topic:Is it possible to change BIRT_HOME in birt viewer
Next Topic:Birt Deployment error - is it a bug?
Goto Forum:
  


Current Time: Sun Nov 23 14:41:18 GMT 2014

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

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