aniri.g Posted March 18, 2013 Share Posted March 18, 2013 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 problemAny 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now