Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Malformed input while loading data set cache
Malformed input while loading data set cache [message #731298] Fri, 30 September 2011 10:41 Go to next message
jens.weintraut is currently offline jens.weintraut
Messages: 4
Registered: September 2011
Junior Member
Hi,

I have a problem with my reports. I changed the structure of the tables this reports operate on, but the SELECT statements (and therefore the output columns) they work with are still the same. I just moved one column from one table to another. And I even don't know if this matters for this problem.

After that change the one and only cube in my reports can't be created anymore. While creating a hierarchy:XYZ.NewTabularHierarchy a UTFDataFormatException is thrown from IOUtil while reading the data set cache. I don't know why this happens and I don't have any further information. The invoked method generateCharArray seems to convert a byte[] to a char[] with UTF encoding.

Since the log tells me that this exception is thrown while reading the data set cache I assume that the cause is the database. But in one report I defined an additional data cube with its own data set. This one works. But it operates on the same data source and on one of the two tables the other data set retrieves. And DBVis, Netbeans and even psql don't have any problems displaying both tables.

I really don't know why this exception occurs or how to get a hint on what the cause is. It would be really great if someone had an idea and shared it. Thanks in advance!

Jens

Report message to a moderator

Re: Malformed input while loading data set cache [message #731391 is a reply to message #731298] Fri, 30 September 2011 15:48 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Can you post the report, and specify the column that changed tables? I
assume if you recreate the cube in the designer it works?

Jason

On 9/30/2011 10:41 AM, jens.weintraut wrote:
> Hi,
>
> I have a problem with my reports. I changed the structure of the tables
> this reports operate on, but the SELECT statements (and therefore the
> output columns) they work with are still the same. I just moved one
> column from one table to another. And I even don't know if this matters
> for this problem.
>
> After that change the one and only cube in my reports can't be created
> anymore. While creating a hierarchy:XYZ.NewTabularHierarchy a
> UTFDataFormatException is thrown from IOUtil while reading the data set
> cache. I don't know why this happens and I don't have any further
> information. The invoked method generateCharArray seems to convert a
> byte[] to a char[] with UTF encoding.
>
> Since the log tells me that this exception is thrown while reading the
> data set cache I assume that the cause is the database. But in one
> report I defined an additional data cube with its own data set. This one
> works. But it operates on the same data source and on one of the two
> tables the other data set retrieves. And DBVis, Netbeans and even psql
> don't have any problems displaying both tables.
>
> I really don't know why this exception occurs or how to get a hint on
> what the cause is. It would be really great if someone had an idea and
> shared it. Thanks in advance!
>
> Jens

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Malformed input while loading data set cache [message #731512 is a reply to message #731391] Sat, 01 October 2011 10:41 Go to previous messageGo to next message
jens.weintraut is currently offline jens.weintraut
Messages: 4
Registered: September 2011
Junior Member
Hi Jason,

I didn't think of recreating the cube. But I will give it a try. Unfortunately I can't test it for two weeks since I'm on holiday. I hope I don't have to recreate the crosstables if I delete and recreate the cube?!

The column that changed is 'flaeche'. There are two tables referenced, 'statistics_dimensions' and 'statistics_measures'. 'flaeche' was a column of 'statistics_measures' but had to move to 'statistics_dimensions'. Since it's the same column in the SELECT statement (SELECT * FROM statistics_dimensions, statistics_measures ...) I didn't think it would be a problem for the report.

Thanks!
Jens

Report message to a moderator

Re: Malformed input while loading data set cache [message #739457 is a reply to message #731512] Mon, 17 October 2011 09:55 Go to previous messageGo to next message
jens.weintraut is currently offline jens.weintraut
Messages: 4
Registered: September 2011
Junior Member
jens.weintraut wrote on Sat, 01 October 2011 10:41
I didn't think of recreating the cube. But I will give it a try.

That did not work.

But I found the problem and solved it: Whenever you change the structure of the database you should consider changing the position tags in the xml source of the report. The data set is defined in this xml source along with the position of a column in the result set and with the position of a column in the data set cache. So you have to change it twice in a report.

[Updated on: Mon, 17 October 2011 09:56]

Report message to a moderator

Re: Malformed input while loading data set cache [message #739490 is a reply to message #739457] Mon, 17 October 2011 10:28 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
It would be good if you could open a bugzilla entry for this so we can
look in to changing this behavior.

Jason

On 10/17/2011 9:56 AM, jens.weintraut wrote:
> jens.weintraut wrote on Sat, 01 October 2011 10:41
>> I didn't think of recreating the cube. But I will give it a try.
>
> That did not work.
>
> But I found the problem and solved it: Whenever you change the structure
> of the database you should consider changing the position tags in the
> xml source of the report. The data set is defined in this xml source
> along with the position of a column in the result set and with the
> position of a column in the data set cache. So you have to change it
> twice in a report.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Malformed input while loading data set cache [message #740208 is a reply to message #739490] Tue, 18 October 2011 05:04 Go to previous messageGo to next message
jens.weintraut is currently offline jens.weintraut
Messages: 4
Registered: September 2011
Junior Member
Done Smile
I would post the link, but I'm not allowed to post it since I didn't reach the 5-post-limit. Here is the ID: 361224.

Report message to a moderator

Re: Malformed input while loading data set cache [message #740480 is a reply to message #740208] Tue, 18 October 2011 11:01 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Thanks for posting the number.

Jason

On 10/18/2011 5:04 AM, jens.weintraut wrote:
> Done :)
> I would post the link, but I'm not allowed to post it since I didn't
> reach the 5-post-limit. Here is the ID: 361224.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:Calling back into the application from a report in RCP
Next Topic:Chart interactivity invoke scripts: how to dynamically generate a script
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 16:52:10 EDT 2013

Powered by FUDForum. Page generated in 0.07808 seconds