OLEDB read failed message

[#1]

Why I am getting the following message

OLEDB read failed

AERO_BILLING_DATA:

SQL SELECT T1.*,T2.*,T3.*

FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL" T1 RIGHT OUTER JOIN AR."RA_CUSTOMER_TRX_ALL" T2 ON T1.CUSTOMER_TRX_ID=T2.CUSTOMER_TRX_ID

RIGHT OUTER JOIN AR."RA_CUSTOMER_TRX_LINES_ALL" T3 ON T1.CUSTOMER_TRX_ID=T3.CUSTOMER_TRX_ID

where TO_CHAR(T1.GL_DATE,'RRRR') >=EXTRACT(YEAR FROM SYSDATE)-4 AND T1.ORG_ID=85 and T1.account_class='REV'

while the above same query is working fine in Sql Developer.

[awhitfield]

Are you sure that you have set up your OLEDB connection correctly?

Andy

[rahulpawarb]

Hello Arshad,

As a workaround, please refer below script:

AERO_BILLING_DATA:
SQL SELECT *
FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL"
WHERE TO_CHAR(GL_DATE,'RRRR') >=EXTRACT(YEAR FROM SYSDATE)-4 AND ORG_ID=85 and account_class='REV';
RIGHT JOIN
RA_CUSTOMER_TRX_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_LINES_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_LINES_ALL";

//OR else you can use below script

tmpAERO_BILLING_DATA:
SQL SELECT *
FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_LINES_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_LINES_ALL";


AERO_BILLING_DATA:
LOAD *
Resident tmpAERO_BILLING_DATA
WHERE YEAR(GL_DATE) >= YEAR(TODAY()) - 4 AND ORG_ID=85 and account_class='REV';


DROP Table tmpAERO_BILLING_DATA;

Hope this will be helpful.

Regards!

Rahul

[#4]

Yes, take a look yourself

Connecting to Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=abcro;Data Source=192.176.0.220/test2:1521;Extended Properties=""

Connected

[#5]

Not working as required

[rahulpawarb]

What is the current result and expected outcome?

Regards!

Rahul