org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM ( SELECT CASE WHEN ${p_beg_sch_yr} >= 2013 THEN ' ' || CHR ( 64 + CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =37 THEN 8 WHEN aa.memb_adjust_type_id =16 THEN 9 WHEN aa.memb_adjust_type_id =17 THEN 10 WHEN aa.memb_adjust_type_id =35 THEN 11 WHEN aa.memb_adjust_type_id =38 THEN 12 END) || '. ' || aa.adj_descr WHEN ${p_beg_sch_yr} <= 2012 THEN ' ' || CHR ( 64 + CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =16 THEN 8 WHEN aa.memb_adjust_type_id =17 THEN 9 WHEN aa.memb_adjust_type_id =35 THEN 10 END) || '. ' || aa.adj_descr ELSE aa.adj_descr END k3_deduct_adj_descr, deduct_cnt k3_deduct_cnt, aa.grade_code k3_deduct_grade, (CASE WHEN ${p_beg_sch_yr} >= 2013 THEN (CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =37 THEN 8 WHEN aa.memb_adjust_type_id =16 THEN 9 WHEN aa.memb_adjust_type_id =17 THEN 10 WHEN aa.memb_adjust_type_id =35 THEN 11 WHEN aa.memb_adjust_type_id =38 THEN 12 END) WHEN ${p_beg_sch_yr} <= 2012 THEN (CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =16 THEN 8 WHEN aa.memb_adjust_type_id =17 THEN 9 WHEN aa.memb_adjust_type_id =35 THEN 10 END) END) k3_deduct_orderby FROM (SELECT DECODE ( memb_adjust_type_id, 1, 'Pupils for whom you receive tuition from another school division in Virginia', amat.descr) adj_descr, memb_adjust_type_id, grade_code, stu_rec_sort_seq FROM school.memb_adjust_type amat, grade gc WHERE amat.memb_adjust_type_id IN (1, 6, 8, 9, 10, 11, 12, 16, 17, 35, 37, 38) AND 1 = (CASE WHEN ${p_beg_sch_yr} = 2012 AND amat.memb_adjust_type_id IN (37,38) THEN 0 WHEN ${p_beg_sch_yr} = 2011 AND amat.memb_adjust_type_id IN (37,38) THEN 0 WHEN ${p_beg_sch_yr} >= 2010 AND amat.memb_adjust_type_id IN (35,37,38) THEN 0 ELSE 1 END) AND gc.grade_code IN ('KG', '01', '02', '03')) aa LEFT OUTER JOIN ( SELECT SUM (stu_cnt) deduct_cnt, memb_adjust_type_id, DECODE (grade_code, 'KA', 'KG', 'KP', 'KG', 'T1', '01', grade_code) g_code FROM k3_memb_adjustment WHERE beg_sch_yr = ${p_beg_sch_yr} AND memb_count_type_id = 5 AND responsible_edagency_num NOT IN (SELECT contract_edagency_num FROM ed_agency_contract WHERE reporting_edagency_num = ${p_edagency_num}) AND DECODE (memb_adjust_type_id, 1, serving_edagency_num, reporting_edagency_num) = ${p_edagency_num} GROUP BY memb_adjust_type_id, DECODE (grade_code, 'KA', 'KG', 'KP', 'KG', 'T1', '01', grade_code)) ama ON ( aa.memb_adjust_type_id = ama.memb_adjust_type_id AND aa.grade_code = ama.g_code) LEFT OUTER JOIN ( SELECT SUM (stu_cnt) c_deduct_cnt, memb_adjust_type_id, grade_code c_g_code FROM k3_memb_adjustment WHERE beg_sch_yr = ${p_beg_sch_yr} AND memb_count_type_id = 5 AND responsible_edagency_num IN (SELECT contract_edagency_num FROM ed_agency_contract WHERE reporting_edagency_num = ${p_edagency_num}) AND DECODE (memb_adjust_type_id, 1, serving_edagency_num, reporting_edagency_num) = ${p_edagency_num} GROUP BY memb_adjust_type_id, grade_code) ama_c ON ( aa.memb_adjust_type_id = ama_c.memb_adjust_type_id AND aa.grade_code = ama_c.c_g_code) ORDER BY k3_deduct_orderby, stu_rec_sort_seq ) PIVOT (SUM (NVL (k3_deduct_cnt, 0)) FOR k3_deduct_grade IN ('KG','01','02','03')) ORDER BY 2

Pentaho BI Platform Tracking | Ramesh | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    see below for Error description org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM ( SELECT CASE WHEN ${p_beg_sch_yr} >= 2013 THEN ' ' || CHR ( 64 + CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =37 THEN 8 WHEN aa.memb_adjust_type_id =16 THEN 9 WHEN aa.memb_adjust_type_id =17 THEN 10 WHEN aa.memb_adjust_type_id =35 THEN 11 WHEN aa.memb_adjust_type_id =38 THEN 12 END) || '. ' || aa.adj_descr WHEN ${p_beg_sch_yr} <= 2012 THEN ' ' || CHR ( 64 + CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =16 THEN 8 WHEN aa.memb_adjust_type_id =17 THEN 9 WHEN aa.memb_adjust_type_id =35 THEN 10 END) || '. ' || aa.adj_descr ELSE aa.adj_descr END k3_deduct_adj_descr, deduct_cnt k3_deduct_cnt, aa.grade_code k3_deduct_grade, (CASE WHEN ${p_beg_sch_yr} >= 2013 THEN (CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =37 THEN 8 WHEN aa.memb_adjust_type_id =16 THEN 9 WHEN aa.memb_adjust_type_id =17 THEN 10 WHEN aa.memb_adjust_type_id =35 THEN 11 WHEN aa.memb_adjust_type_id =38 THEN 12 END) WHEN ${p_beg_sch_yr} <= 2012 THEN (CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =16 THEN 8 WHEN aa.memb_adjust_type_id =17 THEN 9 WHEN aa.memb_adjust_type_id =35 THEN 10 END) END) k3_deduct_orderby FROM (SELECT DECODE ( memb_adjust_type_id, 1, 'Pupils for whom you receive tuition from another school division in Virginia', amat.descr) adj_descr, memb_adjust_type_id, grade_code, stu_rec_sort_seq FROM school.memb_adjust_type amat, grade gc WHERE amat.memb_adjust_type_id IN (1, 6, 8, 9, 10, 11, 12, 16, 17, 35, 37, 38) AND 1 = (CASE WHEN ${p_beg_sch_yr} = 2012 AND amat.memb_adjust_type_id IN (37,38) THEN 0 WHEN ${p_beg_sch_yr} = 2011 AND amat.memb_adjust_type_id IN (37,38) THEN 0 WHEN ${p_beg_sch_yr} >= 2010 AND amat.memb_adjust_type_id IN (35,37,38) THEN 0 ELSE 1 END) AND gc.grade_code IN ('KG', '01', '02', '03')) aa LEFT OUTER JOIN ( SELECT SUM (stu_cnt) deduct_cnt, memb_adjust_type_id, DECODE (grade_code, 'KA', 'KG', 'KP', 'KG', 'T1', '01', grade_code) g_code FROM k3_memb_adjustment WHERE beg_sch_yr = ${p_beg_sch_yr} AND memb_count_type_id = 5 AND responsible_edagency_num NOT IN (SELECT contract_edagency_num FROM ed_agency_contract WHERE reporting_edagency_num = ${p_edagency_num}) AND DECODE (memb_adjust_type_id, 1, serving_edagency_num, reporting_edagency_num) = ${p_edagency_num} GROUP BY memb_adjust_type_id, DECODE (grade_code, 'KA', 'KG', 'KP', 'KG', 'T1', '01', grade_code)) ama ON ( aa.memb_adjust_type_id = ama.memb_adjust_type_id AND aa.grade_code = ama.g_code) LEFT OUTER JOIN ( SELECT SUM (stu_cnt) c_deduct_cnt, memb_adjust_type_id, grade_code c_g_code FROM k3_memb_adjustment WHERE beg_sch_yr = ${p_beg_sch_yr} AND memb_count_type_id = 5 AND responsible_edagency_num IN (SELECT contract_edagency_num FROM ed_agency_contract WHERE reporting_edagency_num = ${p_edagency_num}) AND DECODE (memb_adjust_type_id, 1, serving_edagency_num, reporting_edagency_num) = ${p_edagency_num} GROUP BY memb_adjust_type_id, grade_code) ama_c ON ( aa.memb_adjust_type_id = ama_c.memb_adjust_type_id AND aa.grade_code = ama_c.c_g_code) ORDER BY k3_deduct_orderby, stu_rec_sort_seq ) PIVOT (SUM (NVL (k3_deduct_cnt, 0)) FOR k3_deduct_grade IN ('KG','01','02','03')) ORDER BY 2 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:210) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:162) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:374) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForSubreport(ProcessState.java:596) at org.pentaho.reporting.engine.classic.core.states.process.EndSubReportHandler.commit(EndSubReportHandler.java:59) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.commit(ProcessState.java:1059) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processPrepareLevels(AbstractReportProcessor.java:437) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:558) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewPdfAction$ExportTask.run(PreviewPdfAction.java:123) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:5179) at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:12485) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4793) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:379) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:206) ... 24 more

    Pentaho BI Platform Tracking | 2 years ago | Ramesh
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM ( SELECT CASE WHEN ${p_beg_sch_yr} >= 2013 THEN ' ' || CHR ( 64 + CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =37 THEN 8 WHEN aa.memb_adjust_type_id =16 THEN 9 WHEN aa.memb_adjust_type_id =17 THEN 10 WHEN aa.memb_adjust_type_id =35 THEN 11 WHEN aa.memb_adjust_type_id =38 THEN 12 END) || '. ' || aa.adj_descr WHEN ${p_beg_sch_yr} <= 2012 THEN ' ' || CHR ( 64 + CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =16 THEN 8 WHEN aa.memb_adjust_type_id =17 THEN 9 WHEN aa.memb_adjust_type_id =35 THEN 10 END) || '. ' || aa.adj_descr ELSE aa.adj_descr END k3_deduct_adj_descr, deduct_cnt k3_deduct_cnt, aa.grade_code k3_deduct_grade, (CASE WHEN ${p_beg_sch_yr} >= 2013 THEN (CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =37 THEN 8 WHEN aa.memb_adjust_type_id =16 THEN 9 WHEN aa.memb_adjust_type_id =17 THEN 10 WHEN aa.memb_adjust_type_id =35 THEN 11 WHEN aa.memb_adjust_type_id =38 THEN 12 END) WHEN ${p_beg_sch_yr} <= 2012 THEN (CASE WHEN aa.memb_adjust_type_id =8 THEN 1 WHEN aa.memb_adjust_type_id =9 THEN 2 WHEN aa.memb_adjust_type_id =10 THEN 3 WHEN aa.memb_adjust_type_id =11 THEN 4 WHEN aa.memb_adjust_type_id =1 THEN 5 WHEN aa.memb_adjust_type_id =12 THEN 6 WHEN aa.memb_adjust_type_id =6 THEN 7 WHEN aa.memb_adjust_type_id =16 THEN 8 WHEN aa.memb_adjust_type_id =17 THEN 9 WHEN aa.memb_adjust_type_id =35 THEN 10 END) END) k3_deduct_orderby FROM (SELECT DECODE ( memb_adjust_type_id, 1, 'Pupils for whom you receive tuition from another school division in Virginia', amat.descr) adj_descr, memb_adjust_type_id, grade_code, stu_rec_sort_seq FROM school.memb_adjust_type amat, grade gc WHERE amat.memb_adjust_type_id IN (1, 6, 8, 9, 10, 11, 12, 16, 17, 35, 37, 38) AND 1 = (CASE WHEN ${p_beg_sch_yr} = 2012 AND amat.memb_adjust_type_id IN (37,38) THEN 0 WHEN ${p_beg_sch_yr} = 2011 AND amat.memb_adjust_type_id IN (37,38) THEN 0 WHEN ${p_beg_sch_yr} >= 2010 AND amat.memb_adjust_type_id IN (35,37,38) THEN 0 ELSE 1 END) AND gc.grade_code IN ('KG', '01', '02', '03')) aa LEFT OUTER JOIN ( SELECT SUM (stu_cnt) deduct_cnt, memb_adjust_type_id, DECODE (grade_code, 'KA', 'KG', 'KP', 'KG', 'T1', '01', grade_code) g_code FROM k3_memb_adjustment WHERE beg_sch_yr = ${p_beg_sch_yr} AND memb_count_type_id = 5 AND responsible_edagency_num NOT IN (SELECT contract_edagency_num FROM ed_agency_contract WHERE reporting_edagency_num = ${p_edagency_num}) AND DECODE (memb_adjust_type_id, 1, serving_edagency_num, reporting_edagency_num) = ${p_edagency_num} GROUP BY memb_adjust_type_id, DECODE (grade_code, 'KA', 'KG', 'KP', 'KG', 'T1', '01', grade_code)) ama ON ( aa.memb_adjust_type_id = ama.memb_adjust_type_id AND aa.grade_code = ama.g_code) LEFT OUTER JOIN ( SELECT SUM (stu_cnt) c_deduct_cnt, memb_adjust_type_id, grade_code c_g_code FROM k3_memb_adjustment WHERE beg_sch_yr = ${p_beg_sch_yr} AND memb_count_type_id = 5 AND responsible_edagency_num IN (SELECT contract_edagency_num FROM ed_agency_contract WHERE reporting_edagency_num = ${p_edagency_num}) AND DECODE (memb_adjust_type_id, 1, serving_edagency_num, reporting_edagency_num) = ${p_edagency_num} GROUP BY memb_adjust_type_id, grade_code) ama_c ON ( aa.memb_adjust_type_id = ama_c.memb_adjust_type_id AND aa.grade_code = ama_c.c_g_code) ORDER BY k3_deduct_orderby, stu_rec_sort_seq ) PIVOT (SUM (NVL (k3_deduct_cnt, 0)) FOR k3_deduct_grade IN ('KG','01','02','03')) ORDER BY 2
  2. 0

    maximum open cursors exceeded

    GitHub | 3 years ago | kvishal
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  3. 0

    Does Spring JPA support updating parent/child data having composite keys using Oracle?

    Stack Overflow | 2 years ago
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 3.88::PosixSocketMuxer: unexpected exception in poll: (22) Invalid argument x9

    hivmr.com | 12 months ago
    javax.jbi.messaging.MessagingException: Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL

  1. tzrlk 2 times, last 4 weeks ago
  2. treefolk 2 times, last 4 months ago
  3. qavid 1 times, last 9 months ago
18 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01000: maximum open cursors exceeded

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
    8. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
    10. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
    11. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
    12. oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:5179)
    13. oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:12485)
    14. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4793)
    15. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
    16. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
    16 frames
  3. org.pentaho.reporting
    PreviewPdfAction$ExportTask.run
    1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:379)
    2. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:206)
    3. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:162)
    4. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205)
    5. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
    6. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505)
    7. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181)
    8. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200)
    9. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
    10. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200)
    11. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
    12. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200)
    13. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
    14. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200)
    15. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
    16. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69)
    17. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296)
    18. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:374)
    19. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForSubreport(ProcessState.java:596)
    20. org.pentaho.reporting.engine.classic.core.states.process.EndSubReportHandler.commit(EndSubReportHandler.java:59)
    21. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.commit(ProcessState.java:1059)
    22. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processPrepareLevels(AbstractReportProcessor.java:437)
    23. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:558)
    24. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713)
    25. org.pentaho.reporting.designer.core.actions.report.preview.PreviewPdfAction$ExportTask.run(PreviewPdfAction.java:123)
    25 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame