Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
if you have cluster you should add connection to all publisher server,
Best Regards
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
The reload does not work, even if it is the only active reload task on the whole server.
I have only one QlikView Server and one Qlikview Publisher. The desktop reload works on both machines using the aforementioned service account.
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
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
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