Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

marco_puccetti
Contributor

Qliksense Application deploy on qmc

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

1 Solution

Accepted Solutions
paul_scotchford
Valued Contributor

Re: Qliksense Application deploy on qmc

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.

13 Replies
paul_scotchford
Valued Contributor

Re: Qliksense Application deploy on qmc

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.

marco_puccetti
Contributor

Re: Qliksense Application deploy on qmc

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

paul_scotchford
Valued Contributor

Re: Qliksense Application deploy on qmc

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.

Connection.png

marco_puccetti
Contributor

Re: Qliksense Application deploy on qmc

I get this error:

Store_Sense_QMC.png

Store_Sense_QMC_error.png

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

Marco

paul_scotchford
Valued Contributor

Re: Qliksense Application deploy on qmc

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.

marco_puccetti
Contributor

Re: Qliksense Application deploy on qmc

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

paul_scotchford
Valued Contributor

Re: Qliksense Application deploy on qmc

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);

Highlighted
marco_puccetti
Contributor

Re: Qliksense Application deploy on qmc

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

paul_scotchford
Valued Contributor

Re: Qliksense Application deploy on qmc

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.

Community Browser