Clarity PPM

Expand all | Collapse all

JR Exception Error after parameter creation

Jump to Best Answer
  • 1.  JR Exception Error after parameter creation

    Posted 06-06-2016 12:44 PM

    I get the following error after I added the parameter into the SQL in the Jaspersoft Studio

    DescriptionResourcePathLocationType
    Build path specifies execution environment JavaSE-1.6. There are no JREs installed in the workspace that are strictly compatible with this environment.MyReportsBuild pathJRE System Library Problem

     

     

    I'm not sure what to do here.

     

     

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

      at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:506)

      at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:481)

      at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:362)

      at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

    Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Blank_A4_Landscape.

      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)

      at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)

      at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)

      at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)

      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)

      at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)

      at java.lang.Thread.run(Unknown Source)

    Caused by: java.sql.SQLException: [TIBCO][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended

     

     

      at tibcosoftwareinc.jdbc.oraclebase.ddcr.b(Unknown Source)

      at tibcosoftwareinc.jdbc.oraclebase.ddcr.a(Unknown Source)

      at tibcosoftwareinc.jdbc.oraclebase.ddcq.b(Unknown Source)

      at tibcosoftwareinc.jdbc.oraclebase.ddcq.a(Unknown Source)

      at tibcosoftwareinc.jdbc.oracle.ddal.a(Unknown Source)

      at tibcosoftwareinc.jdbc.oracle.ddal.a(Unknown Source)

      at tibcosoftwareinc.jdbc.oracle.ddam.t(Unknown Source)

      at tibcosoftwareinc.jdbc.oraclebase.dde3.w(Unknown Source)

      at tibcosoftwareinc.jdbc.oraclebase.dde3.v(Unknown Source)

      at tibcosoftwareinc.jdbc.oraclebase.dddz.executeQuery(Unknown Source)

      at tibcosoftware.jdbc.common.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:45)

      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)

      ... 6 more



  • 2.  Re: JR Exception Error after parameter creation
    Best Answer

    Posted 06-07-2016 10:21 AM

    Hi Julian

     

    Based on your error message:

    ORA-00933: SQL command not properly ended

    It looks like the changes you did on the query by adding this parameter somehow made the SQL query invalid. I'd suggest at this point to look over the query and see if there is no parenthesis missing or such. If you don't see anything, revert your changes, ensure the query works. Then make the modifications again step by step and monitor the results. If you have access to the database, you may also run the same query in a database analyzer tool and see how it returns immediately.

     

    Hope this helps -Nika



  • 3.  Re: JR Exception Error after parameter creation

    Posted 06-10-2016 12:55 PM

    Hi Julian - Did Nika's response help answer your question? If so please mark as Correct Answer. Thanks!