Page 1 of 1

Jasperreport plugin 6.4.1 error poi

PostPosted: Sat Sep 30, 2017 1:52 pm
by lwjwillemsen
Servoy 7.4.10 Smart client when exporting to xls:

Jaspersoft Community issue #9386 ?

SEVERE: Throwable
java.rmi.ServerError: Error occurred in server thread; nested exception is:
java.lang.NoSuchMethodError: org.apache.poi.hssf.util.HSSFColor.getTripletHash()Ljava/util/Map;
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at com.servoy.plugins.jasperreports.JasperReportsServer_Stub.getJasperBytes(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Solution?

Re: Jasperreport plugin 4.6.1 error poi

PostPosted: Mon Oct 02, 2017 9:22 am
by Gabi Boros
latest Servoy JasperReports Plugin 6.4.1 (that uses JasperReports 6.4.1) has a newer poi (3.15), can't you switch to that?

Re: Jasperreport plugin 6.4.1 error poi

PostPosted: Mon Oct 02, 2017 11:46 am
by lwjwillemsen
I am using the poi-3.15.jar as provided in the jasperreport plugin 6.4.1.

I read in the jaspersoft community that the upgrade to poi 3.15 causes the problem, but I can be wrong about that...

Re: Jasperreport plugin 6.4.1 error poi

PostPosted: Mon Oct 02, 2017 4:06 pm
by lwjwillemsen
Can the Servoy jakarta-poi/jakarta-poi.jar have any (bad) influence on the jasper report plugin client- / server-side ?

Re: Jasperreport plugin 6.4.1 error poi

PostPosted: Mon Oct 02, 2017 4:49 pm
by Gabi Boros
yes, that could be, it is an older version of poi, used by the excel plugin, that's maybe loaded first, causing jasper to not have the right poi classes;
there is a case for this already https://support.servoy.com/browse/SVY-11657