Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problem with cube error

  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Post Problem with cube error

    I'm a beginner
    I'm trying to build my first cube because we are evaluating pentaho.
    I created my own cube.


    <?xml version="2.0" encoding="UTF-8"?>
    <Schema name="SampleData">
    <Cube name="Risolutore">
    <Table name="TICKET"/>
    <Dimension name="TICKET">
    <Hierarchy name="TICKET" hasAll="true" allMemberName="All ticket">
    <Table name="TICKET"/>
    <Level name="TICKET.LOCATION" table="TICKET" column="LOCATION" uniqueMembers="false"/>
    </Hierarchy>
    </Dimension>
    <Dimension name="SOTTODOMINIO_TECNOLOGICO" foreignKey="IDSOTDOMTEC">
    <Hierarchy name="SOTTODOMINIO_TECNOLOGICO" hasAll="true" allMemberName="All sottodominio_tecnologico" primaryKey="ID">
    <Table name="SOTTODOMINIO_TECNOLOGICO"/>
    <Level name="SOTTODOMINIO_TECNOLOGICO.DESCR" table="SOTTODOMINIO_TECNOLOGICO" column="DESCR" uniqueMembers="false"/>
    </Hierarchy>
    </Dimension>
    <Dimension name="SOTTODOMINIO_GUASTO" foreignKey="IDSOTDOMGUA">
    <Hierarchy name="SOTTODOMINIO_GUASTO" hasAll="true" allMemberName="All sottodominio_guasto" primaryKey="ID">
    <Table name="SOTTODOMINIO_GUASTO"/>
    <Level name="SOTTODOMINIO_GUASTO.DESCR" table="SOTTODOMINIO_GUASTO" column="DESCR" uniqueMembers="false"/>
    </Hierarchy>
    </Dimension>
    <Measure name="SUM of TICKET.LOCATION" column="LOCATION" aggregator="sum" datatype="String" formatString="#.##0"/>
    </Cube>
    </Schema>

    CREATED MY own XACTION:

    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence>
    <name>Risolutore.xaction</name>
    <title>%title</title>
    <version>1</version>
    <documentation>
    <author>Cube Designer</author>
    <description>%description</description>
    <help>This action-sequence was generated by the Cube Designer. To edit this action-sequence use the Pentaho Design Studio.</help>
    <result-type>report</result-type>
    <icon>slicedice.png</icon>
    </documentation>

    <inputs>
    <mode type="string">
    <default-value/>
    <sources>
    <request>mode</request>
    </sources>
    </mode>
    </inputs>

    <outputs>
    <model type="string"/>
    <connection type="string"/>
    <mdx type="string"/>
    <options type="string"/>
    <title type="string"/>
    <url type="string">
    <destinations>
    <response>redirect</response>
    </destinations>
    </url>
    </outputs>

    <resources/>

    <actions>
    <action-definition>
    <component-name>PivotViewComponent</component-name>
    <action-inputs>
    <mode type="string"/>
    </action-inputs>
    <action-outputs>
    <model type="string"/>
    <connection type="string"/>
    <mdx type="string"/>
    <options type="list"/>
    <title type="string"/>
    <url type="string"/>
    </action-outputs>
    <component-definition>
    <title>Risolutore</title>
    <viewer>Pivot</viewer>
    <model><![CDATA[samples/mia/Risolutore.mondrian.xml]]></model>
    <!--jndi>Wind</jndi-->
    <connection><![CDATA[jdbcracle:thin:@pilot-ubuntu:1521:hibernate]]></connection>
    <location>oracle.jdbc.driver.OracleDriver</location>
    <user-id>wind</user-id>
    <password>wind</password>
    <query>default</query>
    <options>
    <personal/>
    <cube-nav/>
    <mdx-edit/>
    <sort-conf/>
    <level-style/>
    <hide-spans/>
    <properties/>
    <non-empty/>
    <swap-axes/>
    <drill-member/>
    <drill-position/>
    <drill-replace/>
    <drill-thru/>
    <chart/>
    <chart-conf/>
    <print-conf/>
    <print-pdf/>
    <excel/>
    </options>
    </component-definition>
    <action-name>Pivot View</action-name>
    </action-definition>

    </actions>
    </action-sequence>


    AND I RECEIVED THE FOLLOWING ERROR:

    2008-02-25 14:09:51,975 INFO [STDOUT] 14:09:51,975 ERROR [PivotViewComponent] Error Start: Pentaho Pentaho BI Platform 1.7.0.997
    2008-02-25 14:09:51,980 INFO [STDOUT] 14:09:51,977 ERROR [PivotViewComponent] f303c57a-e3a2-11dc-82b3-db5c88590630:COMPONENT:context-24978614-1203944991578:Risolutore.xactionBase.ERROR_0002 - Component execution failed
    java.lang.NullPointerException
    at javax.naming.InitialContext.getURLScheme(InitialContext.java:228)
    at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:277)
    at javax.naming.InitialContext.lookup(InitialContext.java:351)
    at org.pentaho.core.util.DatasourceHelper.getDSBoundName(DatasourceHelper.java:138)
    at org.pentaho.plugin.olap.MondrianModelComponent.getInitialQuery(MondrianModelComponent.java:211)
    at org.pentaho.plugin.olap.PivotViewComponent.executeAction(PivotViewComponent.java:444)
    at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:459)
    at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1133)
    at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1105)
    at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1017)
    at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:972)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:875)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:779)
    at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333)
    at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241)
    at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169)
    at org.apache.jsp.jsp.Pivot_jsp.getRuntimeForQuery(Pivot_jsp.java:75)
    at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:380)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    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:78)
    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:135)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
    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:130)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
    at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
    at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    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.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    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.Http11AprProcessor.process(Http11AprProcessor.java:811)
    at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:632)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
    at java.lang.Thread.run(Thread.java:595)
    2008-02-25 14:09:51,982 INFO [STDOUT] 14:09:51,981 ERROR [PivotViewComponent] Error end:
    2008-02-25 14:09:51,982 INFO [STDOUT] 14:09:51,982 ERROR [RuntimeContext] f303c57a-e3a2-11dc-82b3-db5c88590630:RUNTIME:context-24978614-1203944991578:Risolutore.xaction RuntimeContext.ERROR_0012 - ActionDefinition for PivotViewComponent did not execute successfully


    CAN SOMEONE HELP ME???
    Thank Frank

  2. #2

    Default

    Hello.
    Were you able to solve this problem already? It would help if you specify which version of pentaho BI and Cube Designer you were using, and some detail on how you designed the cube.

    Regards

  3. #3
    Join Date
    Dec 2007
    Posts
    10

    Default PivotViewComponent ERROR_12

    I get this error, I'm running 1.7.0.861 of BI, and Designer. I created my cube with schema workbench. Other than driving me to drink heavily, or more heavily than normal, it's a real nuisance. HELPPP!!!

    F

    Quote Originally Posted by roren View Post
    Hello.
    Were you able to solve this problem already? It would help if you specify which version of pentaho BI and Cube Designer you were using, and some detail on how you designed the cube.

    Regards

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.