Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
Hi, please check this limitations.
Best Regards.
Tonial.
Neither of those are issues in this particular query/table unfortunately
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"
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
Brilliant! Thank you so much. I've spent days banging my head against the wall.