Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Design Studio not picking up JNDI name

  1. #1
    Join Date
    May 2009
    Posts
    7

    Exclamation Design Studio not picking up JNDI name

    hello
    i have started the entrprise server and console and later started the designstudio .

    after adding the process action olap the pentaho design studio is not displaying the jndi data sources


    regards

    there is an error in start enterprise console window

    16:58:22,237 ERROR [ThreadSafeHttpClient] ThreadSafeHttpClient.ERROR_0001 - Clie
    nt request for URI "http://localhost:18080/pentaho//ping/alive.gif?requestedMime
    Type=text%2Fxml" failed. Reason for failure: HTTP/1.1 404 /pentaho//ping/alive.g
    if.


    the code of example.xaction is like this
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence> 
      <title>Sales Dashboard</title>
      <version>1</version>
      <logging-level>ERROR</logging-level>
      <documentation> 
        <author/>  
        <description>Empty blank action sequence document</description>  
        <help/>  
        <result-type/>  
        <icon/> 
      </documentation>
    
      <inputs> 
        <chartWidth type="string"> 
          <sources> 
            <request>chartWidth</request> 
          </sources>  
          <default-value><![CDATA[600]]></default-value> 
        </chartWidth>  
        <chartHeight type="string"> 
          <sources> 
            <request>chartHeight</request> 
          </sources>  
          <default-value><![CDATA[300]]></default-value> 
        </chartHeight> 
      </inputs>
    
      <outputs> 
        <html_fragment type="string"> 
          <destinations> 
            <response>Content</response> 
          </destinations> 
        </html_fragment> 
      </outputs>
    
      <resources> 
        <chart_Template> 
          <solution-file> 
            <location>C:\Program Files\pentaho\design-tools\design-studio\workspace\Example\SalesExample.txt</location>  
            <mime-type>text/plain</mime-type> 
          </solution-file> 
        </chart_Template>  
        <catalog1>
          <file>
            <location>C:\Documents and Settings\kvelamuri\My Documents\Schema5.xml</location>
            <mime-type>text/plain</mime-type>
          </file>
        </catalog1>
      </resources>
      
      <actions> 
        <action-definition> 
          <action-type>Open Flash Chart</action-type>
          <action-inputs> 
            <!--<query-results type="result-set" mapping="query_result"/>  -->  
            <chartHeight type="string"/>  
            <chartWidth type="string"/> 
          </action-inputs>
          <action-resources> 
            <chart_Template type="resource"/> 
          </action-resources>
          <action-outputs> 
            <html_fragment type="string"/> 
          </action-outputs>
          <component-definition> 
            <component-name>com.google.code.pentahoflashcharts.OpenFlashChartComponent</component-name> 
          </component-definition> 
        </action-definition>
      
        <action-definition> 
          <component-name>MDXLookupRule</component-name>
          <action-type>OLAP</action-type>
          <action-resources>
            <catalog mapping="catalog1"/>
          </action-resources>
          <action-outputs> 
            <query-results type="result-set" mapping="query_result"/> 
          </action-outputs>
          <component-definition> 
            <location><![CDATA[mondrian]]></location>  
            <query><![CDATA[select NON EMPTY Crossjoin({[StoreDimension1.AllStores].[AllStores].[100], [StoreDimension1.AllStores].[AllStores].[200]},{[Measures].[Sales]} ) ON COLUMNS,
      NON EMPTY Crossjoin([LocationDimension1.AllLocations].[AllLocations].Children, {[Year.AllYears].[AllYears]}) ON ROWS
    from [SalesAnalysis1]]]></query>  
            <jndi><![CDATA[salesmysql]]></jndi> 
          </component-definition> 
        </action-definition>
     
      </actions> 
    </action-sequence>
    also the error throwing up is attached as a document.

    please reply at the earliest
    Attached Files Attached Files
    Last edited by kalyanv; 06-10-2009 at 06:50 AM.

  2. #2
    Join Date
    May 2009
    Posts
    7

    Default fixed the earlier error,new error propped up-!Help

    the code in the xml file was incorrect

    i fixed the code

    now a new error has propped up

    Code:
    15:25:16,764 ERROR [OpenFlashChartComponent] Error Start: Pentaho Pentaho Platform Core 3.0.0-GA.37228
    15:25:16,795 ERROR [OpenFlashChartComponent] 9cc050f8-5992-11de-a1a2-fde1f7c30dd5:COMPONENT:context-5560925-1245059709842:Example.xactionBase.ERROR_0002 - Component execution failed
    java.lang.NoSuchMethodError: org.pentaho.platform.engine.core.system.PentahoSystem.getSolutionRepository(Lorg/pentaho/platform/api/engine/IPentahoSession;)Lorg/pentaho/platform/api/repository/ISolutionRepository;
        at com.google.code.pentahoflashcharts.OpenFlashChartComponent.executeAction(OpenFlashChartComponent.java:159)
        at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:461)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1322)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1289)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1207)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1156)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1036)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:929)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
        at com.pentaho.core.solution.EnhancedAuditingSolutionEngine.execute(SourceFile:113)
        at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
        at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:148)
        at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:275)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
        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:275)
        at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:595)
    15:25:16,795 ERROR [OpenFlashChartComponent] Error end:
    15:25:16,795 ERROR [RuntimeContext] 9cc050f8-5992-11de-a1a2-fde1f7c30dd5:RUNTIME:context-5560925-1245059709842:Example.xaction RuntimeContext.ERROR_0012 - ActionDefinition for com.google.code.pentahoflashcharts.OpenFlashChartComponent did not execute successfully
    15:25:17,295 ERROR [EnhancedAuditingSolutionEngine] 9cc050f8-5992-11de-a1a2-fde1f7c30dd5:SOLUTION-ENGINE:Example.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed
    please help urgently


    Quote Originally Posted by kalyanv View Post
    hello
    i have started the entrprise server and console and later started the designstudio .

    after adding the process action olap the pentaho design studio is not displaying the jndi data sources


    regards

    there is an error in start enterprise console window

    16:58:22,237 ERROR [ThreadSafeHttpClient] ThreadSafeHttpClient.ERROR_0001 - Clie
    nt request for URI "http://localhost:18080/pentaho//ping/alive.gif?requestedMime
    Type=text%2Fxml" failed. Reason for failure: HTTP/1.1 404 /pentaho//ping/alive.g
    if.


    the code of example.xaction is like this
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence> 
      <title>Sales Dashboard</title>
      <version>1</version>
      <logging-level>ERROR</logging-level>
      <documentation> 
        <author/>  
        <description>Empty blank action sequence document</description>  
        <help/>  
        <result-type/>  
        <icon/> 
      </documentation>
    
      <inputs> 
        <chartWidth type="string"> 
          <sources> 
            <request>chartWidth</request> 
          </sources>  
          <default-value><![CDATA[600]]></default-value> 
        </chartWidth>  
        <chartHeight type="string"> 
          <sources> 
            <request>chartHeight</request> 
          </sources>  
          <default-value><![CDATA[300]]></default-value> 
        </chartHeight> 
      </inputs>
    
      <outputs> 
        <html_fragment type="string"> 
          <destinations> 
            <response>Content</response> 
          </destinations> 
        </html_fragment> 
      </outputs>
    
      <resources> 
        <chart_Template> 
          <solution-file> 
            <location>C:\Program Files\pentaho\design-tools\design-studio\workspace\Example\SalesExample.txt</location>  
            <mime-type>text/plain</mime-type> 
          </solution-file> 
        </chart_Template>  
        <catalog1>
          <file>
            <location>C:\Documents and Settings\kvelamuri\My Documents\Schema5.xml</location>
            <mime-type>text/plain</mime-type>
          </file>
        </catalog1>
      </resources>
      
      <actions> 
        <action-definition> 
          <action-type>Open Flash Chart</action-type>
          <action-inputs> 
            <!--<query-results type="result-set" mapping="query_result"/>  -->  
            <chartHeight type="string"/>  
            <chartWidth type="string"/> 
          </action-inputs>
          <action-resources> 
            <chart_Template type="resource"/> 
          </action-resources>
          <action-outputs> 
            <html_fragment type="string"/> 
          </action-outputs>
          <component-definition> 
            <component-name>com.google.code.pentahoflashcharts.OpenFlashChartComponent</component-name> 
          </component-definition> 
        </action-definition>
      
        <action-definition> 
          <component-name>MDXLookupRule</component-name>
          <action-type>OLAP</action-type>
          <action-resources>
            <catalog mapping="catalog1"/>
          </action-resources>
          <action-outputs> 
            <query-results type="result-set" mapping="query_result"/> 
          </action-outputs>
          <component-definition> 
            <location><![CDATA[mondrian]]></location>  
            <query><![CDATA[select NON EMPTY Crossjoin({[StoreDimension1.AllStores].[AllStores].[100], [StoreDimension1.AllStores].[AllStores].[200]},{[Measures].[Sales]} ) ON COLUMNS,
      NON EMPTY Crossjoin([LocationDimension1.AllLocations].[AllLocations].Children, {[Year.AllYears].[AllYears]}) ON ROWS
    from [SalesAnalysis1]]]></query>  
            <jndi><![CDATA[salesmysql]]></jndi> 
          </component-definition> 
        </action-definition>
     
      </actions> 
    </action-sequence>
    also the error throwing up is attached as a document.

    please reply at the earliest

  3. #3
    Join Date
    May 2009
    Posts
    7

    Default fixed second error also

    i have fixed the second error also by changing from
    open flash chart to bar chart

    now the bars are not displayed but columns headings are displayed.

    the latest xaction code
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence> 
      <title>Sales Dashboard</title>
      <version>1</version>
      <logging-level>WARN</logging-level>
      <documentation> 
        <author/>  
        <description>Empty blank action sequence document</description>  
        <help/>  
        <result-type/>  
        <icon/> 
      </documentation>
    
      <inputs> 
        <chart-type type="string"> 
          <default-value>.png</default-value>  
          <sources> 
            <request>type</request> 
          </sources> 
        </chart-type>  
        <chartWidth type="string"> 
          <sources> 
            <request>chartWidth</request> 
          </sources>  
          <default-value><![CDATA[1200]]></default-value> 
        </chartWidth>  
        <chartHeight type="string"> 
          <sources> 
            <request>chartHeight</request> 
          </sources>  
          <default-value><![CDATA[600]]></default-value> 
        </chartHeight> 
      </inputs>
    
      <outputs> 
        <query_result type="result-set"> 
          <destinations> 
            <global>query_result</global> 
          </destinations> 
        </query_result> 
      </outputs>
    
      <resources> 
        <chart_template> 
          <solution-file> 
            <location>C:\Program Files\pentaho\design-tools\design-studio\workspace\Example\SalesExample.txt</location>  
            <mime-type>text/plain</mime-type> 
          </solution-file> 
        </chart_template>  
        <catalog1> 
          <file> 
            <location>C:\Documents and Settings\kvelamuri\My Documents\Schema5.xml</location>  
            <mime-type>text/plain</mime-type> 
          </file> 
        </catalog1> 
      </resources>
      
      <actions> 
        <action-definition> 
          <component-name>MDXLookupRule</component-name>
          <action-type>OLAP</action-type>
          <action-resources> 
            <catalog mapping="catalog1"/> 
          </action-resources>
          <action-outputs> 
            <query-result type="result-set" mapping="query_result"/> 
          </action-outputs>
          <component-definition> 
            <location><![CDATA[mondrian]]></location>  
            <jndi><![CDATA[salesmysql]]></jndi>  
            <live><![CDATA[true]]></live>  
            <query><![CDATA[select NON EMPTY Crossjoin({[StoreDimension1.AllStores].[AllStores].[100], [StoreDimension1.AllStores].[AllStores].[200]},{[Measures].[Sales]} ) ON COLUMNS,
      NON EMPTY Crossjoin([LocationDimension1.AllLocations].[AllLocations].Children, {[Year.AllYears].[AllYears]}) ON ROWS
    from [SalesAnalysis1]]]></query>
          </component-definition> 
        </action-definition>
      
        <action-definition> 
          <component-name>ChartComponent</component-name>
          <action-type>Sales Dashboard</action-type>
          <action-inputs> 
            <chart-data type="result-set" mapping="query_result"/> 
          </action-inputs>
          <component-definition> 
            
            <chart-attributes> 
              <!-- this is the background for the whole image -->  
              <!-- TODO support gradient and texture painting -->  
              <chart-type>BarChart</chart-type>  
              <title-position>TOP</title-position>  
              <by-row><![CDATA[true]]></by-row>  
              <width><![CDATA[600]]></width>  
              <height><![CDATA[300]]></height>  
              <title><![CDATA[Sales Dashboard  of stores in New Yoprk]]></title>  
              <title-font> 
                <font-family>Serif</font-family>  
                <size>36</size>  
                <is-bold>false</is-bold>  
                <is-italic>false</is-italic> 
              </title-font>  
              <range-title>US Dollars</range-title>  
              <chart-background type="color">#FFFFFF</chart-background>  
              <plot-background-color>#FF0000</plot-background-color>  
              <orientation>Vertical</orientation>  
              <is-3D>true</is-3D>  
              <is-stacked>true</is-stacked>  
              <category-label-rotation>0</category-label-rotation>  
              <border-visible>true</border-visible>  
              <border-paint>#3399FF</border-paint>  
              <include-legend>true</include-legend> 
            </chart-attributes> 
          </component-definition> 
        </action-definition>
     
      </actions> 
    </action-sequence>

    also i have attached the jpg screenshot of the sales dashboard view
    Attached Images Attached Images  

Tags for this Thread

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.