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

[#1]

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.

[prieper]

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]

Hi Chandu,

PFA and take steps to achieve this task.

[Peter_Cammaert]

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]

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)

[#6]

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]

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