Error displaying report AS XLS

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

It is just a hunch but....

Are you running Aware from the Control Panel or as a Service?

karelh

Hi eagles9999

I am running it from the control panel. Might that be the reason?
Thanks!

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.

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

Are you running on Linux?

karelh

Hi support.

No I am running on Windows server with MS Office 2016 installed.

aware_support

Please re-test this in the new build 2615

karelh

Unfortunately, this is still happening.

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?

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

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?

karelh

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

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.