5 Replies Latest reply: Apr 3, 2014 4:11 PM by Mark campbell RSS

    Direct Discovery Oracle Error (Table doesn't exist

      using sql select, my sql runs just fine.  switching over to direct discovery I am getting oracle errors from the database that the table doesn't exist.  Any ideas what i'm doing wrong?  I'm using an OLEDB connection.

       

      sql select

      acct_system_portf_no,

      sec_source_id,

      portfolio_type,

      base_ccy,

      portfolio_name,

      update_date

      FROM fidb.portfolio_universe;

       

       

      DIRECT QUERY

      dimension

      acct_system_portf_no,

      sec_source_id,

      portfolio_type,

      base_ccy

      measure

      portfolio_name

      detail

      update_date

      FROM fidb.portfolio_universe;

       

      error:

      ErrorSource: OraOLEDB, ErrorMsg: ORA-00942: table or view does not exist

      DIRECT QUERY

      dimension

      acct_system_portf_no,

      sec_source_id,

      portfolio_type,

      base_ccy,

      portfolio_name,

      update_date

      FROM fidb.portfolio_universe

       

      DirectTable << INL43F7 0 lines fetched

      "fidb"."portfolio_universe".acct_system_portf_no (fetching)