Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: SQLeonardo

  1. #1
    Join Date
    Jun 2009

    Default SQLeonardo

    In the SQLeonardo aspect of Report Designer, when trying to "preview" a query, nothing is displaying when I press the button. Outside of selecting fields in tables and linking the tables, is there anything else that needs to be done for this to work?

    Also, when I exit SQLeonardo and press 'ok' to get out of the configure window, I get an Oracle error for table not found. However, the tables are there.


  2. #2
    Join Date
    Aug 2008

    Default Give more

    Please post errors more details

  3. #3
    Join Date
    Oct 2006

    Default Query

    It could be that you SQL syntax is not correct.

    Ive seen this sort of problem before if you do not group by and order by correctly. Its woth noting that MySQL will order by the group (by default) as far as i remember - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on in the ##pentaho channel

  4. #4
    Join Date
    Jun 2009


    For the query, I am just letting SQLeonardo develop the query. I'm not modifying it at all.

    After I exit SQLeonardo and try to try to 'OK' the configuration, I get the attached error message below.
    Attached Files Attached Files

  5. #5
    pstoellberger Guest


    most probably you have chosen a different schema than the default one (of the user you are connecting with) in SQLeonardo. the query editor doesn't mind that then but if you want to execute this query you're gonna need to put the schema name in front of your table names


    select * from SCHEMA_NAME.TABLE_NAME

  6. #6
    Join Date
    Jun 2006


    Cany anyone explain to me why SQLeonardo restricts to a single Schema? In very early versions of PRD like 1.1 it used to let you use all available schemas. Maybe it had somthing to do with syntactical problems when trying to qualify schema.table for specific DB's? I personally don't use SL but some of our less technical report writers would like to use it and find SL to be a PIA.
    "If you want to increase your success rate, double your failure rate."
    Thomas Watson, Sr (former president of IBM)

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.