Give System Access dialog causes script to get hung in reload but works in debug reload mode

[vvira1316]

Hi,

while executing a script that has following script portion generates a script security dialog that I've included in the attached image file. My hurdle here is that I'm able to execute the script manually in debug mode once I click on "Give System Access" but it will not automatically reload and gets hung.

let vScriptDirectory = '\\Path\Script';

let vS = '01/01' & Year(Today());
let vE = If(Num(Month(MonthEnd(today(),-1))) < 9, '0' & Num(Month(MonthEnd(today(),-1))), Num(Month(MonthEnd(today(),-1)))) & '/' & Day(MonthEnd(today(),-1)) & '/' & Year(MonthEnd(today(),-1));

Date_Variable_Temp:
LOAD * Inline [
StartDate,EndDate
$(vS),$(vE)
];

STORE Date_Variable_Temp into \\Path\Data\Date_Variable.qvd(qvd);

execute "C:\Program Files\QlikView\Qv.exe" /r /vvStart=$(vS) /vvEnd=$(vE) $(vScriptDirectory)Script1.qvw;
load 'Script1 Completed.' as Log, MakeDate(Year(today()),Month(today()),Day(today())) & ' ' & MakeTime(Hour(now()),Minute(now())+5) as DtTm AutoGenerate 1;

execute "C:\Program Files\QlikView\Qv.exe" /r /vvStart='$(vS)' /vvEnd='$(vE)' $(vScriptDirectory)Script2.qvw;
load 'Script2 Completed.' as Log, MakeDate(Year(today()),Month(today()),Day(today())) & ' ' & MakeTime(Hour(now()),Minute(now())+10) as DtTm AutoGenerate 1;

DROP Table Date_Variable_Temp;
exit script;

[marcus_sommer · Accepted solution]

I think you need to enable this within the user-properties in tab security.

- Marcus

[avinashelite]

Go to >Setting>User Preferences>security> and check all the necessary options

Hope this helps you 

[vvira1316]

Thanks Avinash

[vvira1316]

Thanks Marcus.