Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vijaysahu2
Contributor

The script in this document requires system Access to work

Everytime I am re-loading I am getting below pop-up ..This pop up issue has been resolved in my local machine by checking all the text box under user preference -> Security Tab but I have following question

 

1. Why this is displaying every time?

2. If I deploy this Qvw file on QLikview server will this pop -up occur and will not reload data. Because locally everytime I have to click 'Give System Access' button to start the load otherwise nothing will progress.

3. We have deployed this QVW file on QLikview server and I am only getting below messages and no re-load happening


(5/31/2019 11:51:40 AM) Information: Reloading.......

(5/31/2019 11:56:41 AM) Information: Reloading........

(5/31/2019 12:01:41 PM) Information: Reloading.........

(5/31/2019 12:06:41 PM) Information: Reloading..........

(5/31/2019 12:11:41 PM) Information: Slow down logging. Log every <600> seconds.

(5/31/2019 12:11:41 PM) Information: Reloading

(5/31/2019 12:21:42 PM) Information: Reloading.

(5/31/2019 12:31:42 PM) Information: Reloading..

(5/31/2019 12:41:42 PM) Information: Reloading...

(5/31/2019 12:51:43 PM) Information: Reloading....

System Access to work.PNG

4. If I save the file after selecting all the check boxes under User Preference -> Security Tab and get it deployed on Qlikview server, will all the default setting be overwritten on server ? or this qlikview re-load will happen on server?

 

We are struggling to reload this document from Qlikview UAT server .. This is only showing

 

(5/31/2019 11:03:15 AM) Information: DistributeTask[66f92f55-7ac1-499d-bfd6-514ee214d2ee] ("Sales QVD Creator"): TryStart - Starting task. Triggered by 'TaskCompletedTrigger'. Id:1f59a171-3ae8-44e4-94a0-a930cfcf8a18. ExecID:53225b1e-b014-4bba-8363-24a989ae77d5

(5/31/2019 11:03:15 AM) Information: Entering Task Execution.

(5/31/2019 11:03:15 AM) Information: ClusterID=2

(5/31/2019 11:03:15 AM) Information: QDSID=8940d618-6cc5-9e84-0a81-db5765b6a3d0

(5/31/2019 11:03:15 AM) Information: TaskID=66f92f55-7ac1-499d-bfd6-514ee214d2ee

(5/31/2019 11:03:15 AM) Information: ExecID=53225b1e-b014-4bba-8363-24a989ae77d5

(5/31/2019 11:03:15 AM) Information: MaxRunTime=1.00:00:00

(5/31/2019 11:03:15 AM) Information: MachineName=GBEXE12AS225CN2

(5/31/2019 11:03:15 AM) Information: Task execution max attempts=1

(5/31/2019 11:03:15 AM) Information: Task execution current attempt=1

(5/31/2019 11:03:15 AM) Information: Task Dependencies are OK

(5/31/2019 11:03:15 AM) Information: The task "Sales QVD Creator" is starting

(5/31/2019 11:03:15 AM) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(5/31/2019 11:03:15 AM) Information: Opening "\\gbexe12as225ci1\QlikViewStorage\SourceDocuments\Jelf Sales\QVD\Sales QVD Creator.qvw"

(5/31/2019 11:03:15 AM) Information: Allocating new QlikView Engine. Current usage count=1 of 10 (of type non-reader).

(5/31/2019 11:03:15 AM) Information: Max retries:5

(5/31/2019 11:03:15 AM) Information: Attempt:01

(5/31/2019 11:03:15 AM) Information: Opened the QlikView Engine successfully. ProcessID=9752

(5/31/2019 11:03:15 AM) Information: Allocated QlikView Engine successfully. Current usage count=2 of 10 (of type non-reader). Ticket number=10792.

(5/31/2019 11:03:15 AM) Information: Loading document "\\gbexe12as225ci1\QlikViewStorage\SourceDocuments\Jelf Sales\QVD\Sales QVD Creator.qvw" (0.41 Mb)

(5/31/2019 11:03:15 AM) Information: Physical FileSize=0.41 Mb. Memory Allocation Delta for this file=4.77 Mb. Available Physical Memory Before Open=252042.28 Mb. Available Physical Memory After Open=252039.38 Mb. Total Physical Memory=262018.32 Mb.

(5/31/2019 11:03:15 AM) Information: Attempted to load the document without data.

(5/31/2019 11:03:15 AM) Information: The document was loaded successfully.

(5/31/2019 11:03:15 AM) Information: Document was opened successfully

(5/31/2019 11:03:15 AM) Information: Starting reload

(5/31/2019 11:03:15 AM) Information: The Source Document is being reloaded. DocumentPath=\\gbexe12as225ci1\QlikViewStorage\SourceDocuments\Jelf Sales\QVD\Sales QVD Creator.qvw

(5/31/2019 11:03:16 AM) Information: Reloading.

(5/31/2019 11:03:17 AM) Information: Reloading..

(5/31/2019 11:03:18 AM) Information: Reloading...

(5/31/2019 11:03:19 AM) Information: Reloading....

(5/31/2019 11:03:20 AM) Information: Reloading.....

(5/31/2019 11:03:21 AM) Information: Reloading......

(5/31/2019 11:03:22 AM) Information: Reloading.......

(5/31/2019 11:03:23 AM) Information: Reloading........

(5/31/2019 11:03:24 AM) Information: Reloading.........

(5/31/2019 11:03:25 AM) Information: Reloading..........

(5/31/2019 11:03:26 AM) Information: Slow down logging. Log every <2> seconds.

(5/31/2019 11:03:26 AM) Information: Reloading

(5/31/2019 11:03:28 AM) Information: Reloading.

(5/31/2019 11:03:30 AM) Information: Reloading..

(5/31/2019 11:03:32 AM) Information: Reloading...

(5/31/2019 11:03:34 AM) Information: Reloading....

(5/31/2019 11:03:36 AM) Information: Reloading.....

(5/31/2019 11:03:38 AM) Information: Reloading......

(5/31/2019 11:03:40 AM) Information: Reloading.......

(5/31/2019 11:03:42 AM) Information: Reloading........

(5/31/2019 11:03:44 AM) Information: Reloading.........

(5/31/2019 11:03:46 AM) Information: Reloading..........

(5/31/2019 11:03:48 AM) Information: Slow down logging. Log every <10> seconds.

(5/31/2019 11:03:48 AM) Information: Reloading

(5/31/2019 11:03:58 AM) Information: Reloading.

(5/31/2019 11:04:08 AM) Information: Reloading..

(5/31/2019 11:04:18 AM) Information: Reloading...

(5/31/2019 11:04:28 AM) Information: Reloading....

(5/31/2019 11:04:38 AM) Information: Reloading.....

(5/31/2019 11:04:48 AM) Information: Reloading......

(5/31/2019 11:04:58 AM) Information: Reloading.......

(5/31/2019 11:05:08 AM) Information: Reloading........

(5/31/2019 11:05:18 AM) Information: Reloading.........

(5/31/2019 11:05:28 AM) Information: Reloading..........

(5/31/2019 11:05:38 AM) Information: Slow down logging. Log every <60> seconds.

(5/31/2019 11:05:38 AM) Information: Reloading

(5/31/2019 11:06:38 AM) Information: Reloading.

(5/31/2019 11:07:39 AM) Information: Reloading..

(5/31/2019 11:08:39 AM) Information: Reloading...

(5/31/2019 11:09:39 AM) Information: Reloading....

(5/31/2019 11:10:39 AM) Information: Reloading.....

(5/31/2019 11:11:39 AM) Information: Reloading......

(5/31/2019 11:12:39 AM) Information: Reloading.......

(5/31/2019 11:13:39 AM) Information: Reloading........

(5/31/2019 11:14:39 AM) Information: Reloading.........

(5/31/2019 11:15:39 AM) Information: Reloading..........

(5/31/2019 11:16:39 AM) Information: Slow down logging. Log every <300> seconds.

(5/31/2019 11:16:39 AM) Information: Reloading

(5/31/2019 11:21:39 AM) Information: Reloading.

3 Replies

Re: The script in this document requires system Access to work

The following link from the Help site will show you the change you need to make on the server side to allow this script to run without prompting for Execute File Paths.  The Qlikview Service Account running Qlikview Server should be an administrator on the server so this shouldn't be an issue as long as the changes below are made to the Qlikview Batch settings.ini file:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Hope this helps!

Thanks,
Josh 

Qlik Support

 

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Partner
Partner

Re: The script in this document requires system Access to work

Are you calling a macro from the script?
ashwanin
Valued Contributor

Re: The script in this document requires system Access to work

give access of external program from :

edit script -->Setting--> can Execute external Programs ( click check box)