topic Re: Issue in Binary load in QlikView

Issue in Binary load

Anonymous — Fri, 08 Sep 2017 08:07:14 GMT

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

Re: Issue in Binary load

vinieme12 — Fri, 08 Sep 2017 08:18:26 GMT

"so binary load is also not working can any one help me in this"

Can you post a screenshot of the Error Message?

Re: Issue in Binary load

vinieme12 — Fri, 08 Sep 2017 08:21:23 GMT

I think you have a hidden script in your QVW,

You must place the Binary load statement in that hidden script.

Remember Binary load has to be the very first line

Re: Issue in Binary load

Anonymous — Fri, 08 Sep 2017 08:22:38 GMT

hi Vineeth i am getting this error now and binary load image is already inserted.Can you help me in this

Re: Issue in Binary load

its_anandrjs — Fri, 08 Sep 2017 08:25:17 GMT

Check your load scripts

Conditions for the Binary Load Statement

1. Binary Load statement should be places on the top of the SET variable expression in QVW script.

Ex:- Binary C:\SalesApp.qvw;

2. Check your Exit Script statement will it be on right place or not.

Re: Issue in Binary load

its_anandrjs — Fri, 08 Sep 2017 08:27:33 GMT

If reading the LOG you have error on the line 0591 with again you are using Binary Load. You have to place it before SET expression.

Re: Issue in Binary load

jonathandienst — Fri, 08 Sep 2017 08:36:40 GMT

If you simply need a small part of the other model's data, I would create a qvd containing the relevant information when loading the source model. Then this model would simply read the qvd in the normal way.

Re: Issue in Binary load

vinieme12 — Fri, 08 Sep 2017 08:37:06 GMT

I was asking for the script load progress dialog screenshot.

anyways few things to note

1) Binary load has to be the very first line

2) You can only have one Binary Load in a QVW

if you are clear of these two things there will be no errors

Re: Issue in Binary load

omkarvamsi — Fri, 08 Sep 2017 08:50:33 GMT

binary load will not work for the app when the "prohibit binary load " option is enabled in the application which is to be binary loaded into another.

check for the option in document settings->opening->prohibit binary load

Re: Issue in Binary load

afsarshaikh — Fri, 08 Sep 2017 09:00:04 GMT

I hope you have placed Binary statement at very beginning in the script editor. If not then, place it before the very beginning of any other statement.

Secondly, Could you please rename your [model - speicher analyse.qvw] without any space like [model_speicher_analyse.qvw] and try again?

Binary ;

Re: Issue in Binary load

jmvilaplanap — Fri, 08 Sep 2017 10:32:13 GMT

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

Re: Issue in Binary load

Anonymous — Fri, 08 Sep 2017 11:30:20 GMT

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??

Re: Issue in Binary load

prieper — Fri, 08 Sep 2017 12:11:10 GMT

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

Re: Issue in Binary load

Anonymous — Fri, 08 Sep 2017 12:46:34 GMT

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

Re: Issue in Binary load

vishsaggi — Fri, 08 Sep 2017 12:52:11 GMT

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.

Re: Issue in Binary load

prieper — Fri, 08 Sep 2017 12:53:31 GMT

Does the table "TW" really exist?

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

Re: Issue in Binary load

Anonymous — Fri, 08 Sep 2017 12:59:32 GMT

hi Peter,

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

Re: Issue in Binary load

Anonymous — Fri, 08 Sep 2017 13:00:16 GMT

hi Vishwarath,

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

Re: Issue in Binary load

prieper — Fri, 08 Sep 2017 13:41:33 GMT

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

Re: Issue in Binary load

vvvvvvizard — Fri, 08 Sep 2017 14:11:27 GMT

If the model has section access binay load wont work