topic Re: Reload Task does work locally, but not via QMC in QlikView

Reload Task does work locally, but not via QMC

till_bentz — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have a problem with my reload tasks. There seems to be a problem using any database connections and I can't figure out why it does not work.

I have several QVWs using data from several oracle databases. When I execute a reload locally from within the Qlikview Desktop everything works fine:

10.09.14 12:17:59: Execution started.

10.09.14 12:17:59: QlikView Version:11.20.12451.0

10.09.14 12:17:59: CPU Target x64

10.09.14 12:17:59: Operating System Windows Server 2012 R2 Standard (64 bit edition)

10.09.14 12:17:59: Wow64 mode Not using Wow64

10.09.14 12:17:59: MDAC Version 6.3.9600.16384

10.09.14 12:17:59: MDAC Full Install Version 6.3.9600.16384

10.09.14 12:17:59: PreferredCompression 2

10.09.14 12:17:59: EnableParallelReload 1

10.09.14 12:17:59: ParallelizeQvdLoads 1

10.09.14 12:17:59: AutoSaveAfterReload 0

10.09.14 12:17:59: BackupBeforeReload 0

10.09.14 12:17:59: EnableFlushLog 0

10.09.14 12:17:59: SaveInfoWhenSavingFile 0

10.09.14 12:17:59: UserLogfileCharset 1200

10.09.14 12:17:59: OdbcLoginTimeout -1

10.09.14 12:17:59: OdbcConnectionTimeout -1

10.09.14 12:17:59: ScriptWantsDbWrite false

10.09.14 12:17:59: ScriptWantsExe false

10.09.14 12:17:59: LogFile CodePage Used: 1200

10.09.14 12:17:59: Reload Executed By AD\svc_qlikview_test

10.09.14 12:17:59: Process Executing: QlikView Desktop

10.09.14 12:17:59: Process ID: 70740

[...]

10.09.14 12:17:59: OLEDB CONNECT*Provider*XPassword*

10.09.14 12:17:59: [...]

10.09.14 12:17:59: SQL SELECT *

10.09.14 12:17:59: FROM [...]

10.09.14 12:18:00: 10 fields found: [...], 12.804 lines fetched

10.09.14 12:18:00: [...]

10.09.14 12:18:00: OLEDB CONNECT*Provider*XPassword*

10.09.14 12:18:00: [...]

10.09.14 12:18:00: SQL SELECT *

10.09.14 12:18:00: FROM [...]

10.09.14 12:18:01: 53 fields found: [...], 29.507 lines fetched

10.09.14 12:18:04: [...]

10.09.14 12:18:04: EXIT Script

10.09.14 12:18:04: Execution finished.

When I try to execute the same reload task from within the publisher using the QMC the reload just stops right at the database connection:

10.09.14 12:20:15: Execution started.

10.09.14 12:20:15: QlikView Version:11.20.12451.0

10.09.14 12:20:15: CPU Target x64

10.09.14 12:20:15: Operating System Windows Server 2012 R2 Standard (64 bit edition)

10.09.14 12:20:15: Wow64 mode Not using Wow64

10.09.14 12:20:15: MDAC Version 6.3.9600.16384

10.09.14 12:20:15: MDAC Full Install Version 6.3.9600.16384

10.09.14 12:20:15: PreferredCompression 2

10.09.14 12:20:15: EnableParallelReload 1

10.09.14 12:20:15: ParallelizeQvdLoads 1

10.09.14 12:20:15: AutoSaveAfterReload 0

10.09.14 12:20:15: BackupBeforeReload 0

10.09.14 12:20:15: EnableFlushLog 0

10.09.14 12:20:15: SaveInfoWhenSavingFile 0

10.09.14 12:20:15: UserLogfileCharset 1200

10.09.14 12:20:15: OdbcLoginTimeout -1

10.09.14 12:20:15: OdbcConnectionTimeout -1

10.09.14 12:20:15: ScriptWantsDbWrite false

10.09.14 12:20:15: ScriptWantsExe false

10.09.14 12:20:15: LogFile CodePage Used: 1200

10.09.14 12:20:15: Reload Executed By AD\svc_qlikview_test

10.09.14 12:20:15: Process Executing: QVB

10.09.14 12:20:15: Process ID: 22612

[...]

10.09.14 12:20:15: let vLastReload = Timestamp(ReloadTime(),'YYYYMMddHHmmss')

The task then hangs until I abort it. AS you can see, I am using the same account. The manual reload is also done on the same server.

Any hints or tipps would be very much appreciated!

Thank you very much!

Regards, Till

Re: Reload Task does work locally, but not via QMC

IAMDV — Wed, 10 Sep 2014 10:45:52 GMT

Hi Till,

How many QVB engines are set for distribution and administration? You can check this option in QMC > System > Setup > Select QDS Service Name > Advanced Tab.

If you don't have enough QVB engines running to execute the process/task then you might have this issue. Also, check what else is being reloaded on QMC now? Currently, if you have more tasks reloading than the QVB setting (Shown in attached image) then you might have this issue.

I hope this helps!

Cheers,

www.QlikShare.com

Re: Reload Task does work locally, but not via QMC

ashfaq_haseeb — Wed, 10 Sep 2014 11:12:13 GMT

Hi,

In this case I would say, make sure that the service account you use to run QlikView services have read access to your Oracle Tables/Views you use.

Let me know if that works

Regards

ASHFAQ

Re: Reload Task does work locally, but not via QMC

Wed, 10 Sep 2014 11:17:56 GMT

Hi,

if you have cluster you should add connection to all publisher server,

Best Regards

Re: Re: Reload Task does work locally, but not via QMC

IAMDV — Wed, 10 Sep 2014 11:20:28 GMT

Ashfaq - If you read Till's note. He's using the same account on Desktop client and QMC. So I don't think it's the permission related issue. Do you agree?

Cheers,

www.QlikShare.com

Re: Reload Task does work locally, but not via QMC

till_bentz — Wed, 10 Sep 2014 11:22:04 GMT

The reload does not work, even if it is the only active reload task on the whole server.

Re: Reload Task does work locally, but not via QMC

till_bentz — Wed, 10 Sep 2014 11:24:03 GMT

I have only one QlikView Server and one Qlikview Publisher. The desktop reload works on both machines using the aforementioned service account.

Re: Reload Task does work locally, but not via QMC

ashfaq_haseeb — Wed, 10 Sep 2014 11:28:21 GMT

Hi,

Deepak If you load locally it will directly connect to Oracle database via credentials you use in your connecting string.

Bu if you ask the server to do the jobs, It first establish connection with service account and later with the credentials in your connection string.

This is what I heard from Bill Britt

That is the reason we are making sure that service account have read permissions.

Regards

ASHFAQ

Re: Reload Task does work locally, but not via QMC

till_bentz — Wed, 10 Sep 2014 11:34:56 GMT

Hi,

do you mean the service account tries to connect directly to the oracle server? I find it kind of hard to believe that. And it would also not work, because the service account has no rights (and should have no rights) on the database.

I also think that the error must be somewhere else, because from what I read in the logfile, the QVB Process doesn't even try to establish a database connection.

Regards, Till

Re: Reload Task does work locally, but not via QMC

IAMDV — Wed, 10 Sep 2014 11:39:09 GMT

Thanks for the clarification Ashfaq. It's clear now and I understand your point.

Till - Why do you think Service Account shouldn't have any rights? If it doesn't have any reads then how would it read the data from the DB? We're not talking about write permissions but read permissions shouldn't harm anything.

Cheers,

Re: Reload Task does work locally, but not via QMC

till_bentz — Wed, 10 Sep 2014 11:44:25 GMT

The service account should not have any rights on the database machine, because it is a service account for running the qlikview application. It is in a totally different user context than the database. And if the QV service accounts would need db rights it would be impossible to connect to a database that you do not administer your self, wouldn't it?

Cheers.

Re: Reload Task does work locally, but not via QMC

Fri, 19 Sep 2014 22:08:55 GMT

Hi MohammadReza,

Can you breakdown to what services should run on each server for setting cluster environment running on 11.2SR6 and the requirement is as follows :-

QVserver1 and QVserver2 on cluster and one publisher server and file server.

Re: Reload Task does work locally, but not via QMC

till_bentz — Tue, 23 Sep 2014 08:31:40 GMT

Hello,

thanks for all the input. It seems that the problem was solved by using fully qualified names in all parts of the configuration.

Re: Reload Task does work locally, but not via QMC

IAMDV — Tue, 23 Sep 2014 08:40:00 GMT

That's good to know. Can you explain in detail please?

Re: Reload Task does work locally, but not via QMC

ashfaq_haseeb — Tue, 23 Sep 2014 08:41:25 GMT

Yes,

If possible can you upload a small document please.

regards

ASHFAQ

Re: Reload Task does work locally, but not via QMC

Fri, 24 Oct 2014 10:10:03 GMT

Hi Till,

It'll great if you can just put a comment about what you mean by full qualify names because we have reinstall our landscpae on windows 2012 server with QlikView SR7 and facing exactly the same issue with Oracle.

Regards

Alex

Re: Reload Task does work locally, but not via QMC

till_bentz — Fri, 24 Oct 2014 12:40:18 GMT

Hi Alex,

with fully qualified names I was referring to the configuration under System -> Setup. I had to change to change the Names of the QlikView Servers, the Directory Service Connectors and the QlikView Web Serves to use fully qualified names (servername.company.com) instead of just the servername. The same I did for the URLs configured for the different services (you can find the URLs on the General tabs).

This seemed to solve the problem for me.

Regards

Till

Re: Reload Task does work locally, but not via QMC

Fri, 24 Oct 2014 14:02:41 GMT

Hi Till,

Unfortunately, that doesn't seems to work for us... I've changed the Name & Url from hostname to hostname.domain for all components:

- QlikView Servers

- Distribution Service

- Directory Service Connectors

- QlikView Web Servers

After that, I've restarted all components but if I try to reload data with a task in the QMC (using an oracle database), then the task is running... running... forever.

The strange thing is that on our Windows 2k8 R2 landscape, everything is working fine even without FQDN but in this new Windows 2012 R2 landscape, that doesn't work.

Any help on that subject would be very appreciated!

Regards,

Morgan

Re: Reload Task does work locally, but not via QMC

Fri, 24 Oct 2014 14:19:24 GMT

Rectification...

After a reboot of the Windows Server (!), the reload of data using an Oracle database is working even from the QMC. Is it thanks to the FQDN + Reboot or just thanks to the Reboot ? Don't know...

But anyway, thanks for your help!

Regards,

Morgan