Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
There is no way which we need to think, Only thing check whether you have given correct format. Load only one field and test.
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
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.
SQL SELECT
*
FROM APPS.XXEGC_QV_SALES_HISTORY_V;
store in qvd
and verify fields
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
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
Hi, Please find the attached log file as requested. Thank you.