Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner - Specialist III
Partner - Specialist III

Differences in two systems' setups while running QVSource scripts

Hello all,

Need some advice:

1. I have two identical (almost) QS systems, running QS 3.1.

2. One was configured a while ago and was recently upgraded. The other one was a fresh install.

3. Both systems have QVSource component running.

4. The first (old upgraded) system runs script extracting data from Mongo DB successfully.

5. The second (newly created) system fails the same script with the message:

LOAD statement only works with lib:// paths in this script mode

The error occurred here:

Data:

LOAD * FROM [http://localhost:5555/QVSource/MongoDBConnectorV2/?table=AAAAAAAA&appID=&server=bbb-zzzzz.xxxxxx.com...] (qvx);

I know that this looks like "legacy scripting mode" issue (https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/LoadData/disable-standard-mode.htm‌). But I do not have this mode activated on my first system.... There is no "Mongo Connector" set on "old" system either....

I guess some other option was set during the "old" setup a while ago. Just looking for suggestions what I am missing in my "new setup". I will appreciate your help!

Regards,

Vladimir

9 Replies
rohitk1609
Master
Master

Hi Vladimir,

replace Square brackets by " , your script will run fine.

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

Nope, it did not help..

The following error occurred:

LOAD statement only works with lib:// paths in this script mode

The error occurred here:

Data: LOAD * FROM "http://localhost:5555/QVSource/MongoDBConnectorV2/?table=AAAAAAA&appID=&server=bbb-zzzzz.xxxxxxxx.co..."(qvx)

rohitk1609
Master
Master

Try this ,

Go to settings.ini file and make standard mode 1 to 0 . See I have upgraded my Qlik , So My file don't have same parameters , or go to that folder where your other Qlik file are , copy it and paste it here.

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

Rohit,

This approach is not acceptable for me (see above). I do not have a legacy mode activated on other system and script works fine. And I have tons of other scripts running using a Standard mode, so I do not want to change it for all of them...

VK

rohitk1609
Master
Master

Hi Vladmir,

I believe something is preventing your new upgraded Qlik to access QV Source . Please try to investigate what is the difference between your new qlik setting file and old one

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

It appears that Qlik is supporting more elegant way to handle both modes:

Screen Shot 2016-10-20 at 8.47.08 AM.png

Unchecking this option allows me to run the script above along with "normal" lib:// paths scripts.

Somehow I've missed that I've modified this setting on my "old" systems.

Regards,

Vlad

rohitk1609
Master
Master

Hi Vladimir,

What you have disabled , the same thing I have suggested to change the settings in settings.ini file as my solution was for Qlik Sense Desktop and your have done this for sever. Thanks to informing how you fix it , Your inputs always welcome on my side.

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

Rohit,

Yes, it's definitely the same option, but my INI file was empty, so I've figured the Qlik has created (finally) an option to handle these changes more properly, without "hacking" the configuration files remotely....

Thank you for a suggestion!

Regards,

Vlad

rohitk1609
Master
Master

Vladimir,

Yes I agree it is empty since 3.0 launched but we can manually add the parameter with values i.e StandardReload=0 .