Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: AdhocWebService.ERROR_0012

  1. #1

    Default AdhocWebService.ERROR_0012

    Hi,

    I generated a metadata model in Pentaho Metadata Designer 2.0 and, after publishing the metadata to the server, an adhoc report generated the following error:

    org.postgresql.util.PSQLException: ERROR: invalid reference to FROM-clause entry
    for table "fac_objetivo"

    where fac_objetivo is one of my tables.

    Please where can I see the generated SQL? What could cause the generation of a wrong query?

  2. #2

    Default

    I discovered that the Complex join expression has to use the names of the business tables instead of the physical tables, because the generated query uses aliasing.

    Quote Originally Posted by monylulu View Post
    Hi,

    I generated a metadata model in Pentaho Metadata Designer 2.0 and, after publishing the metadata to the server, an adhoc report generated the following error:

    org.postgresql.util.PSQLException: ERROR: invalid reference to FROM-clause entry
    for table "fac_objetivo"

    where fac_objetivo is one of my tables.

    Please where can I see the generated SQL? What could cause the generation of a wrong query?

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.