topic scheduling failed in qlikview in QlikView

scheduling failed in qlikview

Mon, 02 Feb 2015 04:08:27 GMT

my task is reloading manually but when i scheduling it is failing

my task is having section access

hear is the log

(2015-01-30 15:03:00) Information: Executing ClusterID=1, QDSID=07cbd14b-5ab2-f13c-5811-cfc0d67015d8 QDSMain.DistributeTask

(2015-01-30 15:03:00) Information: Starting task "NMEA/NMEA_iManage_Dashboard_1.3.qvw" (Attempt 1 of 1)

(2015-01-30 15:03:00) Information: Max run time: 06:00:00

(2015-01-30 15:03:00) Information: Document is marked for refresh; Initializing Reload.

(2015-01-30 15:03:00) Information: Opening "C:\QlikView_Document\NMEA\NMEA_iManage_Dashboard_1.3.qvw"

(2015-01-30 15:03:00) Information: Allocating QlikView Engine

(2015-01-30 15:03:00) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

(2015-01-30 15:03:00) Information: An instance of the QlikView Engine is being created

(2015-01-30 15:03:00) Information: Starting QlikView Engine

(2015-01-30 15:03:01) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=90

(2015-01-30 15:03:01) Information: Loading document "C:\QlikView_Document\NMEA\NMEA_iManage_Dashboard_1.3.qvw" (40.01 Mb)

(2015-01-30 15:03:01) Error: Document open call failed. The document might require username and password.

(2015-01-30 15:03:01) Error: The document failed to open.

(2015-01-30 15:03:01) Information: Closed the QlikView Engine successfully. ProcessID=2840

(2015-01-30 15:03:01) Information: Initializing Checkout (0), Loading document (1047), Initializing load (1047), Checking read (1047), Creating QlikView Engine (1047), Checking Size (1062), Load (1078), Load Completed (1375)

(2015-01-30 15:03:01) Error: Document could not be opened

(2015-01-30 15:03:01) Information: Document could not be opened (0)

(2015-01-30 15:03:01) Information: Initializing (0), Finished (0)

(2015-01-30 15:03:01) Error: Reload failed because the document could not be opened successfully. DocumentState=CouldNotOpenDocument

(2015-01-30 15:03:01) Information: Initializing (0), Finished (0)

(2015-01-30 15:03:01) Error: Reload failed. Distribution skipped.

their is no QlikView Distribution Service

Thanks

sivaram

Re: scheduling failed in qlikview

jonathandienst — Mon, 02 Feb 2015 05:34:23 GMT

Most likely cause is that the Qlikview document has section access applied and the publisher service account is not permitted access. If the access security is using NTNAME, make sure the publisher service is listed in the section access table. If the access security is via USERID/PASSWORD, then enable the Section Access checkbox and enter the USERID and password values in the QMC task.

Either the NTNAME or USERID must have ADMIN level access, not USER level access.

HTH

Jonathan

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 05:44:59 GMT

Hi Jonathan

my company don't have publisher license

only qvmc i had tryed with hen enable the Section Access checkbox and enter the USERID and password values in the QMC task.

it is using NTNAME only

Re: scheduling failed in qlikview

jonathandienst — Mon, 02 Feb 2015 06:00:15 GMT

Then it is the Qlikview Server service account that needs to be included in the section access list loaded into the document.

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 06:13:05 GMT

How to include will u help me

i am implementing the section access from excel file with user and ntname

admin,username

user, username

Re: scheduling failed in qlikview

jonathandienst — Mon, 02 Feb 2015 06:23:44 GMT

Add a line with admin as the access type and the name of the service account in the NTNAME column

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 06:36:38 GMT

ACESS NTNAME

ADMIN	sivaram.p
USER	sivasrava.p

where to add

ADD AND REPLY ME please

Re: scheduling failed in qlikview

Peter_Cammaert — Mon, 02 Feb 2015 08:40:52 GMT

Just add a line that says

ADMIN, domainname\accountname

Replace domainname\accountname with the username of the account that is running the QVS. To get this accountname, open control panel services.msc on your QlikView server, scroll down until you encounter QlikView Server and look in the column that lists the account.

If you aren't able to access the server running the ALikView services, ask your SysAdmin to give you the service account name.

Best,

Peter

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 08:50:52 GMT

All the servies are running

my acesspoint i am using

user:dbqv\sivasrava.p

pwd::----------

in qvw os user() will get dbqv\sivasrava.p

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 08:53:44 GMT

Tell me one thing is it possible to schedule my job with section Access

QDS service account how to include this

Re: scheduling failed in qlikview

Peter_Cammaert — Mon, 02 Feb 2015 08:55:00 GMT

Your screenshot is a good first step. However, go to services.msc again, and scroll to the right. The Login as column is the last one (Nr 5 if I'm not mistaken).

Re: scheduling failed in qlikview

ashfaq_haseeb — Mon, 02 Feb 2015 08:58:40 GMT

Hi,

Post your section access script here.

I believe Peter answer it.

Regards

ASHFAQ

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 08:59:19 GMT

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 09:00:47 GMT

Tell me what to do with log on as

./QVAdmin

Re: scheduling failed in qlikview

Peter_Cammaert — Mon, 02 Feb 2015 09:04:13 GMT

I can only repeat what has been said before a couple of times: add a line to your Section Access data that says:

ADMIN, QVAdmin

If you know the machine domain of the server running QlikView Server, you could change the account into machinedomain\QVAdmin.

Just try it.

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 09:14:45 GMT

Thank u for ur suggestion i am new to admin side of qlikview

how to find machinedomain name and how to change machinedomain\QVAdmin.

i am accessing client using remote server

in qvw osuser()::qvdb\sivasrava.p

at accesspont::qvdb\sivasrava.p

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 09:16:46 GMT

By seeing that snapshot my loginas .QVAdmin

Re: scheduling failed in qlikview

Peter_Cammaert — Mon, 02 Feb 2015 09:22:48 GMT

Try without the machine domain first.

Re: scheduling failed in qlikview

Mon, 02 Feb 2015 09:27:30 GMT

Section Access;

LOAD [ACCESS],

NTNAME,

SID

FROM

(ooxml, embedded labels, table is SECTIONMASTER);

Section Application;

SecurityDetails:

LOAD SID,

COUNTRYID,

DEPT_ID,

[How to use QlikView?],

[Volume Performance],

[Financial Performance],

[Contribution & Trend],

[Customer Performance],

[Customer Portfolio],

[Customer Trending],

[Sales Team Performance],

[Verfication Sheet],

FAQ

FROM

(ooxml, embedded labels, table is ACESSMASTER);

Inner Join(SecurityDetails)

LOAD COUNTRYID,

COUNTRY_NAME

FROM

(ooxml, embedded labels, table is COUNTRYMASTER);

Inner Join(SecurityDetails)

LOAD DEPT_ID,

TRANSPORT_MODE

FROM

(ooxml, embedded labels, table is DEPTMASTER);

Re: scheduling failed in qlikview

Peter_Cammaert — Mon, 02 Feb 2015 09:31:24 GMT

Ok, you have a third column called SID. When adding the line for QVAdmin, leave it blank like:

ADMIN, QVAdmin,