topic Re: CreateSearchIndexOnReload issue after upgrade to November 2018 in App Development

CreateSearchIndexOnReload issue after upgrade to November 2018

chrishayes — Mon, 31 Dec 2018 15:46:58 GMT

I recently upgraded from Qlik Sense September 2018 to November 2018 SR2. In all of my apps, I use some global scripts to set default variables. One of those is CreateSearchIndexOnReload. On my QVD generators, I had it set to 0 and on my presentation apps, set to 1. The global scripts are called using an Include statement at the beginning of the load script.

All apps exited the script after hitting this variable, regardless of the setting. So no data was being loaded. I commented out this line in the global scripts and all apps loaded fine. I would prefer to create the search index on load for my presentation apps so that my users will have a faster experience when using the global search option. Has this feature been depreciated? Has anyone else run into this issue?

Re: CreateSearchIndexOnReload issue after upgrade to November 2018

Gysbert_Wassenaar — Mon, 31 Dec 2018 16:32:46 GMT

I haven't run into this yet since we've not upgraded to Nov2018 yet. But the qvd generators I use always drop all tables end the end of the script and so no indexes will be created as there's no data anymore in the document.

Re: CreateSearchIndexOnReload issue after upgrade to November 2018

chrishayes — Mon, 31 Dec 2018 16:39:28 GMT

Yes, mine do as well. The issue was that the load wouldn't even happen because the script would stop running when it go to the line below.

SET CreateSearchIndexOnReload=0;

Re: CreateSearchIndexOnReload issue after upgrade to November 2018

rwunderlich — Mon, 31 Dec 2018 19:23:28 GMT

There are some known bugs in the Nov2018 release where scripts exit prematurely when an include is used. Contact QT support to find out if this matches your issue and if there is a workaround for your case.

-Rob

Re: CreateSearchIndexOnReload issue after upgrade to November 2018

chrishayes — Mon, 31 Dec 2018 19:40:08 GMT

For now I've commented the line out of my global scripts and apps are refreshing properly. I usually come here as I've had better luck with Community, but did open a ticket up with support.

Re: CreateSearchIndexOnReload issue after upgrade to November 2018

chrishayes — Tue, 15 Jan 2019 20:24:02 GMT

So there is now an option in the QMC in the Advanced section of your Engine settings where you can check whether or not you want to create a search index during reload. Support suggested turning that off to see if that is what is affecting the calling of the variable in my global script. For now I am going to leave it checked in the QMC and leave it commented out in my global script. It won't run on my QVD loaders because they all drop data, so I should be OK as is. Thanks to everyone who contributed.