Traccar 4.1 Export Excel report not working
Do you have Chinese characters anywhere in templates or device names/addresses?
yes I am using the default templates, and no i do not have any Chinese characters
Can you please try this version:
https://www.dropbox.com/s/xshgs7h932w88z3/traccar-windows-64-4.2-test.zip
Tryed it, but got error here also.
2018-10-25 19:08:59 ERROR: Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception -
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.jxls.util.TransformerFactory.createTransformer(TransformerFactory.java:35)
at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:381)
at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:173)
at org.traccar.reports.Summary.getExcel(Summary.java:114)
at org.traccar.api.resource.ReportResource.lambda$getSummaryExcel$3(ReportResource.java:159)
at org.traccar.api.resource.ReportResource.executeReport(ReportResource.java:90)
at org.traccar.api.resource.ReportResource.getSummaryExcel(ReportResource.java:158)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:200)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:493)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:415)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:104)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:277)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268)
at org.glassfish.jersey.internal.Errors.process(Errors.java:316)
at org.glassfish.jersey.internal.Errors.process(Errors.java:298)
at org.glassfish.jersey.internal.Errors.process(Errors.java:268)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:289)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:256)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:703)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:416)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:370)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:389)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:342)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:229)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:503)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
at java.base/java.lang.Thread.run(Thread.java:844)
Caused by: java.lang.ExceptionInInitializerError
at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:109)
at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:115)
at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:75)
at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:268)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:231)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:218)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:443)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:169)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:270)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:65)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:58)
... 65 more
Caused by: java.nio.charset.UnsupportedCharsetException: Big5
at java.base/java.nio.charset.Charset.forName(Charset.java:529)
at org.apache.poi.util.StringUtil.<clinit>(StringUtil.java:37)
... 79 more
2018-10-25 19:09:11 ERROR: Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception -
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.jxls.util.TransformerFactory.createTransformer(TransformerFactory.java:35)
at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:381)
at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:173)
at org.traccar.reports.Summary.getExcel(Summary.java:114)
at org.traccar.api.resource.ReportResource.lambda$getSummaryExcel$3(ReportResource.java:159)
at org.traccar.api.resource.ReportResource.lambda$executeReport$0(ReportResource.java:74)
at java.base/java.lang.Thread.run(Thread.java:844)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.util.StringUtil
at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:109)
at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:115)
at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:75)
at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:268)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:231)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:218)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:443)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:169)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:270)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:65)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:58)
... 11 more
2018-10-25 19:09:11 ERROR: Thread exception -
java.lang.IllegalStateException: Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:383)
at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:173)
at org.traccar.reports.Summary.getExcel(Summary.java:114)
at org.traccar.api.resource.ReportResource.lambda$getSummaryExcel$3(ReportResource.java:159)
at org.traccar.api.resource.ReportResource.lambda$executeReport$0(ReportResource.java:74)
at java.base/java.lang.Thread.run(Thread.java:844)
What operating system are you using?
Windows server 2012 R2
Please try this version:
https://www.dropbox.com/s/xshgs7h932w88z3/traccar-windows-64-4.2-test.zip
Not working....
Log:
2018-10-26 16:49:11 INFO: HikariPool-1 - Starting...
2018-10-26 16:49:12 INFO: HikariPool-1 - Start completed.
2018-10-26 16:49:13 INFO: Clearing database change log checksums
2018-10-26 16:49:13 INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2018-10-26 16:49:13 INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2018-10-26 16:49:13 INFO: SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
2018-10-26 16:49:13 INFO: Successfully acquired change log lock
2018-10-26 16:49:13 INFO: SELECT MD5SUM FROM public.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-26 16:49:14 INFO: UPDATE public.databasechangelog SET MD5SUM = NULL
2018-10-26 16:49:14 INFO: Successfully released change log lock
2018-10-26 16:49:14 INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2018-10-26 16:49:14 INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2018-10-26 16:49:14 INFO: SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
2018-10-26 16:49:14 INFO: Successfully acquired change log lock
2018-10-26 16:49:19 INFO: SELECT MD5SUM FROM public.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-26 16:49:19 INFO: SELECT COUNT(*) FROM public.databasechangelog
2018-10-26 16:49:19 INFO: Reading from public.databasechangelog
2018-10-26 16:49:19 INFO: SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-26 16:49:19 INFO: UPDATE public.databasechangelog SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
...
2018-10-26 16:49:20 INFO: UPDATE public.databasechangelog SET MD5SUM = '8:b148f52efe9c6a3e74a56e33e257a3e2' WHERE ID = 'changelog-4.1-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.1'
2018-10-26 16:49:20 INFO: SELECT COUNT(*) FROM public.databasechangelog
2018-10-26 16:49:20 INFO: Reading from public.databasechangelog
2018-10-26 16:49:20 INFO: SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-26 16:49:20 INFO: Successfully released change log lock
2018-10-26 16:49:20 INFO: Logging initialized @12246ms to org.eclipse.jetty.util.log.Slf4jLog
2018-10-26 16:49:23 INFO: Operating system name: Windows Server 2012 R2 version: 6.3 architecture: amd64
2018-10-26 16:49:23 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 10.0.2.1-ojdkbuild+13
2018-10-26 16:49:23 INFO: Memory limit heap: 1024mb non-heap: 0mb
2018-10-26 16:49:23 INFO: Character encoding: Cp1252 charset: windows-1252
2018-10-26 16:49:23 INFO: Version: 4.1-SNAPSHOT
2018-10-26 16:49:23 INFO: Starting server...
2018-10-26 16:49:23 INFO: jetty-9.4.12.v20180830; built: 2018-08-30T13:59:14.071Z; git: 27208684755d94a92186989f695db2d7b21ebc51; jvm 10.0.2.1-ojdkbuild+13
2018-10-26 16:49:24 INFO: Started o.t.w.@58fe5174{/,null,AVAILABLE}
2018-10-26 16:49:24 INFO: DefaultSessionIdManager workerName=node0
2018-10-26 16:49:24 INFO: No SessionScavenger set, using defaults
2018-10-26 16:49:24 INFO: node0 Scavenging every 660000ms
2018-10-26 16:49:25 INFO: [9504daaa] connected
2018-10-26 16:49:26 INFO: Started o.e.j.s.ServletContextHandler@52aeef5f{/,null,AVAILABLE}
2018-10-26 16:49:26 INFO: Started ServerConnector@2a0eee67{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2018-10-26 16:49:26 INFO: Started @18247ms
2018-10-26 16:49:29 INFO: [2ae8c7ab] connected
2018-10-26 16:49:29 INFO: [f28e0ff7] connected
2018-10-26 16:49:29 INFO: [9e393a42] connected
2018-10-26 16:49:31 INFO: user: 3, action: login
2018-10-26 16:49:35 INFO: [bb745cd5] connected
2018-10-26 16:49:41 INFO: [2ae8c7ab: 5013 < 2.1xx.102.xxx] HEX: 2a48512c363137303133363834342c56312c3134353130312c412c353835382e383035312c4e2c30303933322e333031342c452c3030302e31332c3030302c3236313031382c46464646394646462c3234322c30312c31323830312c343034343123
2018-10-26 16:49:41 INFO: [2ae8c7ab: 5013 > 2.1xx.102.xxx] HEX: 2a48512c363137303133363834342c56342c56312c323031383130323631353439343123
2018-10-26 16:49:42 INFO: [2ae8c7ab] id: 6xx0136xxx, time: 2018-10-26 15:51:01, lat: xx.98009, lon: x.53836, speed: 0.1, course: 0.0
2018-10-26 16:50:00 INFO: you may change the SPI on file: META-INF/services/org.jxls.util.ServiceFactory
2018-10-26 16:50:00 INFO: you may change the SPI on file: META-INF/services/org.jxls.util.JxlsConfigProvider
2018-10-26 16:50:01 ERROR: Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception -
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.jxls.util.TransformerFactory.createTransformer(TransformerFactory.java:35)
at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:381)
at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:173)
at org.traccar.reports.Summary.getExcel(Summary.java:114)
at org.traccar.api.resource.ReportResource.lambda$getSummaryExcel$3(ReportResource.java:159)
at org.traccar.api.resource.ReportResource.executeReport(ReportResource.java:90)
at org.traccar.api.resource.ReportResource.getSummaryExcel(ReportResource.java:158)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:200)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:493)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:415)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:104)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:277)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268)
at org.glassfish.jersey.internal.Errors.process(Errors.java:316)
at org.glassfish.jersey.internal.Errors.process(Errors.java:298)
at org.glassfish.jersey.internal.Errors.process(Errors.java:268)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:289)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:256)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:703)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:416)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:370)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:389)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:342)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:229)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:503)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
at java.base/java.lang.Thread.run(Thread.java:844)
Caused by: java.lang.ExceptionInInitializerError
at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:109)
at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:115)
at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:75)
at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:268)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:231)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:218)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:443)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:169)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:270)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:65)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:58)
... 65 more
Caused by: java.nio.charset.UnsupportedCharsetException: Big5
at java.base/java.nio.charset.Charset.forName(Charset.java:529)
at org.apache.poi.util.StringUtil.<clinit>(StringUtil.java:37)
... 79 more
2018-10-26 16:50:08 ERROR: Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception -
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.jxls.util.TransformerFactory.createTransformer(TransformerFactory.java:35)
at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:381)
at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:173)
at org.traccar.reports.Summary.getExcel(Summary.java:114)
at org.traccar.api.resource.ReportResource.lambda$getSummaryExcel$3(ReportResource.java:159)
at org.traccar.api.resource.ReportResource.lambda$executeReport$0(ReportResource.java:74)
at java.base/java.lang.Thread.run(Thread.java:844)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.util.StringUtil
at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:109)
at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:115)
at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:75)
at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:268)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:231)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:218)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:443)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:169)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:270)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:65)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:58)
... 11 more
2018-10-26 16:50:08 ERROR: Thread exception -
java.lang.IllegalStateException: Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:383)
at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:173)
at org.traccar.reports.Summary.getExcel(Summary.java:114)
at org.traccar.api.resource.ReportResource.lambda$getSummaryExcel$3(ReportResource.java:159)
at org.traccar.api.resource.ReportResource.lambda$executeReport$0(ReportResource.java:74)
at java.base/java.lang.Thread.run(Thread.java:844)
2018-10-26 19:28:22 ERROR: Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception - InvocationTargetException (... < ReportUtils:158 < Route:82 < ReportResource:113 < ...)
Have you found what the issue is Anton?
Found your post on Github....
Please try this version:
https://www.dropbox.com/s/xshgs7h932w88z3/traccar-windows-64-4.2-test.zip
Sorry, export not working.
2018-11-03 14:09:14 ERROR: Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception -
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.jxls.util.TransformerFactory.createTransformer(TransformerFactory.java:35)
at org.traccar.reports.ReportUtils.processTemplateWithSheets(ReportUtils.java:158)
at org.traccar.reports.Route.getExcel(Route.java:82)
at org.traccar.api.resource.ReportResource.lambda$getRouteExcel$1(ReportResource.java:113)
at org.traccar.api.resource.ReportResource.executeReport(ReportResource.java:90)
at org.traccar.api.resource.ReportResource.getRouteExcel(ReportResource.java:112)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:200)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:493)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:415)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:104)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:277)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268)
at org.glassfish.jersey.internal.Errors.process(Errors.java:316)
at org.glassfish.jersey.internal.Errors.process(Errors.java:298)
at org.glassfish.jersey.internal.Errors.process(Errors.java:268)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:289)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:256)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:703)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:416)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:370)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:389)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:342)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:229)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:503)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
at java.base/java.lang.Thread.run(Thread.java:844)
Caused by: java.io.IOException
at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:326)
at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:296)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:214)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:180)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:65)
at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:58)
... 64 more
Caused by: java.lang.ExceptionInInitializerError
at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:109)
at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:116)
at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:74)
at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:269)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:232)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:219)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:452)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:417)
at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:184)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:286)
at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:83)
at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:130)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:314)
... 69 more
Caused by: java.nio.charset.UnsupportedCharsetException: Big5
at java.base/java.nio.charset.Charset.forName(Charset.java:529)
at org.apache.poi.util.StringUtil.<clinit>(StringUtil.java:39)
... 86 more
Please try again now. Same link.
Are you using default templates for Excel reports?