Error displaying report AS XLS

If you think that something doesn't work in Aware IM post your message here
Post Reply
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Error displaying report AS XLS

Post by karelh »

When trying to export a report 'AS XLS' I get the following error:

Error filling report ../DocTemplates/BASTestDomainSrk_1.1435/DocTemplates/161/161/08611727456679249_RDDoc2313354691429993439.rdd java.lang.NoClassDefFoundError org/apache/poi/ss/usermodel/RichTextString

I did some research and it seemed to be linked to a missing or old jasper .jar file.
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Error displaying report AS XLS

Post by customaware »

It is just a hunch but....

Are you running Aware from the Control Panel or as a Service?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Re: Error displaying report AS XLS

Post by karelh »

Hi eagles9999

I am running it from the control panel. Might that be the reason?
Thanks!
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Error displaying report AS XLS

Post by customaware »

The issue that came to mind was UUD output to xls and thought it might be related.

In current versions the is an issue when trying to do it when running Aware as a service. Under the Control Panel it is fine.
It is no an Aware issue... more to do with the wrapper and the current versions of Excel.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Re: Error displaying report AS XLS

Post by karelh »

HI Mark,

Thank you for the information. I am running Office 2016 on the server and my development machine. Do you know what versions of Excel/Office it works on?

Thanks again.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Error displaying report AS XLS

Post by aware_support »

Are you running on Linux?
Aware IM Support Team
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Re: Error displaying report AS XLS

Post by karelh »

Hi support.

No I am running on Windows server with MS Office 2016 installed.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Error displaying report AS XLS

Post by aware_support »

Please re-test this in the new build 2615
Aware IM Support Team
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Re: Error displaying report AS XLS

Post by karelh »

Unfortunately, this is still happening.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Error displaying report AS XLS

Post by aware_support »

Can you check what's in the Server Output when you get this error. There should be an exception there. Could you please attach the stack trace of this exception?
Aware IM Support Team
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Error displaying report AS XLS

Post by customaware »

The only way I was able to make it work was to run Aware from the Control Panel.
Does not work when running as a Service
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Error displaying report AS XLS

Post by aware_support »

I am confused. kareh is saying that it doesn't work in a Control Panel and you are saying it doesn't work as a service. So what is it? Can you attach the error stack trace?
Aware IM Support Team
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Re: Error displaying report AS XLS

Post by karelh »

Hi

I am running it from Control panel with the following error.

Message is Error filling report ../DocTemplates/K.....java.lang.NoClassDefFoundError org/apache/poi/ss/usermodel/RichTextString

I'm on build 2630
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Error displaying report AS XLS

Post by aware_support »

Looks like Aware IM no longer supports AS XLS export.

The problem is in the new version of the Jasper Reports library (6.1) that Aware IM uses. It requires a different version of Apache POI library than what Aware IM uses. The problem is that it is not clear which version of the POI library Jasper Reports needs. The documentation says that it needs version 2.0 or later. However, it doesn't work with the latest POI version 4.1 or the earliest downloadable version 3.0. If you can find POI version 2.0 then maybe it will work.
Aware IM Support Team
Post Reply