Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue in Binary load

Hi all,

I have a requirement in which i have to include the column from other qvw. Any other way to do so apart from Binary load.??Also binary load is also not working can any one help me in this.Please check the logs and snapsot of Binary load

20 Replies
jmvilaplanap
Specialist
Specialist

The Binary Load must  to be the first line in the script and you only can do it once ( I saw that you're doing twice, and the same file)

Also you can check in the previous QVW if the option "prohibited binary load" is checked.

Regards

Anonymous
Not applicable
Author

Hi All,

actually now  binary load is working fine now but the only issue i am facing is this screenshot .The field mentioned is actually there in main application?? Any suggestion why it is not working and giving this error??

Capture44.PNG

prieper
Master II
Master II

might be worth to check for spaces inside TW.WG_SYMBOL

edit: check whether the name of the field is [TW.WG_SYMBOL] or probably [TW.WG_SYMBOL ] or the like

Anonymous
Not applicable
Author

Hi Peter,

Thanks for your suggestion but when I am trying to reload app without binary load it is working fine: but with binary load it is giving error

vishsaggi
Champion III
Champion III

How big are your two apps, can you share your script loads of your current app and also the app you are doing a Binary? It says the field is not defined in table TW which you are doing resident on.

prieper
Master II
Master II

Does the table "TW" really exist?

What, if - for testing - you comment the WHERE-clause out?

Anonymous
Not applicable
Author

hi Peter,

I have attached the qvw file and script of file which is acting as Binary load , Pls check and suggest.

Anonymous
Not applicable
Author

hi Vishwarath,

I have attached the qvw file and script of file which is acting as Binary load , Pls check and suggest.

prieper
Master II
Master II

The error-log is somewhat different from the qvs.

Try to eliminate the brackets in the WHERE-clause

WHERE TW.WG_SYMBOL = '$(vWG_SYMBOL)'

Peter

vvvvvvizard
Partner - Specialist
Partner - Specialist

If the model has section access binay load wont work