Hitachi Vantara Pentaho Community Forums
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Testing goals for the week of 6/18

  1. #11

    Default Problem with Hello mail samole demo

    Quote Originally Posted by dmoran View Post
    This is the first official week of community testing. We will concentrate on metadata and the metadata editor. 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.

    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 4 platform: Milestone 4 version 1.5.4
    • 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 M4 1.5.4
    • 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.
    i'm using the last milestone of pentaho demo version 1.5.4 and i have problems to send emails (the sample example). i did exctly the same in the file as shown in the file email_config_gmail.xml to configure my gmail parametters(i copied and pasted email_config_gmail.xml in email_config.xml and i added my and my password) but nothing works and i don't know if it is a bug i read many discussions on the forum peaple always say that maybe it is a bug when they upgraded to the version 1.2 and they say the mail works well for the old version 1.0. i don't know exactly if it is a bug or i'm doing something wrong and i need help please.
    the error message which i have is the following:
    FailedError: Email.ERROR_0011 - SMTP send failed: [] - javax.mail.SendFailedException: Sending failed; nested exception is: class javax.mail.MessagingException: Could not connect to SMTP host:, port: 587; nested exception is: Connection timed out: connect ( Starting execute of samples/getting-started/HelloEmail.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=D:\pentaho\pentaho-demo\pentaho-solutions\samples\getting-started\HelloEmail.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter to (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "" to parameter to (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter subject (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "Hello World" to parameter subject (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: audit: instanceId=95e680fb-258d-11dc-ba49-4972f9895280, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
    Debug: validateComponent validating component EmailComponent (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action HelloEmail.xaction (
    Debug: Executing action sequence (org.pentaho.core.runtime.RuntimeContext)
    Debug: Executing action definition: Iteration 0 (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=95e680fb-258d-11dc-ba49-4972f9895280, objectId=EmailComponent, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to DEBUG (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (
    Debug: Execute to=[], (
    Debug: Execute cc=[], bcc=[] (
    Debug: Execute subjectHello World (
    Debug: Execute messagePlainGreetings from the Pentaho BI Platform email component! (
    Debug: Execute messageHtmlnull (
    Error: Email.ERROR_0011 - SMTP send failed: [] - javax.mail.SendFailedException: Sending failed; nested exception is: class javax.mail.MessagingException: Could not connect to SMTP host:, port: 587; nested exception is: Connection timed out: connect (
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Error: RuntimeContext.ERROR_0012 - ActionDefinition for EmailComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=95e680fb-258d-11dc-ba49-4972f9895280, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)

    Server Version 1.2.0 build 534 GA

    Please help
    Thanks in advance!!

  2. #12

    Default Bug on xaction with combo box


    my friend found a bug in xaction when it have a combo box, if the data that will populate the combo box comes from database and the select statement returns only one datum, combo box don't populate, to test it, put a limit 1 on the select statement or put a where clause that will return only one datum and you can see what I'm talking about.

    Sorry for my poor english.


  3. #13
    Join Date
    Apr 2007


    In response to the "Problem with Hello mail samole demo", please see the following message:

  4. #14

    Default Metadata Editor and AS400


    I worked on DB2/AS400 and the PMD didn't seems to works with librairies, so when I greate my Businness view, it create SQL request like "SELECT * FROM ARTI;" which throw an error.
    The correct SQL is : "SELECT * FROM DIVERS.ARTI;"


    Cedric CLAIDIERE

  5. #15
    dmoran Guest



    Logged in JIRA as bug.

  6. #16
    wgorman Guest


    Hi Cedric,

    Our DB2 Expert here pointed me to the JDBC property "currentSchema" which should solve your problem.

    For your example, add ":currentSchema=DIVERS;" to the end of your JDBC driver connection string.

    Here is a link to documentation on various jdbc properties:

    Hope that helps!


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.