topic Re: Section Access : Reload Failing with NTNAME in QlikView

Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 10:35:48 GMT

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 !

Re: Section Access : Reload Failing with NTNAME

Chanty4u — Thu, 24 Mar 2016 10:40:16 GMT

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

Re: Section Access : Reload Failing with NTNAME

Chanty4u — Thu, 24 Mar 2016 10:41:19 GMT

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 ,

] ;

Re: Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 10:42:48 GMT

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

ADMIN, DOMAIN\ADMINQLIKVIEW, *

Re: Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 10:43:08 GMT

I haven't used UserID and Password...

Re: Section Access : Reload Failing with NTNAME

tresB — Thu, 24 Mar 2016 10:44:58 GMT

What is the error message you get?

Re: Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 10:48:32 GMT

(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

Re: Section Access : Reload Failing with NTNAME

tresB — Thu, 24 Mar 2016 10:51:09 GMT

Have you checked if it loads successfully without section access?

Re: Section Access : Reload Failing with NTNAME

swuehl — Thu, 24 Mar 2016 10:51:57 GMT

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)

Re: Section Access : Reload Failing with NTNAME

Chanty4u — Thu, 24 Mar 2016 10:55:15 GMT

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.

Re: Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 11:13:09 GMT

Without section access it loads successfully.

Re: Section Access : Reload Failing with NTNAME

tresB — Thu, 24 Mar 2016 11:18:37 GMT

Next check - is to confirm, if your service account is really a domain user or local user.

Re: Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 11:21:38 GMT

How to check that?

Re: Section Access : Reload Failing with NTNAME

swuehl — Thu, 24 Mar 2016 11:23:28 GMT

You can use the Windows OS user manager.

The user should also be listed in the Windows services details for the QlikView services.

Re: Section Access : Reload Failing with NTNAME

stevedark — Thu, 24 Mar 2016 11:25:17 GMT

Hi Manish,

Can you please look at the .log file for a task that is reloading successfully. In here it will have the domain name of the user doing the reload. It should be the service account user that you have running the QlikView service - but the log file will prove this.

Logging onto the server as the Service Account and using Desktop to open the file (as suggested above) is always a good way of checking things out.

Good luck!

Steve

Re: Section Access : Reload Failing with NTNAME

tresB — Thu, 24 Mar 2016 11:37:07 GMT

Users highlighted in red - are like ***\**** (i.e. - [domain name]\[user name]) are domain users.

Re: Section Access : Reload Failing with NTNAME

MK_QSL — Thu, 24 Mar 2016 11:50:27 GMT

It's working now. We have restarted the services and it's all OK now.

Thanks to all for your replies.

Re: Section Access : Reload Failing with NTNAME

Tue, 06 Sep 2016 18:04:27 GMT

Thank You tresesco, this solved my issue. Thank you Manish Kachhia.