net.sf.jasperreports.engine.JRException: Error executing SQL statement for : rep_asignacion_inicial

openxava | agarcia1983 | 3 years ago
  1. 0

    Ran out of memory retrieving query results

    openxava | 3 years ago | agarcia1983
    net.sf.jasperreports.engine.JRException: Error executing SQL statement for : rep_asignacion_inicial
  2. 0

    Requested array size exceeds VM limit

    symmetricds | 8 years ago | thermo4
    java.lang.RuntimeException: Error during SQL: select case when t."spl_id" is null then '' else '"' || cast(t."spl_id" as varchar) || '"' end ||','|| case when t."analysis_type_id" is null then '' else '"' || cast(t."analysis_type_id" as varchar) || '"' end ||','|| case when t."spl_status_id" is null then '' else '"' || cast(t."spl_status_id" as varchar) || '"' end ||','|| case when t."spl_desc" is null then '' else '"' || replace(replace(t."spl_desc",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."date_taken" is null then '' else '"' || to_char(t."date_taken", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."sent_to_corp" is null then '' when t."sent_to_corp" then '"1"' else '"0"' end||','|| case when t."date_sent_to_corp" is null then '' else '"' || to_char(t."date_sent_to_corp", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."documentno_sent" is null then '' else '"' || replace(replace(t."documentno_sent",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."report_recieved" is null then '' when t."report_recieved" then '"1"' else '"0"' end||','|| case when t."report_date" is null then '' else '"' || to_char(t."report_date", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."documentno_rec" is null then '' else '"' || replace(replace(t."documentno_rec",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."presumptive" is null then '' when t."presumptive" then '"1"' else '"0"' end||','|| case when t."presumptive_mp_name" is null then '' else '"' || replace(replace(t."presumptive_mp_name",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."probability" is null then '' else '"' || cast(t."probability" as varchar) || '"' end ||','|| case when t."remarks" is null then '' else '"' || replace(replace(t."remarks",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."modified_date" is null then '' else '"' || to_char(t."modified_date", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."creation_date" is null then '' else '"' || to_char(t."creation_date", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."created_by_user_id" is null then '' else '"' || cast(t."created_by_user_id" as varchar) || '"' end ||','|| case when t."modified_by_user_id" is null then '' else '"' || cast(t."modified_by_user_id" as varchar) || '"' end ||','|| case when t."bp_id" is null then '' else '"' || cast(t."bp_id" as varchar) || '"' end ||','|| case when t."spl_picture" is null then '' else '"' || replace(replace(encode(t."spl_picture", 'base64'),E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."spl_received_to_corp_date" is null then '' else '"' || to_char(t."spl_received_to_corp_date", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."spl_received_to_corp_doc_no" is null then '' else '"' || replace(replace(t."spl_received_to_corp_doc_no",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."spl_received_to_corp_by" is null then '' else '"' || cast(t."spl_received_to_corp_by" as varchar) || '"' end ||','|| case when t."profile_status" is null then '' else '"' || cast(t."profile_status" as varchar) || '"' end ||','|| case when t."has_profile" is null then '' when t."has_profile" then '"1"' else '"0"' end||','|| case when t."sent_to_corp_by" is null then '' else '"' || cast(t."sent_to_corp_by" as varchar) || '"' end ||','|| case when t."pm_data_id" is null then '' else '"' || cast(t."pm_data_id" as varchar) || '"' end ||','|| case when t."barcode" is null then '' else '"' || replace(replace(t."barcode",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."commingled_id" is null then '' else '"' || cast(t."commingled_id" as varchar) || '"' end ||','|| case when t."spl_code" is null then '' else '"' || replace(replace(t."spl_code",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."case_no" is null then '' else '"' || replace(replace(t."case_no",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."spl_project_id" is null then '' else '"' || cast(t."spl_project_id" as varchar) || '"' end ||','|| case when t."site_name_id" is null then '' else '"' || cast(t."site_name_id" as varchar) || '"' end ||','|| case when t."spare_spl_requested" is null then '' when t."spare_spl_requested" then '"1"' else '"0"' end||','|| case when t."spare_spl_request_date" is null then '' else '"' || to_char(t."spare_spl_request_date", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."spare_spl_request_doc" is null then '' else '"' || replace(replace(t."spare_spl_request_doc",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."spare_spl_requested_by" is null then '' else '"' || cast(t."spare_spl_requested_by" as varchar) || '"' end ||','|| case when t."spare_spl_received" is null then '' when t."spare_spl_received" then '"1"' else '"0"' end||','|| case when t."spare_spl_receiving_date" is null then '' else '"' || to_char(t."spare_spl_receiving_date", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."spare_spl_received_doc" is null then '' else '"' || replace(replace(t."spare_spl_received_doc",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."spare_spl_received_by" is null then '' else '"' || cast(t."spare_spl_received_by" as varchar) || '"' end ||','|| case when t."spl_returned_to_pathologist" is null then '' when t."spl_returned_to_pathologist" then '"1"' else '"0"' end||','|| case when t."spl_archive_position" is null then '' else '"' || replace(replace(t."spl_archive_position",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."pathl_id" is null then '' else '"' || cast(t."pathl_id" as varchar) || '"' end ||','|| case when t."ic_id" is null then '' else '"' || cast(t."iic_id" as varchar) || '"' end ||','|| case when t."spl_without_match" is null then '' when t."spl_without_match" then '"1"' else '"0"' end||','|| case when t."content_picture" is null then '' else '"' || replace(replace(encode(t."content_picture", 'base64'),E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."coc_doc_id" is null then '' else '"' || cast(t."coc_doc_id" as varchar) || '"' end from samples t where 1=1
  3. 0

    Out of Memory errors

    symmetricds | 4 years ago | laffer1
    java.lang.OutOfMemoryError: Java heap space at org.postgresql.core.v3.QueryExecutorImpl.receiveFields(QueryExecutorImpl.ja va:2056) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j ava:1903) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.lang.OutOfMemoryError: Java heap space

    symmetricds | 5 years ago | uthadehikaru
    java.lang.OutOfMemoryError: Java heap space at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j ava:1811) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  6. 0

    OutOfMemory Exception : java heap space

    Google Groups | 6 months ago | deepak singh
    java.lang.OutOfMemoryError: Java heap space* *java.lang.OutOfMemoryError: Java heap space*

    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.lang.OutOfMemoryError

      Java heap space

      at org.postgresql.core.PGStream.ReceiveTupleV3()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Statement.executeQuery
      1. org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:359)
      2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1854)
      3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
      4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
      5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
      6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
      6 frames
    3. org.apache.tomcat
      DelegatingPreparedStatement.executeQuery
      1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
      1 frame
    4. JasperReports
      JasperFillManager.fillReport
      1. net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)
      2. net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086)
      3. net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)
      4. net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258)
      5. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)
      6. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)
      7. net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
      8. net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
      9. net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:849)
      9 frames
    5. org.openxava.actions
      JasperReportBaseAction.execute
      1. org.openxava.actions.JasperReportBaseAction.execute(JasperReportBaseAction.java:105)
      1 frame
    6. org.openxava.controller
      ModuleManager.execute
      1. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:374)
      2. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:291)
      3. org.openxava.controller.ModuleManager.execute(ModuleManager.java:251)
      3 frames
    7. org.apache.jsp
      execute_jsp._jspService
      1. org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:177)
      1 frame
    8. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      1 frame
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    10. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
      3 frames
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    12. Glassfish Core
      ApplicationDispatcher.include
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
      4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
      5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
      5 frames