0 Replies Latest reply on Apr 7, 2010 10:31 AM by Mary Marlet

    HSQLDB to MySQL  > BIRT Reports

    Mary Marlet Newbie

      Hello guys,

       

      I'm playing with the jBPM 4.3 with HSQLDB and Tomcat and work fine! Now, I need migrate the BBDD to MySQL. I reinstalled the system with ant and MySQL Database.

       

      The jbpm-console works perfect, but the Periodic Overview Report crash. I changed the data-source of report and all dependencies, but I don't understand the problem. With HSQLDB works!

       

      When start the tomcat don't shows any error. The error in the console is:

       

       

      The following items have errors:


      Data (id  = 411):
      +  Can't load the report query: 411.
      Error.ReportQueryLoadingError ( 1 time(s) )
      detail : org.eclipse.birt.report.engine.api.EngineException: Can't load
           the report query: 411.
      at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery
           (DataPresentationEngine.java:140)
      at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute
           (AbstractDataEngine.java:253)
      at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery
           (ExecutionContext.java:1755)
      at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery
           (ReportItemExecutor.ja


      Data (id  = 412):
      +  Can't load the report query: 412.


      Data (id  = 417):
      +  Can't load the report query: 417.


      Data (id  = 418):
      +  Can't load the report query: 418.


      Table  (id = 379):
      +  Can't load the report query: 379.


      Data (id  = 419):
      +  Can't load the report query: 419.


      Data (id  = 420):
      +  Can't load the report query: 420.


      Data (id  = 421):
      +  Can't load the report query: 421.


      Crosstab  (id = 725):
      +  /olap/cube_process_instances_date_aggregation doesnt exist
      /olap/cube_process_instances_date_aggregation  doesn't exist


      Chart  NewChart:

      +  Can't load the report query: 809.

       

       

      And part of the error in the server is:

       


      Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
              at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2796)
              at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2827)
              at com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:3787)
              at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:3737)
              at org.eclipse.birt.report.data.oda.jdbc.Statement.setTimestamp(Statement.java:761)
              ... 64 more
             
      07-abr-2010 16:14:42 org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor execute
      GRAVE: An exception occurred during processing. Please see the following message for details:
      Cannot set the timestamp value (2010-01-01 00:00) to parameter 1.
      Cannot set preparedStatement parameter timestamp value.
      SQL error #1: Parameter index out of range (1 > number of parameters, which is 0).


      org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
      Cannot set the timestamp value (2010-01-01 00:00) to parameter 1.
      Cannot set preparedStatement parameter timestamp value.
      SQL error #1: Parameter index out of range (1 > number of parameters, which is 0).


              at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:493)
              at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)

       

       

      I attached the report design. Any suggestions?

       

      Thanks a lot!

       

      Mary.