Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III

Field not found in QV

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;

 

11 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vireshkolagimat
Creator III
Creator III
Author

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

tresesco
MVP
MVP

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.

florentina_doga
Partner - Creator III
Partner - Creator III

SQL SELECT

*

FROM APPS.XXEGC_QV_SALES_HISTORY_V;

store in qvd

and verify fields

 

 
 
 
avinashelite

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 

Josh_Berg_Support

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
vireshkolagimat
Creator III
Creator III
Author

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

Chanty4u
MVP
MVP

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

or

load separate query itself in new qvw?
ashwanin
Specialist
Specialist

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>