ODBC Read Failure errors only in QlikView

Sat, 30 Jan 2010 18:36:22 GMT

I am having some trouble with a select statment in Qlikview. The query runs fine if I run it outside of Qlikview in SQL developer. This is a Oracle database Qlikview is running on a 64bit wnidows 2003 server. Whats odd is that i have muliple queries that use this same join but QlikView throws an error on 2 of my quries

This Fails:



ORDER:
SELECT
 o.COMPANY_CDE,
 o.ORDER_CDE,
 o.REFERENCE_ID,
 o.ORDER_DTE,
 o.PRODUCT_CDE,
 o.CLNT_CDE,
 o.ORDERED_BY,
 o.ENTERED_BY_CDE,
 o.TEAM_CDE,
 o.TEAM_TYPE_CDE,
 o.ASSIGNED_STATUS,
 o.APPT_REQD_FLG,
 o.CLNT_PRICE,
 o.INVOICE_BY,
 o.INVOICE_DTE,
 o.LOAN_AMOUNT,
 o.LOAN_NUMBER,
 o.SCHEDULE_FLG,
 o.INVOICE_FLG,
 o.GRADE_FLG,
 o.STATUSED_FLG,
 o.CANCEL_FLG,
 o.SALES_REP_CDE,
 q.COUNTY_CDE,
 q.STATE_CDE,
 q.VEND_CDE,
 q.COUNTY_CDE,
 q.CITY
FROM VS_ORDER o
 JOIN AP_MS_ATM_QLIKVIEW_ORDERS q on q.ORDER_CDE=o.ORDER_CDE and q.company_cde=o.company_cde ;

 STORE ORDER INTO \\Servicelink.com\slfiles\Development\QlikView\Vision\ATM_Orders.qvd(qvd);

 DROP TABLE ORDER;
[\code]

This runs fine
<pre>
SELECT
DISTINCT
 c.CLNT_CDE,
 c.COMPANY_CDE,
 c.DLY_ORD_SBGRP_CDE,
 c.DLY_ORDER_CDE,
 c.DLY_ORDER_NAME,
 c.LAST_UPDATED,
 c.MARKETING_CDE,
 c.ORDER_WIP_FLG,
 c.PERFORMANCE_CDE,
 c.SCHED_TYPE_CDE,
 c.VERSION,
 c.WATCH_LIST_FLG
FROM VS_CLNT_RPTS c
JOIN AP_MS_ATM_QLIKVIEW_ORDERS q on q.CLNT_CDE=c.CLNT_CDE AND c.COMPANY_CDE= q.company_cde ;
STORE VS_CLNT_RPTS INTO \\Servicelink.com\slfiles\Development\QlikView\Vision\ATM_VS_CLNT_RPTS.qvd(qvd);

 DROP TABLE VS_CLNT_RPTS;
[\code]</body>

topic ODBC Read Failure errors only in QlikView in QlikView

ODBC Read Failure errors only in QlikView