Section Access : Reload Failing with NTNAME - Qlik Community

MK_QSL · ‎2016-03-24

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 !

Chanty4u · ‎2016-03-24

Apart from this make sure you add service account to Admin of section access.

Chanty4u · ‎2016-03-24

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 ,

] ;

MK_QSL · ‎2016-03-24

Already there and mentioned in my question.. Thanks for your reply.

ADMIN, DOMAIN\ADMINQLIKVIEW, *

MK_QSL · ‎2016-03-24

I haven't used UserID and Password...

tresesco · ‎2016-03-24

What is the error message you get?

MK_QSL · ‎2016-03-24

(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

tresesco · ‎2016-03-24

Have you checked if it loads successfully without section access?

swuehl · ‎2016-03-24

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)

Chanty4u · ‎2016-03-24

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.