topic Re: Field not found in QV in QlikView

Field not found in QV

vireshkolagimat — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using the below sql statement to extract the data from the oracle database. At at times i get the error as Field not found. The field is very much available and sometime the query just works fine.

Any suggestions what is going on at the back end?

Below is the query for your reference:

Field not found - <CUSTOMERCODE>
SQL SELECT
CUSTOMERCODE,
WAREHOUSECODE,
WAREHOUSENAME,
ORDER_NUMBER,
PRODUCTCODE,
INVOICENO,
INVOICEDATE,
SALESCOST,
SALESLISTVALUE,
SALESCOMMISSION,
SALESCUSTOMERGROUP,
SALESTERRITORY,
REGIONCODE,
CHANNELCODE,
SALESMANCODE,
ROUTECODE,
SALESUNIT,
SALESUNITFACTOR,
RETURNTYPE,
SALESQTY,
SALESVALUE,
ORDER_TYPE,
ORDER_LINE_ID,
ORDEREDDATE,
CUST_PO_NUMBER,
INV_LAST_UPDATE_DATE
FROM APPS.XXEGC_QV_SALES_HISTORY_V;

Re: Field not found in QV

Anil_Babu_Samineni — Mon, 13 May 2019 12:50:09 GMT

There is no way which we need to think, Only thing check whether you have given correct format. Load only one field and test.

Re: Field not found in QV

vireshkolagimat — Wed, 29 May 2019 06:24:22 GMT

Hi, The task runs daily for every two hours and in between it will fail and in the next schedule it works fine.

Regards,

Viresh

Re: Field not found in QV

tresB — Wed, 29 May 2019 07:06:21 GMT

One reason could be - 'Lock' issue. I.e. - when possibly a data write is being done in the table/field - the table/field might be set to 'locked' state by the dbms - and if one tries to read during that period from the table/field - the read might failed.

Re: Field not found in QV

florentina_doga — Wed, 29 May 2019 06:37:37 GMT

SQL SELECT

FROM APPS.XXEGC_QV_SALES_HISTORY_V;

store in qvd

and verify fields

Re: Field not found in QV

avinashelite — Wed, 29 May 2019 06:41:12 GMT

One more reason would be your table doesn't have any data and post that your referring to that field ...post your complete error log that will help us to check

Re: Field not found in QV

Josh_Berg_Support — Wed, 29 May 2019 16:15:04 GMT

It would be helpful to have your Document log as avenashelite requested. It would be good to have a document log from a successful reload and a failure so we can compare the two. Do you have any other tasks that reference thiese SQL fields and run without issue?

Thanks,
Josh

Qlik Support

Re: Field not found in QV

vireshkolagimat — Sun, 09 Jun 2019 14:02:46 GMT

Hi, Please find the attached log file as requested. Thank you.

Re: Field not found in QV

Chanty4u — Sun, 09 Jun 2019 14:55:10 GMT

can you try without aliasing the field ?
or
is that query running in DB?

or

load separate query itself in new qvw?

Re: Field not found in QV

ashwanin — Mon, 10 Jun 2019 04:32:19 GMT

As per your attached log, its the Division code which was missing

09/06/2019 9:31:54 AM: 0233 where DIVISIONCODE='CA MDC OU' and ORDERNO <> '1404500001' and ORDER_LAST_UPDATE_DATE > trunc(to_date('07/06/2019','DD/MM/YYYY'))
09/06/2019 9:46:57 AM: Error: Field not found - <DIVISIONCODE>

Re: Field not found in QV

vireshkolagimat — Tue, 11 Jun 2019 05:03:22 GMT

Hi, the field divisioncode is available and it runs fine. But sometimes suddenly i start getting this error message.

Thank you.

Re: Field not found in QV

PrashantSangle — Tue, 11 Jun 2019 05:51:05 GMT

are you facing any network drop issue?
AFAIK, This is usually happen if network is drop or as Tresesco Suggested table is locked by some other activity.

Regards,
Prashant Sangle