topic Re: Direct Discovery Oracle Error (Table doesn't exist in QlikView

Direct Discovery Oracle Error (Table doesn't exist

Wed, 26 Mar 2014 19:43:46 GMT

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)

Re: Direct Discovery Oracle Error (Table doesn't exist

fernando_tonial — Thu, 27 Mar 2014 12:42:59 GMT

Hi, please check this limitations.

Oracle database tables with LONG datatype columns are not supported.
Big integers in scientific notation, outside range [-9007199254740990, 9007199254740991], can cause rounding errors and undefined behavior.

Best Regards.

Tonial.

Re: Direct Discovery Oracle Error (Table doesn't exist

Thu, 27 Mar 2014 14:49:36 GMT

Neither of those are issues in this particular query/table unfortunately

Re: Direct Discovery Oracle Error (Table doesn't exist

Thu, 03 Apr 2014 18:53:09 GMT

I was able to trace the sql queries being generated by QV. How do I remove the " (double quotes) from the query creation?

SELECT DISTINCT "acct_system_portf_no" FROM "portfolio_universe"

Re: Direct Discovery Oracle Error (Table doesn't exist

maxgro — Thu, 03 Apr 2014 19:20:46 GMT

change your sql to uppercase: columns to uppercase, tables to uppercase

I tried direct discovery with my oracle db and I have the same problem (doubel quotes added to the query)

Changed all to uppercase and it works.

You can try with an Oracle tool as sqlplus

select sysdate from dual

select sysdate from "DUAL"

select sysdate from "dual"

first and seconds work

last one doesn't

Re: Direct Discovery Oracle Error (Table doesn't exist

Thu, 03 Apr 2014 20:11:33 GMT

Brilliant! Thank you so much. I've spent days banging my head against the wall.