Is binary load supported in Qlik Sense ?

[Oleg_Troyansky]

Folks,

I'm playing with Qlik Sense, and I was wondering if BINARY load was supported in Sense?

I'm trying to load a data model using Binary, and I'm getting an error "Cannot Open File..."

[amien]

Could you debug what causes this issue? i don't find a real reason.

[Anonymous]

I was trying quite a few things. And i guess this could be one bit of the solution which works.

So when performing the binary load make sure that app you are calling is not open up anywhere. Refresh the new application, write the binary load script and click the load data.

It will work.

[amien]

What do you mean with "Refresh the new application, write the binary" .. do you mean first reload and save the model which is being used for the binaray .. and then actual load the app which uses the binary as source?

It's not a right issue right? so when you use the Service Account to reload it will not happen? Are you having issues during the nightly reloads?

[amien]

What version number are you using? Me 2.1.1

[amien]

"is not open up anywhere." .. whats really hard to do if you want to do a reload during daytime. Unless you have some development version which the end-user is not using.

[grangerats]

As of Qlik Sense v3.2 I can confirm that this works. However, I have not tested the whole "what happens if the App is in use when you try to BINARY load from it?" part. I'm expecting the "cannot open file" type of error reported in other locations in this thread. In my use case, I plan to have a non-user-accessible App that only exists to load the actual data from the database, so I'm expecting to not have to worry about whether or not someone's got it "open" in the hub.

1. Identify the source App.
   • Copy the ID (GUID) from the list of Apps over in the QMC. Let's say it's "b6C5a067-46a2-4236-bff2-3a6e4ec63a25"
2. Create/Edit the destination App.
   1. Create a new folder Data connection named "QlikSenseApps". Point it to "C:\ProgramData\Qlik\Sense\Apps".
   2. Use this as the Load script:   BINARY [LIB://QlikSenseApps/b6C5a067-46a2-4236-bff2-3a6e4ec63a25];
      • (I like to rename the connection over in the QMC to remove the parenthetical user account info.)
   3. Load it.

UPDATE (2017-02-28)

I just confirmed that the destination App can be reloaded without errors while the source App is in use. In my test, both Apps are published to a Stream. I used the hub to open up the source App and navigate around. At the same time, I used another browser window to cause the destination App to be reloaded from the QMC.

Next, I duplicated both the source and destination Apps back to "My Work". I changed the duplicated destination App's load script to attempt the binary load from the duplicated source App. Then, while that duplicated source App was loading (the bubble animation was running), I clicked the "Load data" button in the duplicated destination App. Again, no errors. The source App loaded fine, and the destination App loaded without any errors.

FYI, in this last test, it took 35sec to load the App (397MB), and it normally takes about 11min when loading from the database; though in yesterday's tests, it was taking 1m30s to binary load that same App (~20sec to load and ~1m10s at the "Saving app..." step), so the disks must be less busy right now.

[Anonymous]

can you help me some sample script of  binary load in qlik sense

[sanjay24]

Can I do a binary load of QlikView QVW file with section access in Qlik Sense? Without removing section access from the script in QVW file.  Is this possible with Qlik Sense June 2019 release?

Appreciate your quick response.

Thank you in advance,

Sanjay

[treysmithdev]

While binary load is very much possible, I have been told by Qlik Support multiple times that it is not supported. Not sure if this is only for multi-node deployments or in general. Support said they wouldn't troubleshoot issues until the binary load was removed and replaced. Their reasoning was that due to the timing of syncing the repository and application migrations, they couldn't guarantee that the binary load would be pulling the latest application.

Is this something that has changed?

[AAShiraz]

I need to get the bytes of excel sheet which is created using MACRO. The code is running on the Excel Macro but unfortunatly unable to run and throws an exception. Please see the below code

Public Function GetFileBytes(ByVal path As String) As Byte()
Dim lngFileNum As Long
Dim bytRtnVal() As Byte
lngFileNum = FreeFile
If LenB(Dir(path)) Then ''// Does file exist?
Open path For Binary Access Read As lngFileNum
ReDim bytRtnVal(LOF(lngFileNum) - 1&) As Byte
Get lngFileNum, , bytRtnVal
Close lngFileNum
Else
Err.Raise 53
End If
GetFileBytes = bytRtnVal
Erase bytRtnVal
End Function

if anyone help me how to open the file because "Open path For Binary Access Read As lngFileNum" is throwing exception. 

Thanks,

Adeel