Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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