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
  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 | 7 months ago
    javax.jbi.messaging.MessagingException: Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL

  1. qavid 1 times, last 4 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