Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Test.qvw application on server.
Script is as below.
ADMINQLIKVIEW is QVS Service Account
NOTE : We don't have publisher.
SECTION ACCESS;
LOAD * INLINE
[
ACCESS, NTNAME, COUNTRY
ADMIN, DOMAIN\ADMINQLIKVIEW, *
USER, DOMAIN\MANISH, GERMANY
USER, DOMAIN\MANISH, FRANCE
USER, DOMAIN\JAMES, SPAIN
USER, DOMAIN\ROBERT, UKRAINE
];
SECTION APPLICATION;
Sales:
LOAD * INLINE
[
COUNTRY, SALES
GERMANY, 100
FRANCE, 120
SPAIN, 90
UKRAINE, 200
];
I have also made below changes in QV document.
Settings – Document Properties – Opening
Initial Data Reduction Based on Section Access Ticked
Strict Exclusion Ticked
Prohibit Binary Load Ticked
Server side…
Authorization
User Type: Named Users
I have added
ADMINQLIKVIEW
MANISH
JAMES
ROBERT
Now when I am doing Reload Schedule it is getting failed. I don’t know what’s going wrong here.
May be something very simple but I am missing here.
Please help !
Apart from this make sure you add service account to Admin of section access.
If you are using NTNAME you dont need a Password and UserID because the NTNAME will authenticate the user.
Section Access:
STAR is * ;
LOAD * INLINE [
ACCESS , NTNAME ,
] ;
Already there and mentioned in my question.. Thanks for your reply.
ADMIN, DOMAIN\ADMINQLIKVIEW, *
I haven't used UserID and Password...
What is the error message you get?
(2016-03-24 10:29:29) Information: Starting task 'QV-Root/QV-BIS/Section Access Test.qvw'. Id:1796a433-0554-437c-8a78-a79412e99776. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
(2016-03-24 10:29:29) Information: Entering Task Execution.
(2016-03-24 10:29:29) Information: ClusterID=1
(2016-03-24 10:29:29) Information: QDSID=c6169bca-801f-bac8-c6c3-c129a25b6e11
(2016-03-24 10:29:29) Information: TaskID=1796a433-0554-437c-8a78-a79412e99776
(2016-03-24 10:29:29) Information: MaxRunTime=06:00:00
(2016-03-24 10:29:29) Information: MachineName=INT-QVDEV-1
(2016-03-24 10:29:29) Information: Max attempts:1
(2016-03-24 10:29:29) Information: Current Attempt=0
(2016-03-24 10:29:29) Information: Task Dependencies are OK
(2016-03-24 10:29:29) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2016-03-24 10:29:29) Information: Opening "E:\QV-SHARED QVDS\QV-BIS\Section Access Test.qvw"
(2016-03-24 10:29:29) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
(2016-03-24 10:29:29) Information: Max retries:5
(2016-03-24 10:29:29) Information: Attempt:01
(2016-03-24 10:29:30) Information: Opened the QlikView Engine successfully. ProcessID=3528
(2016-03-24 10:29:30) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=79.
(2016-03-24 10:29:30) Information: Loading document "E:\QV-SHARED QVDS\QV-BIS\Section Access Test.qvw" (0.37 Mb)
(2016-03-24 10:29:31) Information: Loading. LoadTime=00:00:01.0140130
(2016-03-24 10:29:33) Error: Document open call failed. The document might require username and password.
(2016-03-24 10:29:33) Information: Attempted to load the document without data.
(2016-03-24 10:29:33) Error: The document failed to open.
(2016-03-24 10:29:33) Information: Closed the QlikView Engine successfully. ProcessID=3528
(2016-03-24 10:29:33) Error: Document could not be opened
(2016-03-24 10:29:33) Information: Closed the QlikView Engine successfully. ProcessID=3528
(2016-03-24 10:29:33) Information: Failed to check in document: E:\QV-SHARED QVDS\QV-BIS\Section Access Test.qvw
(2016-03-24 10:29:33) Error: The task "QV-Root/QV-BIS/Section Access Test.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: E:\QV-SHARED QVDS\QV-BIS\Section Access Test.qvw || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2016-03-24 10:29:33) Information: Task Execute Duration=00:00:04.2432544
(2016-03-24 10:29:33) Information: TaskResult.status=Finished
(2016-03-24 10:29:33) Information: Notifying all triggers of new state:FinishedWithErrors
(2016-03-24 10:29:33) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2016-03-24 10:29:33) Information: Saving Task Result
Have you checked if it loads successfully without section access?
Could you post the task log?
And could you log in as ADMINQLIKVIEW and open the QVW?
(also double check that ADMINQLIKVIEW is a domain user, not a local user)
there is no issue.. i thnk chk with admin as user..
or else
u can try once restart ur system and qvw and reload again.