Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a vbscrit that reloads a dashboard. I call it using wscript.exe (or cscript.exe, it does not matter).
The problem comes when I schedule the dashboard synchonyzation in a W2K8 scheduled task. This task will execute at night, when no user is logged on.
Then, it does not run.
The VBS code is the following one:
subreload_Dash
If(WScript.Arguments.Count<>1) Then
wscript.quit(5)
'there ain't no dash
End If
Dim dash
dash=WScript.Arguments.Item(0)
Set objFSO = CreateObject("Scripting.FileSystemObject")
If not objFSO.FileExists(dash) then
'missing dash
wscript.quit(4)
end if
set Qv = CreateObject("QlikTech.QlikView")
if Qv is nothing then
Wscript.Quit(3)
'QlikView OCX unregisteted
Set qvDoc = Qv.OpenDoc(dash)
if qvDoc is nothing then
'qvDoc is null pointer
Wscript.Quit(2)
qvDoc.Reload 2
qvDoc.Save
if (qvDoc.GetVariable("ScriptErrorList").GetContent.String="") then
qvDoc.CloseDoc
Qv.Quit
Wscript.Quit(0)
else
'some errors...
Wscript.Quit(1)
End Sub
reload_Dash
I have tried workarounds posted in other theads but the issue is still to be fixed.
Any magical help?
Thanks,
JOS
Did you manage to resolve this problem?