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: 
marco_puccetti
Partner - Creator
Partner - Creator

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

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.

View solution in original post

13 Replies
paul_scotchford
Specialist
Specialist

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
Partner - Creator
Partner - Creator
Author

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

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
Partner - Creator
Partner - Creator
Author

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

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
Partner - Creator
Partner - Creator
Author

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

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

marco_puccetti
Partner - Creator
Partner - Creator
Author

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

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.