Issue with Jasper getting exception as net.sf.jasperreports.engine.fill.JRFillSubreport : prepare - Fill 2145049582: exception?

[raghupathiraja.arumugam]

Hi,

      i am new to jasper reports. I have developed a application to generate reports with the use of JASPER Code from java.  I have compiled jrxml file and got object from that and passing that obect to generate reports.  I got more than 2Lack reports and after that got following exception and stopped process.

net.sf.jasperreports.engine.fill.JRFillSubreport : prepare - Fill 2145049582: exception
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : subForMain
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:207)
 at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:741)
 at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:639)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1238)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:869)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:813)
 at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:639)
 at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
 at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)
 at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
 at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
 at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:201)
 ... 9 more
2013-01-03 12:07:00,858 net.sf.jasperreports.engine.fill.JRFillSubreport : prepare - Fill 519518501: exception
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : subForMain
 at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:741)
 at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:328)
 at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:388)
 at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:347)
 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2039)
 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:761)
 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:271)
 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:813)
 at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:639)
 at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
 at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)
 at java.lang.Thread.run(Thread.java:662)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : subForMain
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:207)
 at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:741)
 at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:639)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1238)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:869)
 ... 5 more
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
 at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
 at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:201)
 ... 9 more

    I dont  know that this is a data base issue or Jasper issue.

   Please help me out of this.

[shan.mohammad]

Hi Raghu,

I'm also facing same problem please help me out also!!!

 

[ajinkya_c]

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

from that statement of error code it looks that, the error may be in your sql thats why the report unable to fill.

let me know if you find exact one.

[raghupathiraja.arumugam]

Thanks for the answer.

Yes, I am also think like that only. But i got more than 2 Lack reports successfully, after that i got this issue. i thinks database problem like some one refreshing table or truncating table etc., But i am also in doubt and try to find out the solution.

[shan.mohammad]

Please check what ever table or view is using in this report that is availabe in your DB or not!!!