Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC Read Failure errors only in QlikView

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]
error loading image
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>
0 Replies