"Unable to get next record"

Posted on August 15, 2013 at 1:48am

Hi, everyone.

I'm newbie in iReports, I've created a simple report with table, but when I try to preview report or data (in table query editor) got error.

Error filling print... Unable to get next record.
net.sf.jasperreports.engine.JRException: Unable to get next record. 
    at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:113) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1380) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1229) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1208) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1554) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:153) 
    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: org.firebirdsql.jdbc.FBSQLException: The result set is closed 
    at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(AbstractResultSet.java:220) 
    at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:272) 
    at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:109) 
    ... 14 more 
Print not filled. Try to use an EmptyDataSource...

Attachments: 
Image icon an_error.png
iReport Designer
kamikadze238's picture
kamikadze238
2
Joined: Aug 14 2013 - 11:00pm
Last seen: 8 years 8 months ago

4 Answers:

Posted on October 29, 2013 at 10:31pm
Select Language SQL and Did you declare those parameters in jrxml file.can u post the jrxml file
netti royala's picture
netti royala
723
Joined: Oct 28 2013 - 11:43pm
Last seen: 8 years 5 months ago
Posted on November 9, 2013 at 11:31pm

Use Jasper server 5.2 version.It can by default handle this error

netti royala's picture
netti royala
723
Joined: Oct 28 2013 - 11:43pm
Last seen: 8 years 5 months ago
Posted on March 15, 2016 at 2:08am

please help me 

Error filling print... Unable to get next record.
net.sf.jasperreports.engine.JRException: Unable to get next record. 
    at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:113) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1405) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1254) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1233) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1577) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:153) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) 
    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:1432) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2044) 
Caused by: java.sql.SQLException: ORA-01476: divisor is equal to zero
 
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) 
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) 
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) 
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) 
    at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198) 
    at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:276) 
    at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:109) 
    ... 14 more 
Print not filled. Try to use an EmptyDataSource...

 

i tried with above procedure.but the code does not work

chandrasekhar@geceindia.com's picture
chandrasekhar@g...
340
Joined: Nov 25 2015 - 4:20am
Last seen: 7 years 2 months ago
Posted on March 17, 2016 at 2:37am

Hi,

Could you post your SQL query text here? Apparently it attempted a division by 0 while running.

Thanks,

Sanda

shertage's picture
shertage
19706
Joined: Sep 26 2006 - 8:06pm
Last seen: 11 months 2 weeks ago
Feedback