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

openxava | agarcia1983 | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Out of Memory errors

    symmetricds | 5 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)

    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