Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

auto reload data using Publisher

Hi

I have license on QlikView Server and QlikView Publisher, but i don't have schedule settings such as Server Settings etc from Configuring-a-reload-schedule.ashx on QV wiki (here was link but i was waiting few hours for moderator approval...)

OS: Windows Server 2012 R2

QVS: 11.20

I tried to make task in QMC but it didn't work. Also i was thinking about windows task scheduler and Reload Data button but i don't know if this solutions are possible to do without installing QlikView Desktop on my Windows Server?

1 Solution

Accepted Solutions
Not applicable

Re: auto reload data using Publisher

Not sure I understand you correctly, but if you are referrring to that you do not see the tab Reload when you have selected a User Document, then this only available if you do not have a Publisher license. These reload setting a has limited functionality only available for none-licensed customers. With the Publisher license you do the same (and much more) by creating tasks on Source Documents and distribute them into User Documents.

12 Replies

Re: auto reload data using Publisher

Hi,

Can you provide complete build number?

What installer of server you use to install it on Windows 2012?

There is separate 2012 Installer available as well. I prefer to use that in case if you are not already using this.

Regards

ASHFAQ

Not applicable

Re: auto reload data using Publisher

11.20.12235.0

i use QlikViewServer_Win2012andUp

x64 version

Re: auto reload data using Publisher

Hi,

This is 11.2 sr5.

Can you try by upgrading to 11.2 sr10.

Let me know if that works.

Regards

ASHFAQ

Not applicable

Re: auto reload data using Publisher

Not sure I understand you correctly, but if you are referrring to that you do not see the tab Reload when you have selected a User Document, then this only available if you do not have a Publisher license. These reload setting a has limited functionality only available for none-licensed customers. With the Publisher license you do the same (and much more) by creating tasks on Source Documents and distribute them into User Documents.

Not applicable

Re: auto reload data using Publisher

Ok, i didn't know it, but i tried tasks and i was getting QDSMain.Exceptions.ReloadFailedException -> QDSMain.Exceptions.LogBucketErrorException

And what with Reload button? 

Not applicable

Re: auto reload data using Publisher

According to Magnus post upgrading have no sense now, am i right?

Not applicable

Re: auto reload data using Publisher

There is no reload button per say. You create a task and tick the checkbox 'Enable' in section 'Perform Reload' on tab 'Reload'. Then you need setup to distribute the reloaded source document to a User Document. Then run the task.

Regarding the ReloadFailedException you need to provide more detailed info about this.

For example: See this to for getting a document log http://community.qlik.com/message/726474#726474

Not applicable

Re: auto reload data using Publisher

sry i wasn't enough precise, i mean button made in QlikView Desktop executing Reload action

ok, i have problem with my connection string

error:

ODBC CONNECT*XUserId*

Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

i define my mysql driver as ODBC Data Source on my Windows Server, but only as User DSN

when i add the same driver in System DSN,  task is executing without errors, but my report file is empty ('no data to display')

Not applicable

Re: auto reload data using Publisher

Your must keep Source Documents and User Documents seperated.

Why you have "No data to display" could be because you mixed these up.

User Documents can't not be reloaded by default. Do you see this when you open the script editor?

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

Community Browser