I have created a view in Oracle database which is working fine in Oracle. It is huge and it contains 2 million+ rows. I have indexed one column. But I am getting QVX_UNEXPECTED _END_OF _DATA error when I do a simple sql select to load it in the qvd.
I read it some where to use ErrorCode = 0 in the query and I did that it got the error "File has wrong format" which in the image
There are many columns in the view which are create based on calculations and It shows some file format error but
I checked one by one column to see if there some format error happening but qlikview returns all the rows when I apply where clause. I believe this problem of large dataset but however it has returned around 1M rows before. I dont know what is the exact problem.
I have also attached the screen shots. Please comment !! Thank you
Note: Testing is same as SCG_PROCESS_FLOWS_BACK_END_VW