Issues with Binary Load in 9.0 SR1

[#1]

I wanted to check to see if anyone else is having this issue. After we upgraded to 9.0 SR1 from 8.5 we noticed that some of our QlikView apps began a binary reload. What happens is we have various QlikView apps that get refreshed, through publisher, that end up converting to a binary load. When it converts to the binary load statement all of the underlying code in the script disappears. How do I stop my apps from doing binary loads, and how do I recover the underlying code from the apps that continue to reload in binary.

thanks,

rob

[disqr_rm]

Good candidate for QV Support group: http://www.qlik.com/formpage.aspx?id=1500

I have not experience this in QV 9 SR1 though.

[#3]

I Also had an Issue with a particular script, When I edited the code it appeared to be ok but contained a syntax error in the sql statement. When I ran the Code ii failed and after the error message to reload old version any Script following the error statement had dissapeared including following tabs.

Howevr it worked fine After fixing the error in the script. in my case I had //Comment in a sql statement destined for Oracle ...

Colin R

[#4]

I get no errors when my script executes. This worked fine in 8.5 but when we moved to 9.0 SR1 we had some of our scripts automatically convert to binary loads. I had copies of all my apps. I've tried coping over the app with the code in the tabs but it reverts back to binary whenever the job executes (reloads and distributes) in the morning. I'll go into the app and all of my code is gone. The app itself functions fine but I'm unable to edit the script because all of the tabs where i had my code are replaced with 1 tab that simply says "Binary "appname.qvw".

[#5]

set the app to log in doc properties general.

And have a look in the distribution folder for the task. There are some steps at the end that do some file copying as a before and after image with the actual load log pasted in there.

It may be generating a temp binary, executing that, and failing to rename it back propery.

Im Not an expert but its worth a look to see what its doingit may be permission related

Colin

[#6]

I get an error when trying to load from another .qvw. using Binary

Unknown statement
Binary c:\users\guest\documents\qv\ccp\dischem_management_monthly_model.qvw

Any one else seen this?

[jcampbell]

Yes. That will happen when the binary load is not the first line in your load script. If you set the binary load to be the first action on reload it will work fine.

[#8]

I have gone through this topic. as per your suggestion i have used binary command on the top of the edit script.it is working fine.But how will i use this qvw into my worksheet tab?