topic Re: Échec de lecture OLEDB in QlikView

Échec de lecture OLEDB

master_student — Mon, 27 Jun 2016 12:36:13 GMT

Hello,

I get this error when trying to exucute the query bellow :Échec de lecture OLEDB

select tt.*,

d.aliasname as alias_debit

from (

SELECT

trans.*, tab.ALIASNAME alias_credit

FROM RECHARGE_PM.POS_REPORT trans , RECHARGE_PM.DUMP_RETAILER tab

WHERE

trans.credit_ACTOR_ID=tab.ACTORE_ID(+)

AND FUNCTION = 243 ) tt,RECHARGE_PM.DUMP_RETAILER d

where tt.debited_actor_id=d.actore_id(+)

any help please?

Re: Échec de lecture OLEDB

Anil_Babu_Samineni — Mon, 27 Jun 2016 12:51:35 GMT

What do you want to achieve?

Re: Échec de lecture OLEDB

master_student — Mon, 27 Jun 2016 13:29:03 GMT

I didn't creat the query. I am just trying to excute it.

Thanks

Re: Échec de lecture OLEDB

andrespa — Mon, 27 Jun 2016 14:20:37 GMT

Hi, it seems like or your DB is unresponsive at the moment for some reason or that your OLEDB conection has some mistake (bas password, bad DB name, etc)

Hope it helps,

Andrés

Re: Échec de lecture OLEDB

Anil_Babu_Samineni — Mon, 27 Jun 2016 14:22:46 GMT

Can you please send me the snap of your Executing code.

Re: Échec de lecture OLEDB

master_student — Mon, 27 Jun 2016 14:36:26 GMT

Hello guys,

Thanks for your reply,

The connexion works fine and there are more then 3 millions lines executed and then I get this error : see below :

NoConcatenate

transation_tmp:

load

date#(Date( REPORT_DATE, 'DD/MM/YYYY')) as Date_Transaction

;

select tt.*,

d.ALIASNAME as alias_debit

from (

SELECT

trans.*,

tab.ALIASNAME alias_credit

FROM RECHARGE_PM.POS_REPORT trans , RECHARGE_PM.DUMP_RETAILER tab

WHERE

trans.credit_ACTOR_ID=tab.ACTORE_ID(+)

//and report_type = 'TSR001'

//and debited_ACTOR_ID IN ($(vActore))

AND FUNCTION = 243 ) tt,RECHARGE_PM.DUMP_RETAILER d

//AND function_id = 243) tt,RECHARGE_PM.DUMP_RETAILER d

where tt.debited_actor_id=d.actore_id(+)

and tt.REPORT_DATE >= TO_DATE('01/06/2016','DD/MM/YYYY');

Re: Échec de lecture OLEDB

Anil_Babu_Samineni — Mon, 27 Jun 2016 14:47:55 GMT

Try this select tt.*, d.aliasname as alias_debit from ( SELECT trans.*, tab.ALIASNAME alias_credit FROM RECHARGE_PM.POS_REPORT trans inner join RECHARGE_PM.DUMP_RETAILER tab on trans.credit_ACTOR_ID=tab.ACTORE_ID WHERE tab.FUNCTION = 243 ) tt outer join RECHARGE_PM.DUMP_RETAILER d on tt.debited_actor_id=d.actore_id

Re: Échec de lecture OLEDB

master_student — Mon, 27 Jun 2016 18:37:10 GMT

will try and let you know.

Thanks

Re: Échec de lecture OLEDB

master_student — Tue, 28 Jun 2016 07:20:07 GMT

error : ErrorSource: OraOLEDB, ErrorMsg: ORA-00933: SQL command not properly ended

Re: Échec de lecture OLEDB

Anil_Babu_Samineni — Tue, 28 Jun 2016 07:24:28 GMT

NP, ORA-00933 Means Brackets problem only. Check the brackets and try to understand the solution? Note: Clearly showing like SQL command not properly ended - Check that and let me know? - Anil