topic Re: Schedule is not happaning in QlikView

Schedule is not happaning

Fri, 30 Jan 2015 09:01:35 GMT

HI all,

if am trying to scheduling my qvw it is failing

if i reload manually it is reloading my i know the reason

i don't have publisher license is that the issue.

Re: Schedule is not happaning

krishna20 — Fri, 30 Jan 2015 09:10:30 GMT

Hi,

Siva,

Have you schedule your app any one of options i.e; daily,weekly.....

Regards

Krishna

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 09:14:48 GMT

You do not need publisher to schedule a task.

You need to select an option in the Reload Schedule. Try selecting Hourly. You should then see your job listed in the Status window, and you can either wait until the reload is due or click the black arrow to run the job immediately.

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:16:44 GMT

i had try wit daily and hourly it is failing on both

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:22:51 GMT

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 09:23:31 GMT

Have you checked the logs?

You can view the log on the QMC by clicking the Show Task Details option at the top right of the QMC screen. You need to select a single job on the left to view the details of a job.

Then click Logs to see the log details. You must select a single job on the left screen to see the log details.

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:37:14 GMT

i can't see the the log file

in qvw doc setting i had checked create log also

Re: Schedule is not happaning

krishna20 — Fri, 30 Jan 2015 09:38:49 GMT

Hi,

Please restart all your services once and then check.

Regards

krishna

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:40:02 GMT

Can you post the QVW text log file too?

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 09:41:10 GMT

Select one of your failed jobs by clicking on the task name listed under default, then select Show Details and you can view the log.

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:46:09 GMT

(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.

This is log details

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 09:49:12 GMT

The log has this error

Document open call failed. The document might require username and password.

Does your document have section access?

If yes, then you need to add the service account that is running the QDS service to your section access table with access to all data.

Re: Schedule is not happaning

krishna20 — Fri, 30 Jan 2015 09:51:51 GMT

Hi,

Do you have implemented section access in this? Give username and password at bottom of Reload tab.

Regards

Krishna

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:55:25 GMT

Yes it has section access

where to create QDS service tell me

Re: Schedule is not happaning

Fri, 30 Jan 2015 09:59:01 GMT

have a look as your server task manager, you'll see a user running the QlikView process, this will be your service account and as Colin has said this will need to be in your section access table

Re: Schedule is not happaning

Fri, 30 Jan 2015 10:06:44 GMT

can u peace elaborate i am not getting what u r saying joe

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 10:08:48 GMT

The login account that runs the QlikView Distribution Service needs to be included in your section access part of your load script.

At the moment, when the distribution service is running the reload on the server, the account does not have permission in section access to open the document, so the reload fails.

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 10:11:40 GMT

See this thread

http://community.qlik.com/thread/83374

Re: Schedule is not happaning

Fri, 30 Jan 2015 10:15:30 GMT

one more qvw i had tryed which dono't have section access it is also failing

Re: Schedule is not happaning

Colin-Albert — Fri, 30 Jan 2015 10:17:22 GMT

Are there any errors reported in the log files. This will be a different problem to the section access issue.