Échec de lecture OLEDB

[master_student]

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?

[Anil_Babu_Samineni]

What do you want to achieve?

[master_student]

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

Thanks

[andrespa]

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

[Anil_Babu_Samineni]

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

[master_student]

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');

[Anil_Babu_Samineni]

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

[master_student]

will try and let you know.

Thanks

[master_student]

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

[Anil_Babu_Samineni]

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