Skip to main content

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
onkellepie
Partner - Contributor III
Partner - Contributor III

QlikSense: Is there an alternative for execute?

I migrate some qvw to qliksense. In QV i use following script to update old qvd files to new one:

STORE $(table) into [$(filename)_tmp.qvd];

IF ScriptErrorCount = 0 then

  // If there is no error, delete old qvd file and rename temp.qvd to normal filename.

  EXECUTE cmd.exe /C DEL /F [$(filename).qvd];

  EXECUTE cmd.exe /C MOVE /Y [$(filename)_tmp.qvd] [$(filename).qvd];

END If

Becaues we get some Trouble with our filesystem in the past, we introduce this to store at first a tmp.qvd file and then delete the old one and replace it with the new one. So far, so good.

But in QlikSense i got the error

EXECUTE statement not available in this script mode

I understand that i can solve the Problem when changing Settings ini to OverrideScriptSecurity and enabled legacy mode. But this solution comes with many other negativ aspects. So i dont want to change Settings.ini and dont want to enable legacy mode.

So i want to know if there is an alternative to rename/ replace a qvd file within QlikSense Script?

My System:

Windows Server 2016

Qlik Sense June 2017

Thanks in advance!

5 Replies
Aurelien_Martinez
Partner - Specialist
Partner - Specialist

Hi,

Have you see this Execute ‒ Qlik Sense ?

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
onkellepie
Partner - Contributor III
Partner - Contributor III
Author

Hi,

thanks for your Reply. i see this. But also:

If you set OverrideScriptSecurity to enable Execute, any user can execute files on the server. For example, a user can attach an executable file to an app, and then execute the file in the data load script.

i dont want to open my infrastructure in this way. So i search for another way to rename/replace my files without changing Settings.ini and so on.

Regards

Aurelien_Martinez
Partner - Specialist
Partner - Specialist

I think, there's no alternative.

You can retry, STORE $(table) into [$(filename).qvd];


Or you can play with the API to create an app (C# or any language) to rename the QVD after the reload.


Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
onkellepie
Partner - Contributor III
Partner - Contributor III
Author

Are there any other ideas? Everything is welcome

rupamjyotidas
Specialist
Specialist

Did you find any solution for this?