topic Re: Binary loads only small part of data in App Development

Binary loads only small part of data

Marijn — Mon, 19 Sep 2022 08:17:33 GMT

Hi everyone,

I'm trying to do a binary load in QlikSense from a qvw file that's stored on the QlikSense Server. We have multiple working connections already, that work without any issues. This is a new datamodel that I need for a dashboard, but when I do a binary load, it only loads about 150 record (of 15 million). I think it's particularly strange that it loads this small number of rows, I would expect it to load nothing if there's an issue.

There is no error message, the binary load script is structured exactly the same as all my other scripts and the data load progress looks exactly the same compared to reloading other datamodels.

I'm thinking there must be some restriction somewhere in the settings, but I can't find any. Any tips as where to look?

Thanks in advance!

Marijn

Re: Binary loads only small part of data

MendyS — Mon, 19 Sep 2022 08:33:38 GMT

HI @Marijn

when you load with the binary load you cant limit the number of rows,
maybe you drop some table before the model finishes the script load?
I will check if there is any concatenate that you are unaware of between tables, and you drop tables.

also, check the data load viewer of the first model after the load, maybe that will give you better look

Re: Binary loads only small part of data

marcus_sommer — Mon, 19 Sep 2022 08:34:33 GMT

Maybe any section access is applied ...

- Marcus

Re: Binary loads only small part of data

Marijn — Mon, 10 Oct 2022 08:06:40 GMT

Hi Marcus,

Turns out it was a section access issue, which still is strange that it did load some of the data instead of nothing. For now the issue is solved, thanks!