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.
Error displaying report AS XLS
-
- Posts: 2425
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Error displaying report AS XLS
It is just a hunch but....
Are you running Aware from the Control Panel or as a Service?
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Error displaying report AS XLS
Hi eagles9999
I am running it from the control panel. Might that be the reason?
Thanks!
I am running it from the control panel. Might that be the reason?
Thanks!
-
- Posts: 2425
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Error displaying report AS XLS
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.
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Error displaying report AS XLS
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.
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.
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Error displaying report AS XLS
Hi support.
No I am running on Windows server with MS Office 2016 installed.
No I am running on Windows server with MS Office 2016 installed.
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Error displaying report AS XLS
Unfortunately, this is still happening.
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Error displaying report AS XLS
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
-
- Posts: 2425
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Error displaying report AS XLS
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
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Error displaying report AS XLS
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
Re: Error displaying report AS XLS
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
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
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Error displaying report AS XLS
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.
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