Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
till_bentz
Contributor III
Contributor III
‎2014-09-10 06:37 AM

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

5,785 Views
18 Replies
till_bentz
Contributor III
Contributor III
‎2014-09-10 07:44 AM
Author

In response to IAMDV

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.

567 Views
0 Likes
Not applicable
‎2014-09-19 06:08 PM

In response to

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.

566 Views
0 Likes
till_bentz
Contributor III
Contributor III
‎2014-09-23 04:31 AM
Author

Hello,

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

566 Views
0 Likes
IAMDV
Luminary Alumni
Luminary Alumni
‎2014-09-23 04:40 AM

In response to till_bentz

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

566 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2014-09-23 04:41 AM

In response to till_bentz

Yes,

If possible can you upload a small document please.

regards

ASHFAQ

566 Views
0 Likes
Not applicable
‎2014-10-24 06:10 AM

In response to till_bentz

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

566 Views
0 Likes
till_bentz
Contributor III
Contributor III
‎2014-10-24 08:40 AM
Author

In response to

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

566 Views
0 Likes
Not applicable
‎2014-10-24 10:02 AM

In response to till_bentz

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

566 Views
0 Likes
Not applicable
‎2014-10-24 10:19 AM

In response to

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

566 Views
0 Likes