topic Re: OLEDB read failed message in QlikView

OLEDB read failed message

Wed, 03 May 2017 07:58:56 GMT

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.

Re: OLEDB read failed message

awhitfield — Wed, 03 May 2017 09:50:59 GMT

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

Andy

Re: OLEDB read failed message

rahulpawarb — Wed, 03 May 2017 10:10:28 GMT

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

Re: OLEDB read failed message

Thu, 04 May 2017 05:43:26 GMT

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

Re: OLEDB read failed message

Thu, 04 May 2017 05:45:39 GMT

Not working as required

Re: OLEDB read failed message

rahulpawarb — Thu, 04 May 2017 05:52:23 GMT

What is the current result and expected outcome?

Regards!

Rahul