Failed to read OLEDB

[master_student]

Hello everyone,

I try to execute this query in QlikView but I get an 'Échec de lecture OLEDB' error :

PS : this query works on TOAD

select tt.*, d.aliasname

from (

SELECT

REPORT_TYPE,

REPORT_DATE,

TRANSAC_ID,

DEBITED_ACTOR_ID,

CREDIT_ACTOR_ID,

credit,

tab.ALIASNAME

FROM   POS_REPORT_FINAL_1904 trans , DUMP_RETAILER_FINAL tab

WHERE 

trans.debited_ACTOR_ID =tab.ACTORE_ID(+)

and report_type = 'TSR001'

AND function_id = 243

and debited_actor_id IN ('1018796','1080716')

AND OPER_STATE = 61

AND IERRORX = 0)  tt, DUMP_RETAILER_FINAL d

where

credit_ACTOR_ID =d.ACTORE_ID(+);

[Marcio_Campestrini · Accepted solution]

Hello

Your query generaes two columns with the same name (ALIASNAME from the inside query and from table DUMP_RETAILER_FINAL. Toad renames the second column automatically, but Qlikview don't. You need to change the name of one of them.

[Kushal_Chawda]

try

FROM   databasename.schemaname.POS_REPORT_FINAL_1904 trans , databasename.schemaname.DUMP_RETAILER_FINAL tab

[master_student]

Thanks Marcio. You are right.