Jump to content
Changes to the Jaspersoft community edition download ×

ireport - subreport is working with one report, runtime error in another


aniri.g

Recommended Posts

 The same subreport is in a few reports in Title band to get a description of the parameter from db.

Works perfectly ok in 2 reports, in the third is giving run time error.

The only difference withe the others - the third one has another component - list in the summary band  with dataset (the same database and different table)

One of the working one has a few different subreports working with no problem

Any idea why it can be? Track is subreport name.

Can it be data connection in subreport and list component somehow a problem?

Thanks.

Filling report...  Locale: English (United States)  Time zone: Default Error filling print... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Track
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Track 
    at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:786) 
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331) 
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:379) 
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:353) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:346) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:280) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Track 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:655) 
    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) 
    at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 
    at java.lang.Thread.run(Unknown Source) 
Caused by: java.sql.SQLException: No MST is currently in progress, cannot declare another cursor. 
    at com.ingres.gcf.util.SqlExType.getSqlEx(SqlExType.java:112) 
    at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:96) 
    at com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:852) 
    at com.ingres.gcf.jdbc.JdbcStmt.readError(JdbcStmt.java:2814) 
    at com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:636) 
    at com.ingres.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2711) 
    at com.ingres.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2662) 
    at com.ingres.gcf.jdbc.JdbcPrep.exec(JdbcPrep.java:1227) 
    at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(JdbcPrep.java:584) 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) 
    ... 11 more 

Print not filled. Try to use an EmptyDataSource...

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...