Eclipse Community Forums: BIRT » Malformed input while loading data set cache

Home » Archived » BIRT » Malformed input while loading data set cache

Malformed input while loading data set cache [message #731298]

Fri, 30 September 2011 10:41

Eclipse User

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

Re: Malformed input while loading data set cache [message #731391 is a reply to message #731298]

Fri, 30 September 2011 15:48

Eclipse User

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

Re: Malformed input while loading data set cache [message #731512 is a reply to message #731391]

Sat, 01 October 2011 10:41

Eclipse User

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

Attachment: 01_mv_allgemein.rptdesign
(Size: 265.13KB, Downloaded 286 times)

Re: Malformed input while loading data set cache [message #739457 is a reply to message #731512]

Mon, 17 October 2011 09:55

Eclipse User

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] by Moderator

Re: Malformed input while loading data set cache [message #739490 is a reply to message #739457]

Mon, 17 October 2011 10:28

Eclipse User

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.

Re: Malformed input while loading data set cache [message #740208 is a reply to message #739490]

Tue, 18 October 2011 05:04

Eclipse User

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.

Re: Malformed input while loading data set cache [message #740480 is a reply to message #740208]

Tue, 18 October 2011 11:01

Eclipse User

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.

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:

-=] Back to Top [=-

Current Time: Tue Jul 22 18:47:20 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter