PDA

View Full Version : lot of issues while Migration from petaho 1.5.5 to Pentaho 1.6 RC



anjan
08-14-2007, 02:52 AM
Hi Pentaho

I did few of the report in pentaho 1.5.5 and I would like to migrate from pentaho 1.5.5 to pentaho 1.6 RC release

Simply I copied my .xaction and .xml , .properties and customer parameter html/jsp from pentaho 1.5.5 to pentaho 1.6

After that i tried to run my report, throwing exceptions
My question to pentaho why they are changing pentaho design .xml file format frequently. Is there any chance to resolve this issue permanently. bcoz in feature i may migrate my reports from pentaho xxxx.xxx version to pentaho yyy.yyy



Even i faced issues while migrating from pentaho 12 GA to pentaho 1.5.5.
There issue is small i just modified few of the tags in .xml working fine.


If anybody help in this regards i'll be very very thankful to them



Failed
Error: JFreeReport.ERROR_0007 - Could not parse report podbridge-solutions/customer-reports/mostPopularShows.xml - org.jfree.resourceloader.ResourceCreationException: Unable to parse the document (org.pentaho.plugin.jfreereport.components.JFreeReportLoadComponent)

Debug: Starting execute of podbridge-solutions/customer-reports/mostPopularShowsUniq.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=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/mostPopularShowsUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: audit: instanceId=b5002d98-4a32-11dc-b405-a1af5fe1http://forums.pentaho.org/c:%5CDocuments%20and%20Settings%5Canjaneyulug%5CApplication%20Data%5CPandion%5CEmoticons%5Cshinyicons%5Cgrin.gif8dc3, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/system/tmp/icons (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository dailyUserRegistrationNonUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/dailyUserRegistrationNonUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/system/tmp/icons (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository sample1.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/sample1.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter output-type (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter output-type (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository weightedAudienceUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/weightedAudienceUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/system/tmp/icons (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository episodePerformanceNonUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/episodePerformanceNonUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/system/tmp/icons (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository uniqueAudienceUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/uniqueAudienceUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/system/tmp/icons (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository episodePerformanceUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/episodePerformanceUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "2-JUL-2007" to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source response to parameter report (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/system/tmp/icons (org.pentaho.repository.filebased.solution.SolutionRepository)
Info: Adding action to solution repository leastPopularShowsUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=/root/Desktop/pentaho-demo/pentaho-solutions/podbridge-solutions/customer-reports/leastPopularShowsUniq.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "pdf" to parameter reportType (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "" to parameter partnerName (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "[{reportTypeDesc=View in PDF, reportTypeId=pdf}, {reportTypeDesc=View in Excel, reportTypeId=xls}, {reportTypeDesc=View in Browser, reportTypeId=html}]" to parameter reportTypeList (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding variable source request to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: Adding default value of "1-JUL-2007" to parameter startDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Error: JFreeReport.ERROR_0007 - Could not parse report podbridge-solutions/customer-reports/mostPopularShows.xml - org.jfree.resourceloader.ResourceCreationException: Unable to parse the document (org.pentaho.plugin.jfreereport.components.JFreeReportLoadComponent)
Debug: Adding variable source request to parameter endDate (org.pentaho.repository.filebased.solution.SolutionRepository)
Error: RuntimeContext.ERROR_0012 - ActionDefinition for JFreeReportComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)

Server Version 1.6.0 build 782 RC1

Thanks
Anjan
BI Developer

pmalves
08-14-2007, 04:48 AM
I've had similar problems not migrating but developing.

Your problem seems that the schemas changed: it would be *very* helpful if we had access to the dtd/xsd of the xmls we build (actions, widgets, reports, etc). It would ease development and verification. The only one I found scattered around was mondrian.xml (and it's very handy to develop with it )

Good luck

anjan
08-14-2007, 06:34 AM
hi

Above said issue is resolved myself.

I followed below approach

1. pentaho renamed jfreereport jar to pentaho-reporting-engine-classic jar
2. in pentaho 1.5.5 i have jar related to jfreereport is pentaho-reporting-engine-classic-0.8.9-pre3
but in pentaho 1.6 RC-1 they changed this jar to pentaho-reporting-engine-classic-0.8.9-pre8

While migration time i used pentaho 1.5.5 pentaho-reporting-engine-classic-0.8.9-pre3 jar instead of
pentaho-reporting-engine-classic-0.8.9-pre8

issue is resolved

Thanks
Anjan
BI Developer

Taqua
08-14-2007, 08:36 AM
Your problem seems that the schemas changed: it would be *very* helpful if we had access to the dtd/xsd of the xmls we build (actions, widgets, reports, etc). It would ease development and verification. The only one I found scattered around was mondrian.xml (and it's very handy to develop with it )

The schema files can be found inside the pentaho-reporting-jar file (package org.jfree.report.module.parser.simple.resources and org.jfree.report.modules.parser.ext.resources). Once 0.8.9 is declared stable (means, we do not extend the schema anymore), these schema files will be downloadable from the "reporting.pentaho.org" site as well as from the "jfreereport.sourceforge.net" site.

If a report that worked in the old days does no longer work with a newer version, then this is clearly a bug. The API may happily change, but the XML format will (*should*) never break the backward compatibility. Tell us all about it. What tags did you have to change? File a bug report at jira.pentaho.org so that we are aware of our mess. If you dont tell us, we cant fix it.

Have fun,
said Thomas

PS: Downgrading the report-jar will exclude you from all bugfixes that went in afterwards. So this is definitely not a long-term option.

pmalves
08-14-2007, 08:48 AM
Tell us all about it. What tags did you have to change?

It was not on a report file. I had some problems on the xaction files, cause the plugin generated an output type as an attribute where in 1.6 it should be a child element.

And you are right, I also have the reports schema, its not only the mondrian one, sorry for the mistake :)