topic Re: Reload using QlikView Publisher in QlikView

Reload using QlikView Publisher

Fri, 01 Mar 2013 10:56:13 GMT

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

Re: Reload using QlikView Publisher

danielrozental — Fri, 01 Mar 2013 12:28:24 GMT

Are you sure you're not reloading an empty QVW? this looks like it has no script.

Re: Reload using QlikView Publisher

Fri, 01 Mar 2013 12:33:57 GMT

Yes Daniel.....

When ever I try to use a qvw as a source document for publishing in Management console, it is taking away the script and it displays the following meassage in the script.

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

I tried enabling the reload option in the security tab of document properties, but it still displays the same message.

Re: Reload using QlikView Publisher

danielrozental — Fri, 01 Mar 2013 12:35:37 GMT

Surendra, you're not distributing the file to the same folder as the source file, are you? Because that would write over your QVW and remove your script.

Re: Reload using QlikView Publisher

Fri, 01 Mar 2013 12:41:32 GMT

Yes Daniel... I'm distributing the file to the same folder.....

If I distribute the file to a different folder, there will be another copy of qvw in the Access Point, which is not good.

Hence I did like that.

Re: Reload using QlikView Publisher

danielrozental — Fri, 01 Mar 2013 12:51:29 GMT

Surendra, when working with Publisher and doing distributions you should work with two separate folders.

Re: Reload using QlikView Publisher

Fri, 01 Mar 2013 13:35:55 GMT

Thanks for your nice piece of information.

you are absolutely right.

Re: Reload using QlikView Publisher

Fri, 01 Mar 2013 14:10:18 GMT

Hi Daniel,

I tried doing the same as suggested by you.

I've given the path D:\fact dimension model\test folder_reload in the Distribution services and D:\fact dimension model\test folder_publish in the QlikView server Folder in Set up of Management Console.

I've created a job to reload and publish the qvw. I have distributed the qvw to qlikview server for the mount folder specified in qlikview server.

When I run the job, it is taking away the script in both the qvws( qvws in both the folders).

Please can you help me regarding this.

Thanks,

Surendra

Re: Reload using QlikView Publisher

danielrozental — Fri, 01 Mar 2013 14:12:28 GMT

Surendra, only the distributed QVW will be stripped of the script, make sure you're not distributing it to the source folder.

Re: Reload using QlikView Publisher

Fri, 01 Mar 2013 14:14:25 GMT

No Daniel..

I'm not distributing the qvw to the source folder. I've distributed it to the mounted folder in qlikview server.

Yet I'm experiencing the same issue.

Re: Reload using QlikView Publisher

danielrozental — Fri, 01 Mar 2013 14:16:02 GMT

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

Re: Reload using QlikView Publisher

sibin_jacob — Mon, 18 Mar 2013 08:57:47 GMT

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

Re: Reload using QlikView Publisher

Mon, 18 Mar 2013 09:17:44 GMT

Hi Sibin,

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

Thanks,

Surendra