OALL8 is in an inconsistent state ?

0

I have a JasperServer's scheduled hourly "RO103" report that automatically emails me every hour ONLY if it has results. I got the below at 7pm, 8pm, and 9pm last night. I then manually ran the "RO103" report today and it displays "The report is empty", showing that there are no results. What is the "OALL8 is in an inconsistent state" ERROR below ?   ** Maybe my Oracle db was down for      a few hours and then recovered by      10pm since I did not get a 10pm      "RO103" error report ? ------------------------------------------------------------------ com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : RO103     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)     at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:127)     at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:668)     at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588)     at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1212)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420)     at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:661)     at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:356)     at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:788)     at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60)     at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:288)     at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:441)     at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:369)     at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188)     at org.quartz.core.JobRunShell.run(JobRunShell.java:195)     at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLException: OALL8 is in an inconsistent state     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)     at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)     at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)     ... 17 more  

runner1549's picture
Joined: Sep 1 2008 - 7:06am
Last seen: 6 years 3 months ago

1 Answer:

0

Looks like an Oracle JDBC driver issue. see http://forums.oracle.com/forums/thread.jspa?threadID=274018&tstart=0

 

Sherman

Jaspersoft

swood's picture
2064
Joined: Jun 21 2006 - 12:48pm
Last seen: 2 years 2 months ago
Feedback