Milestone 5 Testing 7/12 - 7/20

**dmoran** · 07-12-2007, 10:50 AM

Milestone 5 is now available!
After about 3 weeks of community testing, and bug fixing we are ready for another big push through metadata, the metadata editor and web based query and reporting. Since milestone 4, about 175 JIRA cases have been resolved! The metadata editor is feature complete and seems pretty solid.

The 0.8.9 pre-release 1 version of the report engine has been put in and should address many of the issues we had with the 0.8.8 version breaking things. The pre release 2 is due on 7/13 and we expect another engine toward the end of the month. Currently reporting is fragile, especially in the report designer and report design wizard. They are our top priority right now.

Please post any comments about stability and whether it meets your needs. We need this kind of feedback as early as possible. Please report any issues or comments by replying to this thread. Include the platform, operating system, database, browser and any other configuration information that may be important. We have some use cases for you to try:

http://wiki.pentaho.org/display/PEOp...e+Descriptions

We really need to have more use cases. Please submit use cases for metadata and the platform to the forums and we will include them. Complete task use use-cases would be great and will help drive out any requirements deficiencies.

The testing instructions for now are the same as for the last few weeks. For this phase of testing we assume that you are a knowledgeable Pentaho user and are comfortable with downloading and installing the platform and components. This is not meant to be a test script but an outline to get you started using metadata and begin to get feedback on the documentation and user experience.

Refer to the FAQ and 1.6 Testing Home page for questions and resources.

* Download and install the Milestone 5 platform: Milestone 5 version 1.5.5
* Start the platform (refer to the Getting Started with the BI Platform guide)
* Use your browser and try the samples to verify you are configured correctly (Default URL is http://localhost:8080/pentaho)
* Verify that web based query and reporting is working by selecting "New Report" from the "Go" menu item. Drag and drop a few items and press the "Go" button at the bottom to preview.
* If you were successful - great! Otherwise verify the above steps and if all else fails, reply to this post for help.
* Now the fun part, download the Pentaho Metadata Editor - PME M5 1.5.5
* Install the Pentaho Metadata Editor by following the documentation. Chapter 02 has the installation instructions.
* Follow the documentation to build metadata on top of your own data and publish to the platform.
* Give your feedback
* Test your current solutions, actions, reports, etc. to make sure that they still work as expected in this new release.

**rmazili** · 07-16-2007, 09:20 AM

Hello,

I used the metadata editor in the previous release, what I'll tell you now is only my option.
Web based query and report with metadata have no very utility, because when you save a adhoc report, it's static, I guess that's wrong way to do it. It will be very better if the adhoc report ware saved as .xaction, so the report will be dinamic every time that it runs.
Another thing, the adhoc reports must be saved into a private directory, each user needs have one.

(Sorry for poor english)

Thank you

**cedric claidiere** · 07-16-2007, 11:19 AM

Do : Unzip + Launch

Windows XP SP 2

BUG BISERVER-38 : WAQ&R
Note : without a internet connection -> seems to be the problem
Level : 4 severe
Description :
Logged as Joe
On sample data I choose
BC_CUSTOMERS_COUNTRY - Group Level 1
BC_CUSTOMERS_CUSTOMERNUMBER -> detail -> center
BC_CUSTOMERS_PHONE -> detail
BC_ORDER_DETAILS_PRICEEACH -> detail -> formating "$ 1,234; ($ 1,234)
Add Constraint : BC_ORDER_DETAILS_PRICEEACH > 0
I obtain nothing in the browser.
LOG :

Code:

17:16:14,734 ERROR [SolutionRepositoryBase] SOLUTION-REPOSITORY: SOLREPO.ERROR_0006 - Resource not found: /system/waqr/t
emplates//jfreereport-template.xml
17:16:22,593 ERROR [STDERR] java.lang.Exception: Stack trace
17:16:22,609 ERROR [STDERR]     at java.lang.Thread.dumpStack(Thread.java:1064)
17:16:22,609 ERROR [STDERR]     at org.pentaho.core.repository.SolutionRepositoryBase.getResourceInputStream(SolutionRep
ositoryBase.java:214)
17:16:22,609 ERROR [STDERR]     at org.pentaho.core.repository.SolutionRepositoryBase.getResourceAsBytes(SolutionReposit
oryBase.java:361)
17:16:22,625 ERROR [STDERR]     at org.pentaho.core.repository.SolutionRepositoryBase.getResourceAsDocument(SolutionRepo
sitoryBase.java:396)
17:16:22,625 ERROR [STDERR]     at org.pentaho.core.repository.SolutionRepositoryBase.getResourceAsDocument(SolutionRepo
sitoryBase.java:391)
17:16:22,625 ERROR [STDERR]     at org.pentaho.ui.servlet.AdhocWebService.createJFreeReportFile(AdhocWebService.java:411
)
17:16:22,625 ERROR [STDERR]     at org.pentaho.ui.servlet.AdhocWebService.generatePreview(AdhocWebService.java:331)
17:16:22,625 ERROR [STDERR]     at org.pentaho.ui.servlet.AdhocWebService.dispatch(AdhocWebService.java:241)
17:16:22,625 ERROR [STDERR]     at org.pentaho.ui.servlet.AdhocWebService.doGet(AdhocWebService.java:203)
17:16:22,625 ERROR [STDERR]     at org.pentaho.ui.servlet.AdhocWebService.doPost(AdhocWebService.java:277)
17:16:22,625 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
17:16:22,625 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:16:22,625 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:252)
17:16:22,625 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:264)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterc
eptor.java:107)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInte
rceptor.java:72)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.j
ava:110)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcess
ingFilter.java:335)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:71)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousPro
cessingFilter.java:125)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcess
ingFilter.java:142)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAu
thenticationFilter.java:160)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.j
ava:178)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:
217)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetecti
onFilter.java:142)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionCon
textIntegrationFilter.java:193)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,625 ERROR [STDERR]     at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityCo
ntextHolderAwareRequestFilter.java:81)
17:16:22,640 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.
java:274)
17:16:22,640 ERROR [STDERR]     at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
17:16:22,640 ERROR [STDERR]     at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:202)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
17:16:22,640 ERROR [STDERR]     at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:202)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
17:16:22,640 ERROR [STDERR]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:202)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
173)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
17:16:22,640 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValv
e.java:175)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432
)
17:16:22,640 ERROR [STDERR]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
17:16:22,640 ERROR [STDERR]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
17:16:22,640 ERROR [STDERR]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
17:16:22,640 ERROR [STDERR]     at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
17:16:22,640 ERROR [STDERR]     at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
17:16:22,640 ERROR [STDERR]     at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:1
12)
17:16:22,640 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:534)
17:16:22,640 ERROR [SolutionRepositoryBase] SOLUTION-REPOSITORY: SOLREPO.ERROR_0006 - Resource not found: C:\Documents a
nd Settings\Cedric\Bureau\Pentaho\pentaho_demo-1.5.5.747-0\pentaho-demo\pentaho-solutions\/system/waqr/templates//jfreer
eport-template.xml
17:16:22,640 ERROR [AdhocWebService] HttpWebService.ERROR_0001 - Erreur lors de l'exÚcution du web service
java.io.FileNotFoundException: SOLREPO.ERROR_0006 - Resource not found: C:\Documents and Settings\Cedric\Bureau\Pentaho\
pentaho_demo-1.5.5.747-0\pentaho-demo\pentaho-solutions\/system/waqr/templates//jfreereport-template.xml
        at org.pentaho.core.repository.SolutionRepositoryBase.getResourceInputStream(SolutionRepositoryBase.java:233)
        at org.pentaho.core.repository.SolutionRepositoryBase.getResourceAsBytes(SolutionRepositoryBase.java:361)
        at org.pentaho.core.repository.SolutionRepositoryBase.getResourceAsDocument(SolutionRepositoryBase.java:396)
        at org.pentaho.core.repository.SolutionRepositoryBase.getResourceAsDocument(SolutionRepositoryBase.java:391)
        at org.pentaho.ui.servlet.AdhocWebService.createJFreeReportFile(AdhocWebService.java:411)
        at org.pentaho.ui.servlet.AdhocWebService.generatePreview(AdhocWebService.java:331)
        at org.pentaho.ui.servlet.AdhocWebService.dispatch(AdhocWebService.java:241)
        at org.pentaho.ui.servlet.AdhocWebService.doGet(AdhocWebService.java:203)
        at org.pentaho.ui.servlet.AdhocWebService.doPost(AdhocWebService.java:277)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
        at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
        at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:71)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:
160)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:142)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.ja
va:193)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestF
ilter.java:81)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java
:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
        at java.lang.Thread.run(Thread.java:534)

**dkincade** · 07-17-2007, 11:33 AM

Cedric,

Thank you for your testing and finding an interesting issue.

I reproduced your error with WAQ&R using 1.5.5. I was able to do this while still connected to the internet.

While this issue has been fixed since the 1.5.5 release, there is a work-around. On Step 1 of the WAQ&R, select a template (this error is caused by not having a template selected).

However, once you select a template and try again, you will receive a 2nd error with the SQL that is generated. I am entering this as a bug (that has not been fixed). -- This is entered as BISERVER-94

David

**cedric claidiere** · 07-19-2007, 03:42 AM

Hello,

Hello,

On PRD 1.5.5
Do : Unzip + Launch

Windows XP SP 2

BUG 1 : Compatibility problem
Note :
Level : 4 severe
Description :
When I reopen my .report created by the 1.2.0.219-RC2 Pentaho Report Designer, it deletes my SQL request (when I click on configure)
For our customers we absolutely need the versions to be compatible from 1.2.1 to 1.6 !

BUG 2 : Saved Properties
Note :
Level : 5 severe
Description :
When I save my report with properties which didn't have any default values it delete my properties. If I put default values it doesn't delete them.

Best Regards

Cédric

PS: Would you prefer that I directly post into Jira ?

**cedric claidiere** · 07-20-2007, 04:08 AM

Hello,

On PMD 1.5.5
Do : Unzip + Launch

Windows XP SP 2

Feature Request
Note :
Level : 1 LOW
Description :
On PMD it would be nice if we can do a mutiple-selection on "Business Table Properties" window to delete columns more than one to one, (a feature request like the PMD-44)

Cedric