Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
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.
I get this error:
How can i change the script mode in order to use the classic file system path strings?
Marco
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.
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
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);
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
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.