Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Upgrade pentaho bi server version from 3.6 to 5.0.1 Problems!!!!

  1. #1
    Join Date
    Nov 2013
    Posts
    10

    Default Upgrade pentaho bi server version from 3.6 to 5.0.1 Problems!!!!

    Hi!
    I deployed the new bi server war into my tomcat server. I work with :
    Mysql 5,Tomcat 6,Pentaho 5.0.1,Java 7
    I've added configuration of my own datasources, security ldap and cas, and i'm trying to embed reporting with my java gwt project already running on server.
    But when i try to launch a report i found on log the errror above :




    2014-03-11 10:20:41,626 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0002 - Could not get content generator: KPI=XXX&solution=xxx&path=dashboard/general&name=XXX.prpt&locale=%257Blocale%257D&PERIODO=2014-01&COD_CONTRATTO=XXX%202013&CONTRATTO=Contratto%20XXX%202013
    java.lang.NullPointerException
    at org.pentaho.reporting.platform.plugin.ReportContentGenerator.getMimeType(ReportContentGenerator.java:160)
    at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:52)
    at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:88)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:242)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:242)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:242)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:203)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:562)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:108)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:379)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:242)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:259)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:281)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)






    my pentahoObject.spring.xml is configured as follow :


    <bean id="ISolutionEngine" class="org.pentaho.platform.engine.services.solution.SolutionEngine" scope="prototype"/>
    <bean id="ISolutionRepository" class="org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository" scope="session" />
    <bean id="ISolutionRepositoryService" class="org.pentaho.platform.repository.solution.SolutionRepositoryServiceImpl" scope="session" />
    <bean id="IContentRepository" class="org.pentaho.platform.repository.content.ContentRepository" scope="session" />


    <bean id="IUnifiedRepository" class="org.pentaho.platform.repository2.unified.fs.FileSystemBackedUnifiedRepository" scope="prototype" />




    <bean id="IAuditEntry" class="org.pentaho.platform.engine.services.audit.AuditFileEntry" scope="singleton"/>
    <bean id="IUITemplater" class="org.pentaho.platform.web.http.WebTemplateHelper" scope="singleton"/>
    <!-- Concrete implementation of IMetadataDomainRepository -->
    <bean id="IMetadataDomainRepositoryImpl"
    class="org.pentaho.platform.plugin.services.metadata.SecurityAwarePentahoMetadataDomainRepository" scope="singleton">
    <!-- <constructor-arg>
    <ref bean="unifiedRepository"/>
    </constructor-arg> -->
    </bean>
    <!-- Wrap the concrete IMetadataDomainRepository implementation with one that caches domains per session -->
    <!-- <bean id="IMetadataDomainRepository"
    class="org.pentaho.platform.plugin.services.metadata.SessionCachingMetadataDomainRepository" scope="singleton">
    <constructor-arg>
    <ref bean="IMetadataDomainRepositoryImpl"/>
    </constructor-arg>
    </bean> -->
    <!-- <bean id="IMetadataDomainRepository" class="org.pentaho.platform.plugin.services.metadata.SecurityAwarePentahoMetadataDomainRepository" scope="singleton"/> -->
    <!-- Use this schema factory to disable PMD security -->


    <bean id="IUserSettingService" class="org.pentaho.platform.repository.usersettings.UserSettingService">
    <!-- <constructor-arg ref="unifiedRepository"/> -->
    </bean>


    <!-- <bean id="IUserSettingService" class="org.pentaho.platform.repository.usersettings.UserSettingService" scope="session" /> -->
    <bean id="IEmailService" class="org.pentaho.platform.plugin.services.email.EmailService" scope="session"/>
    <bean id="file" class="org.pentaho.platform.plugin.outputs.FileOutputHandler" scope="session"/>
    <bean id="contentrepo" class="org.pentaho.platform.repository.content.ContentRepositoryOutputHandler" scope="session"/>
    <bean id="vfs-ftp" class="org.pentaho.platform.plugin.outputs.ApacheVFSOutputHandler" scope="session"/>
    <bean id="IAclPublisher" class="org.pentaho.platform.engine.security.acls.AclPublisher" scope="singleton"/>
    <bean id="IAclVoter" class="org.pentaho.platform.engine.security.acls.voter.PentahoBasicAclVoter" scope="singleton"/>
    <bean id="IVersionHelper" class="org.pentaho.platform.util.VersionHelper" scope="singleton"/>
    <bean id="ICacheManager" class="org.pentaho.platform.plugin.services.cache.CacheManager" scope="singleton"/>
    <bean id="IScheduler2" class="org.pentaho.platform.scheduler2.quartz.QuartzScheduler" scope="singleton"/>
    <bean id="IBlockoutManager" class="org.pentaho.platform.scheduler2.blockout.PentahoBlockoutManager" scope="singleton"/>
    <bean id="IConditionalExecution" class="org.pentaho.platform.plugin.condition.javascript.ConditionalExecution"
    scope="prototype"/>
    <bean id="IMessageFormatter" class="org.pentaho.platform.engine.services.MessageFormatter" scope="singleton"/>
    <!--
    IDBDatasourceService - options are:
    org.pentaho.platform.engine.services.connection.datasource.dbcp.JndiDatasourceService
    org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService
    org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceService
    org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceService
    org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService (Default option)
    -->
    <bean id="IDatasource"
    class="org.pentaho.platform.repository.datasource.Datasource"
    scope="singleton"/>
    <bean id="IPasswordService" class="org.pentaho.platform.util.Base64PasswordService" scope="singleton"/>
    <bean id="IPluginProvider" class="org.pentaho.platform.plugin.services.pluginmgr.SystemPathXmlPluginProvider"
    scope="singleton"/>




    <bean id="IPluginManager" class="org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager"
    scope="singleton"/>
    <bean id="IPluginResourceLoader" class="org.pentaho.platform.plugin.services.pluginmgr.PluginResourceLoader"
    scope="singleton"/>
    <bean id="IPluginPerspectiveManager"
    class="org.pentaho.platform.plugin.services.pluginmgr.perspective.DefaultPluginPerspectiveManager"
    scope="singleton"/>
    <bean id="IServiceManager" class="org.pentaho.platform.plugin.services.pluginmgr.servicemgr.DefaultServiceManager"
    scope="singleton">
    <property name="serviceTypeManagers">
    <list>
    <ref bean="gwtServiceManager"/>
    <ref bean="axisServiceManager"/>
    </list>
    </property>
    </bean>
    <bean id="ITempFileDeleter" class="org.pentaho.platform.web.http.session.SessionTempFileDeleter" scope="prototype"/>
    <bean id="gwtServiceManager" class="org.pentaho.platform.plugin.services.pluginmgr.servicemgr.GwtRpcServiceManager"
    scope="singleton"/>
    <bean id="axisServiceManager" class="org.pentaho.platform.plugin.services.pluginmgr.servicemgr.AxisWebServiceManager"
    scope="singleton"/>




    <bean id="IChartBeansGenerator" class="org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator"
    scope="singleton"/>




    <bean id="systemStartupSession" class="org.pentaho.platform.engine.security.session.TrustedSystemStartupSession" scope="prototype" />
    <!-- Data connections. Connections objects should be accessed through PentahoConnectionFactory,
    not directly from the PentahoObjectFactory. -->
    <bean id="connection-SQL" class="org.pentaho.platform.plugin.services.connections.sql.SQLConnection"
    scope="prototype">
    <property name="fallBackToNonscrollableOnError" value="true"/>
    </bean>
    <bean id="connection-MDX" class="org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection"
    scope="prototype">
    <property name="useExtendedColumnNames" value="true"/>
    </bean>
    <bean id="connection-MDXOlap4j" class="org.pentaho.platform.plugin.services.connections.mondrian.MDXOlap4jConnection" scope="prototype" />
    <bean id="connection-XML" class="org.pentaho.platform.plugin.services.connections.xquery.XQConnection"
    scope="prototype"/>
    <bean id="connection-HQL" class="org.pentaho.platform.plugin.services.connections.hql.HQLConnection"
    scope="prototype"/>




    <!-- actual bean defined in repository.spring.xml; aliased here -->
    <!-- <alias name="unifiedRepository" alias="IUnifiedRepository"/> -->




    <!-- actual bean defined in repository.spring.xml; aliased here -->
    <!-- <alias name="backingRepositoryLifecycleManager" alias="IBackingRepositoryLifecycleManager"/>-->




    <!-- actual bean defined in repository.spring.xml; aliased here -->
    <!--<alias name="authorizationPolicy" alias="IAuthorizationPolicy"/>-->




    <!-- actual bean defined in repository.spring.xml; aliased here -->
    <!--<alias name="roleAuthorizationPolicyRoleBindingDaoTxn" alias="IRoleAuthorizationPolicyRoleBindingDao"/>-->




    <!-- actual bean defined in applicationContext-pentaho-security-*.xml; aliased here -->
    <!-- <pen:bean id="IUserRoleListService" class="org.pentaho.platform.api.engine.IUserRoleListService">
    <pen:attributes>
    <pen:attr key="providerName" value="${security.provider}"/>
    </pen:attributes>
    <penublish as-type="INTERFACES">
    <pen:attributes>
    <pen:attr key="priority" value="50"/>
    </pen:attributes>
    </penublish>
    </pen:bean>












    <pen:bean id="UserDetailsService" class="org.springframework.security.userdetails.UserDetailsService">
    <pen:attributes>
    <pen:attr key="providerName" value="${security.provider}"/>
    </pen:attributes>
    </pen:bean>-->








    <bean id="ehCacheUserCache" class="org.springframework.security.providers.dao.cache.EhCacheBasedUserCache">
    <property name="cache">
    <bean class="org.springframework.cache.ehcache.EhCacheFactoryBean">
    <property name="cacheManager">
    <bean class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean">
    <property name="shared" value="true"/>
    </bean>
    </property>
    <property name="cacheName" value="userCache"/>
    </bean>
    </property>
    </bean>




    <bean id="cachingUserDetailsService" class="org.pentaho.platform.plugin.services.security.userrole.PentahoCachingUserDetailsService">
    <constructor-arg>
    <ref bean="UserDetailsService"/>
    </constructor-arg>
    <constructor-arg ref="tenantedUserNameUtils"/>
    <property name="userCache" ref="ehCacheUserCache"/>




    <!-- <penublish as-type="INTERFACES">
    <pen:attributes>
    <pen:attr key="priority" value="50"/>
    </pen:attributes>
    </penublish>-->




    </bean>




    <!-- actual bean defined in applicationContext-spring-security.xml; aliased here -->
    <!-- <alias name="authenticationManager" alias="AuthenticationManager"/> -->




    <bean id="IMondrianCatalogService" class="org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper"
    scope="singleton"/>




    <bean id="IDatabaseDialectService" class="org.pentaho.database.service.DatabaseDialectService" scope="singleton"/>




    <bean id="IDatasourceMgmtService" class="org.pentaho.platform.repository.datasource.DatasourceMgmtService" scope="prototype">
    <!-- <constructor-arg ref="unifiedRepository"/>
    <constructor-arg ref="IDatabaseDialectService"/> -->
    </bean>
    <!-- This mondrian user/role mapper assumes that roles from the platform also exist in mondrian -->
    <!--
    Disabled by default in 3.5.2. In trunk, this should be enabled.
    -->
    <bean id="Mondrian-UserRoleMapper"
    name="Mondrian-One-To-One-UserRoleMapper"
    class="org.pentaho.platform.plugin.action.mondrian.mapper.MondrianOneToOneUserRoleListMapper"
    scope="singleton" />
    <!-- <bean id="ReportCache" class="org.pentaho.reporting.platform.plugin.cache.NullReportCache" scope="singleton"/>
    <bean id="PentahoNameGenerator" class="org.pentaho.reporting.platform.plugin.repository.TempDirectoryNameGenerator"
    scope="prototype"/>-->
    <bean id="MondrianConnectionProvider"
    class="org.pentaho.reporting.platform.plugin.connection.PentahoMondrianConnectionProvider" scope="singleton"/>




    <bean id="metadataqueryexec-SQL"
    class="org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec" scope="prototype"/>
    <bean id="sqlGenerator" class="org.pentaho.metadata.query.impl.sql.SqlGenerator" scope="prototype"/>
    <bean id="IThemeManager" class="org.pentaho.platform.web.html.themes.DefaultThemeManager" scope="singleton"/>




    <bean id="ICacheExpirationRegistry" class="org.pentaho.platform.plugin.services.cache.CacheExpirationRegistry"
    scope="singleton"/>


    <bean id="IUserFilesComponent" class="org.pentaho.platform.web.refactor.UserFilesComponent" scope="session" />
    <bean id="IBackgroundExecution" class="org.pentaho.platform.scheduler.SecurityAwareBackgroundExecutionHelper" scope="singleton" />
    <bean id="BackgroundSubscriptionExecution" class="org.pentaho.platform.scheduler.SecurityAwareBackgroundSubscriptionHelper" scope="singleton" />
    <bean id="ISubscriptionRepository" class="org.pentaho.platform.repository.subscription.SubscriptionRepository" scope="singleton" />
    <bean id="ISubscriptionScheduler" class="org.pentaho.platform.scheduler.QuartzSubscriptionScheduler" scope="singleton" />
    <bean id="INavigationComponent" class="org.pentaho.platform.uifoundation.component.xml.NavigationComponent" scope="prototype" />
    <bean id="IVersionCheckDataProvider" class="org.pentaho.platform.plugin.services.versionchecker.PentahoVersionCheckDataProvider" scope="prototype" />
    <bean id="IMenuProvider" class="org.pentaho.platform.web.html.HtmlMenuProvider" scope="singleton" />
    </beans>


    I also have not understand how to set up unifiedRepository, because for resetRepository i use ISolutionRepository.




    Thank's for help me!!!!
    Last edited by alice0812; 03-25-2014 at 10:45 AM.

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Your link is wrong. The URL structure has changed in version 5.0 when we moved from a home-brew repository to the Java Content Repository.

    Have a look at the InfoCentre documentation: http://infocenter.pentaho.com/help/t..._examples.html
    It explains the new format.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Nov 2013
    Posts
    10

    Default

    Thank's a lot for your fast answer to my thread.. but i can't understand how can i make this java content repository 'cause the previous version 3.6 in old project used the ISolutionRepository class declare in pentahoObjectspring.xml and i've a solution folder with all my .prpt files.
    I have a smart gwt application and i want to show my report not with report viewer but only opening a simple popup (as someone have done before with version 3.6).
    I would like to know how i have to configure unifiedRepository in pentahoObjects.spring.xml and how build the url to open file .prpt with the new standard of 5.0.1


    Another thing how can i make a refresh repository? now i'm using old ISolutionRepository to do this reset.


    Sorry but i'm new in pentaho configuration.
    Last edited by alice0812; 03-11-2014 at 10:56 AM.

  4. #4
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    ISolutionRepository is gone, and exists only as a legacy class. In 5.0, you can use the "import-export.bat" file to import an old solution repository into the JCR repository (which lives only in a database, there is no local access to the files stored in the repository). Alternatively, you can import your content directly via the Pentaho User Console (you will need to be admin for that).

    If you made any manual changes to the spring.xml file or implemented your own classes, then you will have to port them to the new code line.

    The Info-Centre contains all documentation about how to configure a Pentaho 5 system.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  5. #5
    Join Date
    Sep 2008
    Posts
    19

    Default

    My issue is I have configures 5.0 for LDAP but none of my users have admin access. I can log in fine using LDAP but I cannot for the life of me work out how to configure security to assign certain users the Administrator role. I have it configured correctly in LDAP but Pentaho 5 is not picking up that role - or is expecting a different role name. Any suggestions?

  6. #6
    Join Date
    Mar 2014
    Posts
    3

    Default

    Hi!

    I have the same problem of Alice0812.

    In fact I haven't succed in upgrading pentaho to the latest version beacuse I have not understand how to set up JCR repository.

    My questions are:

    1) How could i view a report from a java custom application?

    2) If u say before that the link is incorrect , what is the correct way to write it?

    Your link is wrong. The URL structure has changed in version 5.0 when we moved from a home-brew repository to the Java Content Repository.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.