Friday, July 20, 2007

PITA Day

Well it's happened again. I've hit a roadblock - mainly because the Pentaho documentation does not cover BIRT integration very well.

I've been working for the better part of the day to get a chart to work in Pentaho, which shouldn't have been as hard as it seems to have become after today's festivities.

I tried using the report designer to make the chart, but it is no where near as intuitive as BIRT - therefore, I wanted to work with a BIRT chart...... which I have built in the BIRT Report Designer and have been trying to plug it into the Pentaho Design Studio with an .xaction . Of course, I end up with the following:

Error: BIRT.ERROR_0007 - error running report Task_Master\Reports\mold_metric_by_jobtype.rptdesign - org.eclipse.birt.report.engine.api.EngineException: The design file has error and can not be run. (org.pentaho.plugin.eclipsebirt.BIRTReportComponent)

Debug: Starting execute of Task_Master/Reports/mold_metric_by_jobtype.xaction (org.pentaho.core.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=C:\Documents and Settings\ameadows\Desktop\pentaho-demo\pentaho-solutions\Task_Master\Reports\mold_metric_by_jobtype.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter DEPARTMENT (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1" to parameter DEPARTMENT (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: audit: instanceId=905acb35-36fc-11dc-8a80-d52e03632182, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=C:\Documents and Settings\ameadows\Desktop\pentaho-demo\pentaho-solutions (org.pentaho.repository.filebased.solution.SolutionRepository)
Error: BIRT.ERROR_0007 - error running report Task_Master\Reports\mold_metric_by_jobtype.rptdesign - org.eclipse.birt.report.engine.api.EngineException: The design file has error and can not be run. (org.pentaho.plugin.eclipsebirt.BIRTReportComponent)
Error: RuntimeContext.ERROR_0012 - ActionDefinition for BIRTReportComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)

I doubt anyone will read this, but with the way my luck is going I'll be working on getting this to work for a while. If anyone knows of a solution, please post to here. If I can find the solution, I will of course reply to this message with it. Thanks for the help if anyone does post!

2 comments:

Anonymous said...

Did you try changing the version element to somthing like xmlns="http://www.eclipse.org/birt/2005/design" version="2.0.0" id="1" ? This usually happens when the designer is newer than the engine that Pentaho is running. Most of the time you can get it to work by tricking it into believing it is using an earlier version.
HTH

DBA_Alex said...

I'll definiately give that a try - thanks for the advice - I'll post a new blog when I get back to the office =)