Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It worked after I changed a value of column in the view. Before the column originally was (column * 1 ) after that I removed multiplication by 1 and now it is working fine. Strange !!
Read this post if it gives any help:
I think this error is thrown by the ODBC driver. May be you are using function that are not able to be translated by the ODBC. Size is not an issue
try to use field name instead of select * and see which field are throwing the error
It worked after I changed a value of column in the view. Before the column originally was (column * 1 ) after that I removed multiplication by 1 and now it is working fine. Strange !!
please mark correct and close the thread