topic Re: Differences in two systems' setups while running QVSource scripts in Connectivity & Data Prep

Differences in two systems' setups while running QVSource scripts

vlad_komarov — Mon, 10 Oct 2016 17:28:27 GMT

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&port=27017&database=table&collection=world] (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

Re: Differences in two systems' setups while running QVSource scripts

rohitk1609 — Mon, 10 Oct 2016 17:49:27 GMT

Hi Vladimir,

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

Re: Differences in two systems' setups while running QVSource scripts

vlad_komarov — Mon, 10 Oct 2016 17:55:18 GMT

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.com&port=27017&database=table&collection=world"(qvx)

Re: Differences in two systems' setups while running QVSource scripts

rohitk1609 — Mon, 10 Oct 2016 18:02:35 GMT

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.

Re: Differences in two systems' setups while running QVSource scripts

vlad_komarov — Mon, 10 Oct 2016 18:07:23 GMT

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...

Re: Differences in two systems' setups while running QVSource scripts

rohitk1609 — Wed, 12 Oct 2016 05:34:26 GMT

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

Re: Differences in two systems' setups while running QVSource scripts

vlad_komarov — Thu, 20 Oct 2016 13:55:27 GMT

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

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

Re: Differences in two systems' setups while running QVSource scripts

rohitk1609 — Fri, 21 Oct 2016 15:52:53 GMT

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.

Re: Differences in two systems' setups while running QVSource scripts

vlad_komarov — Fri, 21 Oct 2016 15:56:17 GMT

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

Re: Differences in two systems' setups while running QVSource scripts

rohitk1609 — Fri, 21 Oct 2016 16:16:09 GMT

Vladimir,

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