topic Re: Qliksense Application deploy on qmc in App Development

Qliksense Application deploy on qmc

marco_puccetti — Wed, 10 Feb 2016 16:33:20 GMT

Hello i need to deploy qliksense application on a local qlik server; the deployment works but i have noticed that the application working on local qliksense desktop doesn't work if published on qmc.

Are not recognized properly the connections and the store command.

Have i to change any settings to let it works properly?

Thanks

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Wed, 10 Feb 2016 23:09:03 GMT

Yes you will need to ensure that the connections that are available on the Server are referenced in your load script as the Desktop and Server references a different.

Re: Qliksense Application deploy on qmc

marco_puccetti — Thu, 11 Feb 2016 09:17:28 GMT

The connection are ok, but i have noticed that the datas aren't loaded and written correctly.

TABELLA:

LOAD *;

SQL SELECT *

FROM $(CATALOG).dbo.TABELLA;

STORE TABELLA INTO $(QVD_PATH)\TABELLA_$(m_DataExtr).$(M_QVD_EXT) (QVD);

DROP TABLE TABELLA;

The QVD_PATH is reported in a setting file as below:

SET QVD_PATH = 'C:\ProgramData\Qlik\Sense\QVD';

The same script executed without deployment on qmc but tested in Qliksense desktop works perfectly, so what can i do?

Thanks

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Thu, 11 Feb 2016 09:48:02 GMT

The path needs to be defined in the data loader, the syntax you show is not correct, go into Data Loader and click CREATE CONNECTION function see below shot, then select Folder, follow the prompts to locate your file, a connection alias is created that you can reference when loading. You can do this by editing your app on the Server (in the My Work stream) or create a connection via the QMC, either way the App needs this connection alias.

This process is the same via Server or Desktop version, but the connections are not interchangeable from Server to Desktop or vice versa.

When the connection has been created, you can then load your data, just select the Connection and click the "Select Data" icon, this will prompt you through the find a file options and set you up to load.

That will get you going.

Re: Qliksense Application deploy on qmc

marco_puccetti — Thu, 11 Feb 2016 10:31:09 GMT

I get this error:

How can i change the script mode in order to use the classic file system path strings?

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Thu, 11 Feb 2016 10:48:44 GMT

SET QVD_PATH = '[lib://qlik-test_ioladmin (server_username)/' ;

I assume qlik-test_ioladmin is your file folder connection alias ?

Server connections will have a username embedded, usually the creator.

Re: Qliksense Application deploy on qmc

marco_puccetti — Thu, 11 Feb 2016 16:55:13 GMT

Hello, i get an error during the execution of this statement:

STORE TABELLA INTO 'Lib://QVD_PATH (qlik-test_ioladmin)'\TABELLA.qvd (QVD);

but during the load routine:

LOAD TABELLA

FROM

['Lib://QVD_PATH (qlik-test_ioladmin)'\TABELLA.QVD] (qvd);

i get an error related to the qvd file missing (File not found), although i've noticed that the file has been created properly.

What's wrong?

I have replaced also the folder path with the lib style path definition.

Thanks

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Thu, 11 Feb 2016 21:21:45 GMT

The variable for the file path should contain the file name too, my apologies I did not make this clear in my previous reply...

SET QVD_PATH = 'lib://<your connection name> (your_server_username)/TABELLA.qvd]' ;

STORE TABELLA INTO $(QVD_PATH ) (QVD);

Re: Qliksense Application deploy on qmc

marco_puccetti — Fri, 12 Feb 2016 09:25:47 GMT

The problem is that the store statement works perfectly, while is the Load that is not working.

Store

STORE TABELLA INTO 'Lib://QVD_PATH (qlik-test_ioladmin)'\TABELLA_$(m_DataExtr).$(M_QVD_EXT) (QVD);

Load

LOAD

FROM

['Lib://QVD_PATH (qlik-test_ioladmin)'\TABELLA_$(m_DataExtr).$(M_QVD_EXT)] (qvd);

But this statement doesn't find the produced qvd file.

How can i solve this?

Thanks

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Fri, 12 Feb 2016 10:40:36 GMT

You don't need the ' in the path, you have ['Lib://QVD_PATH(qliktest_ioladmin)'\TABELLA_$(m_DataExtr).$(M_QVD_EXT)] (qvd);

If your store works try a load using the same string.

Try using debug to see how the connection string is composed.

Re: Qliksense Application deploy on qmc

marco_puccetti — Fri, 12 Feb 2016 11:39:32 GMT

It still returns me invalid path.

Is it possible to use any other string connection form?

Thanks

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Fri, 12 Feb 2016 11:49:44 GMT

If your Store statement works then the Load would work too.

It looks to me you are trying to mix variables and strings incorrectly.

For example TABELLA_$(m_DataExtr) I would construct as 'TABELLA_' & $(m_DataExtr)

Personally I don't build up complex connection strings with multi variables , I tend to assign a single variable to

a single file path.

I guess, you probably might like to read up on $Expansion and experiment with your connection string using the guidelines for $Expansion of variables in a string.

Re: Qliksense Application deploy on qmc

marco_puccetti — Fri, 12 Feb 2016 13:31:57 GMT

I have removed the ' before the statement

['Lib://QVD_PATH (qlik-test_ioladmin)'\TABELLA_$(m_DataExtr).$(M_QVD_EXT)] (qvd);

and now it works properly.

Thanks

Marco

Re: Qliksense Application deploy on qmc

paul_scotchford — Fri, 12 Feb 2016 20:39:15 GMT

Great. Can you mark the thread as answered please to close it off.

Thanks

Paul