Report execution failed

[jasmin.kaldzija]

Hi everyone,

I have some specific problem with one "big" report. It works fine, but in last few day it returns exception (java.io.IOException: The requested operation could not be completed due to a file system limitation) when report contains a lot of pages(it works for small number of pages). My proposal is something about temp files gone wrong.

[hozawa]

That's usually cause by setting in your Tomcat or in MySQL database. MySQL has a max file size setting in my.ini. Check the jasperserver.log file to find the exact cause of the error.

[jasmin.kaldzija]

Hi hozawa,

Thank you for answering. This is exception:
 

2015-12-16 09:23:22,075 ERROR AsyncJasperPrintAccessor,pool-5-thread-1:299 - Error during report execution

net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: The requested operation could not be completed due to a file system limitation

at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.virtualizeData(JRAbstractLRUVirtualizer.java:587)

at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.evict(JRAbstractLRUVirtualizer.java:402)

at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.registerObject(JRAbstractLRUVirtualizer.java:356)

at net.sf.jasperreports.engine.base.ElementsBlock.register(VirtualizableElementList.java:249)

at net.sf.jasperreports.engine.base.ElementsBlock.preAdd(VirtualizableElementList.java:298)

at net.sf.jasperreports.engine.base.ElementsBlock.add(VirtualizableElementList.java:333)

at net.sf.jasperreports.engine.base.ElementsBlock.add(VirtualizableElementList.java:349)

at net.sf.jasperreports.engine.base.VirtualizableElementList.add(VirtualizableElementList.java:125)

at net.sf.jasperreports.engine.base.JRVirtualPrintPage.addElement(JRVirtualPrintPage.java:136)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBand(JRVerticalFiller.java:2139)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2103)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:788)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:298)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963)

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:886)

at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:842)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1731)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1086)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1015)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:908)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:724)

Caused by: java.io.IOException: The requested operation could not be completed due to a file system limitation

at java.io.WinNTFileSystem.createFileExclusively(Native Method)

at java.io.File.createNewFile(File.java:947)

at net.sf.jasperreports.engine.fill.JRFileVirtualizer.pageOut(JRFileVirtualizer.java:113)

at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.virtualizeData(JRAbstractLRUVirtualizer.java:582)

... 25 more