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

openxava | agarcia1983 | 3 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

    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