Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

Hi All,

I am trying to automate the load process and would anyone please help me with the following scenario?

I have two QVWs

1. Create.qvw and 2. Main.qvw

The CreateQVDs.qvw created 9 qvds .

The "MainApp.qvw" is the main application which is reads the QVDs and does tons of calculations.

This process takes approximately 1 hr on my workstation.

Now the process is completely manual and I have to maintain these files.

What I would like to do is

1.Kick off the load process for Create.qvw at 12:15 AM Automatically - server schedulling

2 Kick off the load process for Main.qvw at 1:15 AM Automatically - Start the load process for Main.qvw Automatically

If anyone has a better idea please post that.

Thanks in advance,

Chandu.

6 Replies
prieper
Not applicable

Re: How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

Please check QMC (Qlikview Managent Console) on your server.

Under "Documents" you may go to the "Reload"-tab, where you can enter the timing and cascading of applications to be refreshed.

HTH Peter

krishna20
Not applicable

Re: How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

Hi Chandu,

PFA and take steps to achieve this task.

Peter_Cammaert
Not applicable

Re: How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

You can schedule the two document reloads separately, which carries a substantial risk as it may produce wrong results as soon as the reload of Create.qvw starts taking more than 1 hour.

Or you can configure Create.qvw to start reloading at a specific time, and chain Main.qvw to the Create.qvw-task so that the Main-task is triggered as soon as the Create-task ends with success. No time wasted. See trigger type "On an event from another task" in the Reload panel.

buzzy996
Not applicable

Re: How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

1. QEMC-Reload schedule this Create.qvw  at ur time interval.

2. Schedule this Main.qvw after ,from Relaod tab-- Click on Radio button On Event of Another Task-Choose successfull from check box--and select from drop down box Create.qvw (entire this 2 step on same row)

Not applicable

Re: How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

Hi Thanks for ur help.

when I load the file it is giving error like'

Memory Allocation Delta for this file=27.74 Mb. Available Physical Memory Before Reload=6540.36 Mb. Available Physical Memory After Reload=14027.19 Mb. Total Physical Memory=14027.19 Mb.

Please help me. Its urgent.

Peter_Cammaert
Not applicable

Re: How to Relaod and Schedule Qvds and Qvws in Qlikview Server Automatically

That is not an error message, it is a memory allocation report that the QDS service creates for each reload.

Which of the two tasks is failing? Please post the TaskLog and DocumentLog (make sure that your reload creates a log file by enabling Generate log file in Settings->Document Properties->General).