Reload using QlikView Publisher

[#1]

Hi folks,

I've a small issue regarding QliView Publisher. I've scheduled reload using QlikView Publisher(Management Console) every two hours.

The scheduled reload is always succesful, but the report doesn't show any data even though data exists. I've checked the log also in the folder where qvw resides.

It has the following details:

3/1/2013 10:08:11 AM:      Execution started.

3/1/2013 10:08:11 AM:      QlikView Version:11.00.11282.0

3/1/2013 10:08:11 AM:      CPU Target                    x64

3/1/2013 10:08:11 AM:      Operating System              Windows Server (R) 2008 Standard Service Pack 2 (64 bit edition)

3/1/2013 10:08:11 AM:      Wow64 mode                    Not using Wow64

3/1/2013 10:08:11 AM:      MDAC Version                  6.0.6002.18005

3/1/2013 10:08:11 AM:      MDAC Full Install Version     6.0.6002.18005

3/1/2013 10:08:11 AM:      PreferredCompression          2

3/1/2013 10:08:11 AM:      EnableParallelReload          1

3/1/2013 10:08:11 AM:      ParallelizeQvdLoads           1

3/1/2013 10:08:11 AM:      AutoSaveAfterReload           0

3/1/2013 10:08:11 AM:      BackupBeforeReload            0

3/1/2013 10:08:11 AM:      EnableFlushLog                0

3/1/2013 10:08:11 AM:      SaveInfoWhenSavingFile        0

3/1/2013 10:08:11 AM:      UserLogfileCharset            0

3/1/2013 10:08:11 AM:      OdbcLoginTimeout              -1

3/1/2013 10:08:11 AM:      OdbcConnectionTimeout         -1

3/1/2013 10:08:11 AM:      ScriptWantsDbWrite            false

3/1/2013 10:08:11 AM:      ScriptWantsExe                false

3/1/2013 10:08:11 AM:      LogFile CodePage Used:        1252

3/1/2013 10:08:11 AM:      Execution finished.

Looking at the above log I can't come to a conclusion ,as it doesn't contain the list of fields it has loaded.

I couln't understand why the data is not being displayed in the report.

Kindly help me regarding this.

Many Thanks,

Surendra

[danielrozental]

Remove the task, restore the original QVW to the source folder and try again.

[sibin_jacob]

HI Surendra,

Qlikview server automatically delete the scripts while using task for Distribute files.

In distribute files, In the place of scripts it will show

"// Write your script here. Note: Reload is disabled upon distribution. Enable by changing the checkbox at Settings->Document preferences->Security->Reload."

Solution is you need to use hidden script functionality. Qlikview server won't delete hidden script while using distribute task. And it will load data properly.

Let me know if you have any concerns.

Thanks,

Sibin Jacob.C

[#4]

Hi Sibin,

Well..That seems to be a good idea...I'll try it.

Thanks,

Surendra