HSQLDB to MySQL > BIRT Reports

[marc.carrio]

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.