Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

atafsson
Contributor

Binary load Qlik Sense error

Hi community,

I'm using Sense 3.0 and trying to do a binary load from another Sense 3.0 app. The app contains Section Access which I'm adding after the Binary load statement. I get it to work when doing a

Binary folderpath/folder/<app id>;


< Load Section access script >

exit script;


The thing is that I want to load one of the tables in the data model and add a where-clause i.e.

Binary folderpath/folder/<app id>;

< Load Section access script >

Fact_AppSpecific:

noConcatenate

Load *

Resident Fact

Where Type = 'Transactions';

Drop table Fact;

Exit script;

When reloading the script above I get this error:

_SRR___CRR_5__1____Data_load_editor_-_Qlik_Sense.png

It seems to be connected to when I'm loading the fact table resident and then dropping it, when the error occur.

Anyone had a similar problem? Any suggestions on solutions?

1 Solution

Accepted Solutions
atafsson
Contributor

Re: Binary load Qlik Sense error

No on Qlik version 3.1 and higher it is possible to do. The bug was fixed in version 3.1 as far as I can see.

Binary folderpath/folder/<app id>;

< Load Section access script >

Fact_AppSpecific:

noConcatenate

Load *

Resident Fact

Where Type = 'Transactions';

Drop table Fact;

Exit script;

6 Replies
syukyo_zhu
Contributor III

Re: Binary load Qlik Sense error

Hi,

I got same error, Did you get some information about your issue?

Thanks

atafsson
Contributor

Re: Binary load Qlik Sense error

Hi,

The feedback I got was to upgrade from version 3.0 to 3.1 or higher. Currently on Sense 3.2 and it works good.

It worked for us, now I can do the Resident Load I need.

The work-around was to store the needed tables in .QVD's and read them and completely drop the Fact table after the BINARY LOAD.

Hope that help @xiazhu

syukyo_zhu
Contributor III

Re: Binary load Qlik Sense error

Hi Axel,

Thanks your anwsers.

So this is a bug qlik sense, and il has been fixed in the recent version of Qlik sense

Xia

atafsson
Contributor

Re: Binary load Qlik Sense error

So it seem. I didn't get much details when I asked except that they said an upgrade should help - and it did.

syukyo_zhu
Contributor III

Re: Binary load Qlik Sense error

OK, thanks for your reply. I try to get more information from support qlik about that.

But after ungrading my version Qlik sense from 3.0 to 3.2 if I need always to do store table to qvd and then reload them?

atafsson
Contributor

Re: Binary load Qlik Sense error

No on Qlik version 3.1 and higher it is possible to do. The bug was fixed in version 3.1 as far as I can see.

Binary folderpath/folder/<app id>;

< Load Section access script >

Fact_AppSpecific:

noConcatenate

Load *

Resident Fact

Where Type = 'Transactions';

Drop table Fact;

Exit script;