Document Reload on QlikView Server not completing - Qlik Community

siz_mahleka · ‎2010-07-07

Hi,

I have a stange situation here. I have a QVD which uses the section access logic to restrict the data users have access to depending on their role. I've deployed this document to the QlikView server and it works fine. I can manually reload the document but I'm failing to get the scheduled reload on the QlikView server to work. I've managed to resolve a number off issues I face during this process but I've hit another brick wall for which no one seems to have discussed previously.

The 1st issue I faced was because I'm using section access, I have to tick the section access tab under Data Protection in the Reload tab of the document properties in the Enterprise Management Console.

The user must be the QlikviewService user and this user must be added as an admin user in the section access login.

The 2nd issue I faced was for my connection provider to the SQL server database was SQL Server Native Client 10.0 OLE DB Provider. For some reason a manual reload would work with this provider but the server seems to be more comfortable with SQLOLEDB.

The document was developed in Version 9.00.7502.8 SR5

The QlikView server is running on Windows Server 2003

The document load log is below. Please bear in mind that the manual client side load takes 15 minutes to complete where as the Server load does not seem to complete. Any ideas?

(2010-07-08 00:49:47) Information: Executing ClusterID=1, QDSID=d3a4688a-d0d1-725e-4b18-ec4637fd88cf QDSMain.ReloadTask
(2010-07-08 00:49:47) Information: Starting task "QlikViewDocs/Testing/Testing Load.qvw" (Attempt 1 of 1)
(2010-07-08 00:49:47) Information: Max run time: 06:00:00
(2010-07-08 00:49:47) Information: Opening "E:\QLIKVIEWDOCS\Testing\Testing Load.qvw"
(2010-07-08 00:49:47) Information: Allocating QlikView Engine
(2010-07-08 00:49:47) Information: Allocating new QlikView Engine. Current usagecount=1 of 8
(2010-07-08 00:49:47) Information: An instance of the QlikView Engine is being created
(2010-07-08 00:49:47) Information: Starting QlikView Engine
(2010-07-08 00:49:47) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 8, Ticket=29
(2010-07-08 00:49:47) Information: Loading document "E:\QLIKVIEWDOCS\Testing\Testing Load.qvw" (153.51 Mb)
(2010-07-08 00:49:48) Information: Loading. LoadTime=00:00:01
(2010-07-08 00:49:50) Information: Loading. LoadTime=00:00:03
(2010-07-08 00:49:50) Information: Physical FileSize=153.51 Mb. Memory Allocation Delta for this file=344.02 Mb. Available Physical Memory Before Open=14427.28 Mb. Available Physical Memory After Open=14089.46 Mb. Total Physical Memory=16378.64 Mb.
(2010-07-08 00:49:50) Information: The document was loaded successfully.
(2010-07-08 00:49:50) Information: Initializing Checkout (0), Loading document (157), Initializing load (157), Checking read (157), Creating QlikView Engine (157), Checking Size (188), Load (S&A) (188), Load Completed (2860), Tables read (3578), Opened successfully (3610)
(2010-07-08 00:49:50) Information: Document was opened successfully(2010-07-08 00:49:50) Information: Opened successfully (0)
(2010-07-08 00:49:50) Information: Starting reload
(2010-07-08 00:49:50) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2010-07-08 00:49:50) Information: The Source Document is being reloaded. DocumentPath=E:\QLIKVIEWDOCS\Testing\Testing Load.qvw
(2010-07-08 00:49:51) Information: Reloading.
(2010-07-08 00:49:52) Information: Reloading..
(2010-07-08 00:49:53) Information: Reloading..
.(2010-07-08 00:49:54) Information: Reloading....
(2010-07-08 00:49:55) Information: Reloading.....
(2010-07-08 00:49:56) Information: Reloading.....
.(2010-07-08 00:49:57) Information: Reloading.......
(2010-07-08 00:49:58) Information: Reloading........
(2010-07-08 00:49:59) Information: Reloading.........
(2010-07-08 00:50:00) Information: Reloading..........
(2010-07-08 00:50:01) Information: Slowing down logging. LoggingSeconds=2
(2010-07-08 00:50:01) Information: Reloading
(2010-07-08 00:50:03) Information: Reloading.
(2010-07-08 00:50:05) Information: Reloading..
(2010-07-08 00:50:07) Information: Reloading...
(2010-07-08 00:50:09) Information: Reloading....
(2010-07-08 00:50:11) Information: Reloading.....
(2010-07-08 00:50:13) Information: Reloading......
(2010-07-08 00:50:15) Information: Reloading.......
(2010-07-08 00:50:17) Information: Reloading........
(2010-07-08 00:50:19) Information: Reloading.........
(2010-07-08 00:50:21) Information: Reloading..........
(2010-07-08 00:50:23) Information: Slowing down logging. LoggingSeconds=10
(2010-07-08 00:50:23) Information: Reloading
(2010-07-08 00:50:33) Information: Reloading.
(2010-07-08 00:50:43) Information: Reloading..
(2010-07-08 00:50:53) Information: Reloading...
(2010-07-08 00:51:03) Information: Reloading....
(2010-07-08 00:51:13) Information: Reloading.....
(2010-07-08 00:51:23) Information: Reloading......
(2010-07-08 00:51:33) Information: Reloading.......
(2010-07-08 00:51:43) Information: Reloading........
(2010-07-08 00:51:53) Information: Reloading.........
(2010-07-08 00:52:03) Information: Reloading..........
(2010-07-08 00:52:13) Information: Slowing down logging. LoggingSeconds=60
(2010-07-08 00:52:13) Information: Reloading
(2010-07-08 00:53:13) Information: Reloading.
(2010-07-08 00:54:13) Information: Reloading...
(2010-07-08 00:55:13) Information: Reloading...
(2010-07-08 00:56:13) Information: Reloading....
(2010-07-08 00:57:13) Information: Reloading.....
(2010-07-08 00:58:13) Information: Reloading......
(2010-07-08 00:59:13) Information: Reloading.......
(2010-07-08 01:00:13) Information: Reloading........
(2010-07-08 01:01:13) Information: Reloading.........
(2010-07-08 01:02:13) Information: Reloading..........
(2010-07-08 01:03:13) Information: Slowing down logging. LoggingSeconds=300
(2010-07-08 01:03:13) Information: Reloading
(2010-07-08 01:08:13) Information: Reloading.
(2010-07-08 01:13:13) Information: Reloading..
(2010-07-08 01:18:13) Information: Reloading...
(2010-07-08 01:23:13) Information: Reloading....
(2010-07-08 01:28:13) Information: Reloading.....
(2010-07-08 01:33:13) Information: Reloading......
(2010-07-08 01:38:13) Information: Reloading.......
(2010-07-08 01:43:13) Information: Reloading........
(2010-07-08 01:48:13) Information: Reloading.........
(2010-07-08 01:53:13) Information: Reloading..........
(2010-07-08 01:58:13) Information: Slowing down logging. LoggingSeconds=600
(2010-07-08 01:58:13) Information: Reloading

bradshields · ‎2010-07-08

Hi,

Make sure you set the generate logfile option as follows

2010-07-08 00:49:50) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

and then reload and look at that log for additional clues. It will be in the same folder as the .qvw.

Also when you reload manually are you using the same account as the qlikview services are running under?

siz_mahleka · ‎2010-07-08

Hi Brad,

You are a super star! I followed your advice and it all became crystal clear. When I tried to reload the document logged in as the QlikviewService user in the Qlikview client it failed. It's strangely linked to the connection string as I described in the first post. I thought I had change the connection string but the document has a hidden load tab for the section access with another connection string. Once I sorted that one out, everything worked perfectly.

Kind Regards,

Siz.