topic Re: Binary load qvw file with section access in App Development

Binary load qvw file with section access

siddharthsoam — Sat, 16 Nov 2024 20:02:31 GMT

Hi Team,

Hope you are doing well !!

I am unable to binary load qvw file with section access. I am receiving a general error. Tried to binary load after commenting the section access , worked fine.

I have admin access of the qvw file.

Found similar post where it was told that the task was possible.

Re: Binary load qvw file with section access

tresB — Fri, 20 Sep 2019 10:45:05 GMT

Document settings->Opening tab .... uncheck 'Prohibit binary load'

Re: Binary load qvw file with section access

siddharthsoam — Sun, 22 Sep 2019 12:02:19 GMT

Hi Tresesco,

Thanks for the reply !!

The Prohibit binary load is unchecked in the qvw file. I am able to binary load the same app in a new Qlikview application, but not able to achieve the same in the qliksense application.

It works fine once i comment the section access code.

This seems bit weird ..

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Mon, 23 Sep 2019 04:17:59 GMT

binary load must the first statement in your script.

simply put binary load before your section access script!

cheers

Re: Binary load qvw file with section access

siddharthsoam — Mon, 23 Sep 2019 05:47:59 GMT

Hi Lech,

Its the first statement yet its giving me the general error.

We use ntname in the section access code in qvw file. As we use userid in sense, Is there a possibility that when i binary load the qvw file in qliksense , the later is not interpreting it. Hence its showing the general script error.

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Mon, 23 Sep 2019 05:58:22 GMT

Hi,

i think your explanation was not clear enough.

So what you are trying to do is to load QlikView model from qvw file with section access using Binary load into QlikSense application...

To be frank I have never had to do anything like this so will not know correct answer for sure. However you are proabbly right that NTNAME field cannot be recognised hence General script error.

Have you tried loading the model from QVW and doing one of the following:

dropping section access table in load script and recreating it with supported fields in Qlik Sense script,
renaming NTNAME field to USERID in Qlik Sense load script?

Re: Binary load qvw file with section access

siddharthsoam — Mon, 23 Sep 2019 08:00:42 GMT

Hi Lech,

Thanks for the prompt reply !!

Yes it works perfectly when i comment the section access code in qvw file.

Is there a way to achieve this without doing any architectural changes.

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Mon, 23 Sep 2019 08:06:00 GMT

I meant in qlik sense script have you tried anything like....

load binary from xyz.qvw;

rename field NTNAME to USERID;

....

Re: Binary load qvw file with section access

siddharthsoam — Mon, 23 Sep 2019 12:27:39 GMT

Hi Lech,

Its not giving me an error this time but the data model is empty..

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Mon, 23 Sep 2019 12:54:28 GMT

So if there is a data model (there are tables with no data) but it is just empty it means that you need to properly configure section access in qliksense. seems like the user you are using is not configured in section access table.

Or do you mean that there is no data model at all (no tables).

If you would provide more clear descriptions of actions you are taking and screenshots of what you are doing like script, script execution progress, table viewer after reload etc.. it would be much easier to help you...

Re: Binary load qvw file with section access

siddharthsoam — Mon, 23 Sep 2019 15:15:33 GMT

Apologies I am receiving the same error even after the new code. I still think this is a limitation and we might have to switch to architectural changes, happy to be corrected.

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Tue, 24 Sep 2019 01:32:50 GMT

Hi,

I will take some time later to build qvw and then qvf apps to test it and see which approach is possible.

I usually test my answers so i will stop guessing now and will get back to you once i have them tested.

regards

Re: Binary load qvw file with section access

siddharthsoam — Tue, 24 Sep 2019 06:31:46 GMT

Thanks a lot for your help Lech.. that will be helpful !!

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Tue, 24 Sep 2019 12:24:23 GMT

Hi there,

So I have done my testing and there is only one way I was able to use to load qvw binary model to qlik sense app.

What i did is i created a section access in QVW (QlikView) with both NTNAME and USERID fields.

Section Access; SeccAcc: Load * Inline [ ACCESS, NTNAME, USERID, REDUCTION ADMIN, ELVAIO\LECH, ELVAIO\LECH, A ] ; SECTION Application;

ELVAIO\LECH is my domain name.

I reloaded QlikView app, saved it and closed it. I also tested data reduction based on REDUCTION field which I linked to my data model. It worked properly.

Then in Qlik Sense i simply used:

Binary [C:\Users\Lech\Desktop\sectionaccessapp.qvw];

(note that i have "Standard mode" switched off on my Qlik Sense engine which allows me to use UNC path instead of lib://, but this does not matter in this case). I was able to BINARY load sectionaccessapp.qvw and section access also worked straight away in Qlik Sense.

cheers!

Re: Binary load qvw file with section access

siddharthsoam — Tue, 24 Sep 2019 14:34:01 GMT

Appreciate that you took out the time to test.. I tried using userid and ntname in my section access code but still got the general error. I think i am not able to switch to legacy mode as i dont have the permission to do it.. In my case i will have to prefer changing the architecture and making an intermediate with the data model..

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Tue, 24 Sep 2019 21:57:19 GMT

You dont need legacy mode to run this. I only mentioned it to point out that i did not use Lib:// syntax, hovewer with Standard mode it is still working ok.

Next thing which comes to my mind is the version of Qlik Sense and version of QlikView.

I tested mine on QlikSense September 2019 and QlikView document created on the latest available QlikView version (whatever it is....)

and just to make sure:

you are running your tests on QlikSense server (not on Qlik Sense Desktop!!!)? Desktop does not support section access!

Re: Binary load qvw file with section access

siddharthsoam — Wed, 25 Sep 2019 06:13:36 GMT

Its not working in my case. I am using Qliksense server v11.24.5 and qlikview v12.10.20600 SR8.

An alternate i have for my case is to generate QVD's of the desired tables from qvw app at the end of my code and then use these QVD's in the qvf file.

Re: Binary load qvw file with section access

Lech_Miszkiewicz — Thu, 26 Sep 2019 08:28:29 GMT

Well... from technical point of view it works for me, so it is possible to configure it with binary load.

What is not really documented is the compatibilty of the files. Your Qli Sense version seems to be quite old and QlikView is neither new. Maybe they are not compatible.

this is the question you can ask Qlik Support.

With QVD approach - yes it will work without issues but it requires additional scripting..