Hi,
I have a document on the QV server. I wish to create a simple dashboard on that data and publish the dashboard with restricted access to users. No Excel and no new objects etc.
I have tried various versions of the Binary statement with no luck.
Tried
Binary .\crs_utilisation_reporting;
Binary [qvp://server\path\crs_utilisation_reporting]
Binary
all reloads fail with errors similar to below
What have I missed?
Richard
(2014-10-29 14:00:14) Information: Starting task 'QVfiles/Cross Application Support/GFA/CRS_Utilisation_dashboard.qvw'. Id:d3633969-ef8d-4fd4-96d2-205f6174930b. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
(2014-10-29 14:00:14) Information: Entering Task Execution.
(2014-10-29 14:00:14) Information: ClusterID=1
(2014-10-29 14:00:14) Information: QDSID=15f28056-72bf-1c17-68a5-366602ac15e6
(2014-10-29 14:00:14) Information: TaskID=d3633969-ef8d-4fd4-96d2-205f6174930b
(2014-10-29 14:00:14) Information: MaxRunTime=06:00:00
(2014-10-29 14:00:14) Information: MachineName=GBW03289
(2014-10-29 14:00:14) Information: Max attempts:1
(2014-10-29 14:00:14) Information: Current Attempt=0
(2014-10-29 14:00:14) Information: Task Dependencies are OK
(2014-10-29 14:00:14) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2014-10-29 14:00:14) Information: Opening "D:\QLIKVIEW FILES\Cross Application Support\GFA\CRS_Utilisation_dashboard.qvw"
(2014-10-29 14:00:14) Information: Allocating new QlikView Engine. Current usage count=0 of 3 (of type non-reader).
(2014-10-29 14:00:14) Information: Max retries:5
(2014-10-29 14:00:14) Information: Attempt:01
(2014-10-29 14:00:15) Information: Opened the QlikView Engine successfully. ProcessID=676
(2014-10-29 14:00:15) Information: Allocated QlikView Engine successfully. Current usage count=1 of 3 (of type non-reader). Ticket number=392.
(2014-10-29 14:00:15) Information: Loading document "D:\QLIKVIEW FILES\Cross Application Support\GFA\CRS_Utilisation_dashboard.qvw" (0.26 Mb)
(2014-10-29 14:00:16) Information: Physical FileSize=0.26 Mb. Memory Allocation Delta for this file=16.69 Mb. Available Physical Memory Before Open=27672.37 Mb. Available Physical Memory After Open=27652.16 Mb. Total Physical Memory=51199.55 Mb.
(2014-10-29 14:00:16) Information: Attempted to load the document without data.
(2014-10-29 14:00:16) Information: The document was loaded successfully.
(2014-10-29 14:00:16) Information: Document was opened successfully
(2014-10-29 14:00:16) Information: Starting reload
(2014-10-29 14:00:16) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2014-10-29 14:00:16) Information: The Source Document is being reloaded. DocumentPath=D:\QLIKVIEW FILES\Cross Application Support\GFA\CRS_Utilisation_dashboard.qvw
(2014-10-29 14:00:17) Information: Reloading.
(2014-10-29 14:00:18) Information: Reloading..
(2014-10-29 14:00:19) Information: Reloading...
(2014-10-29 14:00:20) Information: Reloading....
(2014-10-29 14:00:21) Information: Reloading.....
(2014-10-29 14:00:22) Information: Reloading......
(2014-10-29 14:00:23) Information: Reloading.......
(2014-10-29 14:00:24) Information: Reloading........
(2014-10-29 14:00:25) Information: Reloading.........
(2014-10-29 14:00:26) Information: Reloading..........
(2014-10-29 14:00:27) Information: Slow down logging. Log every <2> seconds.
(2014-10-29 14:00:27) Information: Reloading
(2014-10-29 14:00:29) Information: Reloading.
(2014-10-29 14:00:31) Information: Reloading..
(2014-10-29 14:00:33) Information: Reloading...
(2014-10-29 14:00:34) Information: The Source Document reload complete. DocumentPath=D:\QLIKVIEW FILES\Cross Application Support\GFA\CRS_Utilisation_dashboard.qvw
(2014-10-29 14:00:34) Information: Memory Allocation Delta for this file=650.91 Mb. Available Physical Memory Before Reload=27652.15 Mb. Available Physical Memory After Reload=26996.79 Mb. Total Physical Memory=26996.79 Mb.
(2014-10-29 14:00:34) Warning: Could not read ScriptErrorCount. The value is:
(2014-10-29 14:00:34) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEW FILES\Cross Application Support\GFA\CRS_Utilisation_dashboard.qvw.
(2014-10-29 14:00:34) Information: Found 1 messages from QlikView. Following below:
(2014-10-29 14:00:34) Information: Table not found newest: LOAD max(Date) as last , min(Date) as first resident table
(2014-10-29 14:00:35) Information: Closing the document.
(2014-10-29 14:00:35) Information: Closed the QlikView Engine successfully. ProcessID=676
(2014-10-29 14:00:35) Error: The task "QVfiles/Cross Application Support/GFA/CRS_Utilisation_dashboard.qvw" failed. Exception:
(2014-10-29 14:00:35) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEW FILES\Cross Application Support\GFA\CRS_Utilisation_dashboard.qvw.
(2014-10-29 14:00:35) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
(2014-10-29 14:00:35) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-10-29 14:00:35) Error: --- End of inner exception stack trace ---
(2014-10-29 14:00:35) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-10-29 14:00:35) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-10-29 14:00:35) Error: --- End of inner exception stack trace ---
(2014-10-29 14:00:35) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-10-29 14:00:35) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2014-10-29 14:00:35) Information: Task Execute Duration=00:00:21.4067980
(2014-10-29 14:00:35) Information: TaskResult.status=Finished
(2014-10-29 14:00:35) Information: Notifying all triggers of new state:FinishedWithErrors
(2014-10-29 14:00:35) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2014-10-29 14:00:35) Information: Saving Task Result
