[Report not generating after multiple swap file created with 0kb]

Hi

I am generating huge report using jasper. We are using JRSwapFileVirtualizer

new JRSwapFileVirtualizer(10, new JRSwapFile("directory", 2048, 1024), true)

Once i triggered the report, the multiple swap files are created with 0 kb in certain interval. And each swap file takes each oracle session.

0 Feb 10 06:13 swap_829782293_1486725199801

0 Feb 10 06:34 swap_2052563733_1486726455624

0 Feb 10 06:55 swap_1512809775_1486727704895

0 Feb 10 07:04 swap_81603532_1486728254577

0 Feb 10 07:07 swap_2116103053_1486728434652

0 Feb 10 07:12 swap_262089995_1486728761876

After 20 swap files all oracle sessions are full. So, We are unable to process with next report.
Please help me how to handle this issue, why multiple swap files are creating and why swap files is not incrementing?

 

Thanks in advance

[Dynamic XLS Export Parameters in JasperReports Server]

I have two report and i deployed it in jasperreports server. As per my requirement, I have to export it in Excel format.
But both report have different  xls exporter properties.
eg. Report1 - IgnoreGraphics= true; Report2 - IgnoreGraphics= false;

Not only above the xls property also many other(one_page_per_sheet, max per sheet, etc ....)
Every time i changing WEB-IN/applicationContext.xml file to generate the report in my local machine.

I am unable to do this config change in WEB-IN/applicationContext.xml file for each report, in higher env(PROD).

Is it possible to change the xls property dynamically  based on the report ?

 

[Migrating report from Alteryx to Jasper]

I have to migrate Altreyx report to Jasper.

I am new to jasper and i have no idea on this. 

should i use Jaspersoft ETL or iReports tool for this migration?

[how to append rows in excel reports]

I created a report using table like below

First Name	Country
Ami	US
John	UK

Now  i have to add two more rows in the excel from another query. So, my report should like below.

First Name	Country
Ami	US
John	UK
Steve	Aus
Kevin	Canada

is this possible?

[Unable to get next record from result set]

I am getting this error

ERROR org.springframework.jms.listener.DefaultMessageListenerContainer#0-1 JRFillSubreport.prepare(864) - Fill 1: exception

net.sf.jasperreports.engine.JRException: Unable to get next record from result set.

                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:130)

                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1422)

                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1271)

                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1250)

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

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

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

                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393)

                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:728)

                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)

                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)

                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:722)

Caused by: java.sql.SQLException: Closed Connection: next

                at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

                at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)

                at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:200)

                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:126)

                ... 13 more

 

Any idea on this?