6 Replies Latest reply on Dec 28, 2009 5:47 AM by jbarrez

How to change the module "Reporting" from jbpm-console to Postgres???

cmjhingeniero Dec 17, 2009 4:04 PM

I wonder how I can change so that the reports are on postgres. The database jbpm this on postgres. The changed the DataSource for the Eclipse to make it pointing to postgres, but when I start the Tomcat server I get the following error.

ERROR:

INFO: Server startup in 2239 ms
17/12/2009 03:33:28 PM org.eclipse.birt.report.engine.api.impl.ReportEngineHelper openReportDesign
GRAVE: invalid design file file:/C:/jbpm-4.2/apache-tomcat-6.0.20/birt/process_summary.rptdesign
Exception in thread "BirtService-Init" java.lang.RuntimeException: Failed to load reports
        at org.jboss.bpm.report.BirtService.create(BirtService.java:94)
        at org.jboss.bpm.report.BirtService$2.run(BirtService.java:213)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.eclipse.birt.report.engine.api.EngineException: The design file file:/C:/jbpm-4.2/apache-tomcat-6.0.20/birt/process_summary.rptdesign has error and can not be run.
        at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:258)
        at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:193)
        at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:127)
        at org.eclipse.birt.report.engine.api.impl.ReportEngine.openReportDesign(ReportEngine.java:349)
        at org.jboss.bpm.report.BirtService.openCached(BirtService.java:433)
        at org.jboss.bpm.report.BirtService.extractParameterMetaData(BirtService.java:129)
        at org.jboss.bpm.report.BirtService.create(BirtService.java:90)
        ... 2 more
Caused by: Error.DesignFileException.INVALID_XML - 1 errors found!
1.) ( line = 0, tag = null) org.eclipse.birt.report.model.parser.DesignParserException (code = Error.DesignParserException.UNSUPPORTED_VERSION, message : The report file of versi
on "3.2.20" is invalid for it is greater than the latest supported one.)

        at org.eclipse.birt.report.model.parser.ModuleReader.readModule(ModuleReader.java:116)
        at org.eclipse.birt.report.model.parser.DesignReader.read(DesignReader.java:88)
        at org.eclipse.birt.report.model.core.DesignSession.openDesign(DesignSession.java:321)
        at org.eclipse.birt.report.model.api.SessionHandle.openDesign(SessionHandle.java:294)
        at org.eclipse.birt.report.engine.parser.ReportParser.getDesignHandle(ReportParser.java:158)
        at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:253)
        ... 8 more
Caused by: org.eclipse.birt.report.model.parser.DesignParserException: The report file of version "3.2.20" is invalid for it is greater than the latest supported one.
        at org.eclipse.birt.report.model.parser.ModuleState.parseAttrs(ModuleState.java:112)
        at org.eclipse.birt.report.model.parser.ModuleParserHandler.startElement(ModuleParserHandler.java:229)
        at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:501)
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:767)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1363)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1318)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3103)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:922)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)
        at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
        at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
        at org.eclipse.birt.report.model.parser.ModuleReader.readModule(ModuleReader.java:94)
        ... 13 more
Caused by: org.eclipse.birt.report.model.parser.DesignParserException: The report file of version "3.2.20" is invalid for it is greater than the latest supported one.
        at org.eclipse.birt.report.model.parser.ModuleState.parseAttrs(ModuleState.java:109)
        ... 29 more

I appreciate any information

Thanks

1. Re: How to change the module "Reporting" from jbpm-console to Postgres???

cmjhingeniero Dec 22, 2009 3:41 PM (in response to cmjhingeniero)

Any response!!!
Actions
2. Re: How to change the module "Reporting" from jbpm-console to Postgres???

sebastian.s Dec 22, 2009 3:51 PM (in response to cmjhingeniero)

This does not look like a jBPM problem. Could it be that you have created or changed a report with a newer version of the BIRT report designer than the BIRT version the console is using? I am just guessing but since this looks like a problem with BIRT you should consult the BIRT documentation or do a search on this with Google.
1 of 1 people found this helpful
Actions
3. Re: How to change the module "Reporting" from jbpm-console to Postgres???

jbarrez Dec 22, 2009 3:53 PM (in response to cmjhingeniero)

It's a known limitation that the reporting doesn't work on Tomcat.

On JBoss, to change the database for the reporting, change the java:/jbpmDS datasource.
Actions
4. Re: How to change the module "Reporting" from jbpm-console to Postgres???

jbarrez Dec 22, 2009 3:55 PM (in response to sebastian.s)

Right. Compatible BIRT version is 2.3.

But the odd thing is that you say you're using Tomcat ... while the reporting functionality doesn't work at all on tomcat, while your stacktrace seems to indicate otherwise...
Actions
5. Re: How to change the module "Reporting" from jbpm-console to Postgres???

cmjhingeniero Dec 22, 2009 4:13 PM (in response to cmjhingeniero)

Correctly. I modified the reports (overall_activity.rptdesign, overall_activity_old.rptdesign, process_summary.rptdesign, specific_system_overview.rptdesign) because these have the MySql DataSource, and I'm using is Postgresql. The only difference was the DataSource and when I try to lift the Tomcat I get the error. The change reports in the Eclipse Galileo - BIRT 2.5.1

Serviria en Tomcat o no??? que deberia de hacer???
Actions
6. Re: How to change the module "Reporting" from jbpm-console to Postgres???

jbarrez Dec 28, 2009 5:47 AM (in response to cmjhingeniero)

You just need to change the datasource in JNDI if you want to change the datasource for the reporting.
This is tested on JBoss, but not yet out-of-the-box enabled on Tomcat.
Actions

Go to original post