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>
There is no way which we need to think, Only thing check whether you have given correct format. Load only one field and test.
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.
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?