topic Script consisting only of some EXECUTE commands - impossible? in QlikView

Script consisting only of some EXECUTE commands - impossible?

datanibbler — Wed, 20 Jul 2016 07:22:13 GMT

Hi,

I have an app in QlikView that I want to use to capture some bugs in another report - I want to secure the data as it is at the time that the report is run - so I have exactly the same that is in the report, except that there are no filters.

=> Then I could use some listboxes to look at exactly the items that the other report did not show and hopefully find out why.

I thought, we have a data_loading_app, so the qvd_files of all the tables I need are created hourly, so I just have to somehow backup those qvd_files that I need at that time to keep them from again being overwritten.

For some reason, though, that does not work: The app is fine, with just three >> EXECUTE...copy << commands in the script, it runs, but there is a dialog_window.

I can launch the app from the console and it runs fine, withoug dialog_window.

<=> But it does not run at the time I schedule.

Also, there is no document_log at all, only a Distribution_report in xml format, but that cannot be displayed correctly by IE.

Can anyone help me here?

Thanks a lot!

Best regards,

DataNibbler

Could it be that a script consisting only of EXECUTE commands is not valid in QlikView? If so, what should I do to make it work?

P.S: I could also imagine that the server simply does not allow the execution of that command-line COPY - but in that case, should there not be a log saying so?

Re: Script consisting only of some EXECUTE commands - impossible?

marcus_sommer — Wed, 20 Jul 2016 07:55:35 GMT

Hi DataNibbler,

in general do applications with only some EXECUTE statements work (I have a lot of them for copy & synchronization files and data and various exporting & printing tasks - and quite important I'm always logged in on the server and some tasks run not directly else the qvw-execution runs a windows tasks which then runs the real batch).

If there are problems they are most often related to missing access-right, security-topics and user-configurations. In your case could be the last mentioned user-configurations the reason. Then if it worked by manually triggering the task within the qmc and not by a scheduled task which very probably runs without any user is logged in into the server. This meant the qvw with the EXECUTION runs with the access rights from the server-user but the started cmd-statement or batch runs without a looged in user only with a system default-user which probaly had not the proper access-rights and other configurations.

- Marcus

Re: Script consisting only of some EXECUTE commands - impossible?

datanibbler — Wed, 20 Jul 2016 08:06:12 GMT

Hi Marcus,

that's what I thought - the server blocks the execution of that command-line COPY command. But why is there no document_log telling me so?

Well, never mind. I changed the script now so that the qvd_files - created every hour - are just loaded and the data is then stored away again.

Best regards,

DataNibbler