Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: SQLeonardo

  1. #1
    Join Date
    Jun 2009
    Posts
    17

    Default SQLeonardo

    Hi
    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.

    Paul

  2. #2
    Join Date
    Aug 2008
    Posts
    7

    Default Give more

    Please post errors more details

  3. #3
    Join Date
    Oct 2006
    Posts
    219

    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
    www.ivy-is.co.uk - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on irc.freenode.net in the ##pentaho channel

  4. #4
    Join Date
    Jun 2009
    Posts
    17

    Default

    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

    Default

    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

    like:

    select * from SCHEMA_NAME.TABLE_NAME

  6. #6
    Join Date
    Jun 2006
    Posts
    282

    Default

    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.