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.
till_bentz
New Contributor III

Reload Task does work locally, but not via QMC

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

18 Replies
Luminary
Luminary

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

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,

DV

www.QlikShare.com

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

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

Not applicable

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

Hi,

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

Best Regards

Luminary
Luminary

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

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,

DV

www.QlikShare.com

till_bentz
New Contributor III

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

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

till_bentz
New Contributor III

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

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

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

till_bentz
New Contributor III

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

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

Luminary
Luminary

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

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,

DV

Community Browser