Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I made a simple application:
test:
LOAD * INLINE [
test
toto
titi
];
I can reload this application without problem with the QV Desktop.
But when I try to reload it with the server, the task never stops.
I'm using QV server 11.0.11440.0 x64.
Does anyone have the same problem?
When I reload applications without "LOAD INLINE", I don't have any problem...
When a LOAD INLINE is scripted, Qvb.exe tries to write a temp file in the root folder (something like "C:\INLDxxX.tmp").
By default, a simple user can't write on the root.
If I give write access to the owner of the services, it works!
The owner of services is in "Qlikview Administrators" group, but is not a full administrator of the server.
But there is only on the "LOAD INLINE" where I have a problem...
Hi Nicolas Martin,
I've seen a similar problem when the server license was not applied correctly on qlikview server.
Have you applied the license on qlikview server ?
A successful message appears after the qlikview server license be applied correctly.
Hope it helps you.
Regards
Unfortunately, yes, I have applied the licence successfully
Here is the log file:
13/06/2013 10:43:39.4122866 | Information | Starting task 'TEST RELOAD.qvw'. Id:2d092dc2-e073-4e1c-b220-897b52548c62. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0d |
13/06/2013 10:43:39.4122866 | Information | Entering Task Execution. |
13/06/2013 10:43:39.4122866 | Information | ClusterID=1 |
13/06/2013 10:43:39.4122866 | Information | QDSID=4d30910d-4864-6566-685a-7f39805c8f82 |
13/06/2013 10:43:39.4122866 | Information | TaskID=2d092dc2-e073-4e1c-b220-897b52548c63 |
13/06/2013 10:43:39.4122866 | Information | MaxRunTime=06:00:00 |
13/06/2013 10:43:39.4122866 | Information | MachineName=QV_TEST |
13/06/2013 10:43:39.4122866 | Information | Max attempts:1 |
13/06/2013 10:43:39.4122866 | Information | Current Attempt=0 |
13/06/2013 10:43:39.4122866 | Information | Task Dependencies are OK |
13/06/2013 10:43:39.4278866 | Information | Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution. |
13/06/2013 10:43:39.4278866 | Information | Opening "E:\QlikView\Published-Applications\TEST RELOAD.qvw" |
13/06/2013 10:43:39.4278866 | Information | Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader). |
13/06/2013 10:43:39.4278866 | Information | Max retries:5 |
13/06/2013 10:43:39.4278866 | Information | Attempt:01 |
13/06/2013 10:43:39.9582876 | Information | Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=11. |
13/06/2013 10:43:39.9582876 | Information | Loading document "E:\QlikView\Published-Applications\TEST RELOAD.qvw" (0.14 Mb) |
13/06/2013 10:43:40.0050876 | Information | Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=2.08 Mb. Available Physical Memory Before Open=58208.84 Mb. Available Physical Memory After Open=58204.44 Mb. Total Physical Memory=65535.49 Mb. |
13/06/2013 10:43:40.0050876 | Information | Attempted to load the document without data. |
13/06/2013 10:43:40.0050876 | Information | The document was loaded successfully. |
13/06/2013 10:43:40.0050876 | Information | Document was opened successfully |
13/06/2013 10:43:40.0050876 | Information | Starting reload |
13/06/2013 10:43:40.0206877 | Information | QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier. |
13/06/2013 10:43:40.0206877 | Information | Waiting for the document log "E:\QlikView\Published-Applications\TEST RELOAD.qvw" to become available.. |
13/06/2013 10:43:40.0206877 | Information | The Source Document is being reloaded. DocumentPath=E:\QlikView\Published-Applications\TEST RELOAD.qvw |
13/06/2013 10:43:40.0830878 | Information | Found a document log. FileName=E:\QlikView\Published-Applications\TEST RELOAD.qvw.log |
13/06/2013 10:43:40.0830878 | Information | Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20130613\104339 - TEST RELOAD.qvw\DocumentLog.txt |
13/06/2013 10:43:41.0190894 | Information | Reloading. |
13/06/2013 10:43:42.0330912 | Information | Reloading.. |
13/06/2013 10:43:43.0470930 | Information | Reloading... |
13/06/2013 10:43:44.0610948 | Information | Reloading.... |
13/06/2013 10:43:45.0750965 | Information | Reloading..... |
13/06/2013 10:43:46.0890983 | Information | Reloading...... |
13/06/2013 10:43:47.1031001 | Information | Reloading....... |
13/06/2013 10:43:48.1171019 | Information | Reloading........ |
13/06/2013 10:43:49.1311037 | Information | Reloading......... |
13/06/2013 10:43:50.1451055 | Information | Reloading.......... |
13/06/2013 10:43:51.1591072 | Information | Slow down logging. Log every <2> seconds. |
13/06/2013 10:43:51.1591072 | Information | Reloading |
13/06/2013 10:43:53.1871108 | Information | Reloading. |
13/06/2013 10:43:55.2151144 | Information | Reloading.. |
13/06/2013 10:43:57.2431179 | Information | Reloading... |
13/06/2013 10:43:59.2711215 | Information | Reloading.... |
13/06/2013 10:44:01.2991250 | Information | Reloading..... |
13/06/2013 10:44:03.3271286 | Information | Reloading...... |
13/06/2013 10:44:05.3551322 | Information | Reloading....... |
13/06/2013 10:44:07.3831357 | Information | Reloading........ |
13/06/2013 10:44:09.4111393 | Information | Reloading......... |
13/06/2013 10:44:11.4391429 | Information | Reloading.......... |
13/06/2013 10:44:13.4671464 | Information | Slow down logging. Log every <10> seconds. |
13/06/2013 10:44:13.4671464 | Information | Reloading |
13/06/2013 10:44:23.6071642 | Information | Reloading. |
13/06/2013 10:44:33.7471820 | Information | Reloading.. |
13/06/2013 10:44:43.8871998 | Information | Reloading... |
13/06/2013 10:44:54.0272177 | Information | Reloading.... |
13/06/2013 10:45:04.1672355 | Information | Reloading..... |
13/06/2013 10:45:14.3072533 | Information | Reloading...... |
13/06/2013 10:45:24.4472711 | Information | Reloading....... |
13/06/2013 10:45:34.5872889 | Information | Reloading........ |
13/06/2013 10:45:44.7273067 | Information | Reloading......... |
13/06/2013 10:45:54.8673245 | Information | Reloading.......... |
13/06/2013 10:46:05.1633426 | Information | Slow down logging. Log every <60> seconds. |
13/06/2013 10:46:05.1633426 | Information | Reloading |
13/06/2013 10:47:06.0034495 | Information | Reloading. |
And it lasts hours... When max time is reached, it fails.
My inline statement is OK.
I've done what you said, I also tried creating a new statement with the wizard, ...
It doesn't work when QVS reloads (but always works fine in QV desktop).
I have 3 servers with the same configuration: the same qvw file works on 1 server and fails on the 2 others.
I can't see what is the difference.
Does the owner of the services need special rights / access to make a LOAD INLINE?
(I don't know, access to a temp folder, ...)
Hi,
I have just tested this and it works fine for me.
Bill
I working on this case for hours, and I've just found something: if I change the owner of my "QlikViewDistributionService" to "root" (a user in both "Administrators" and "QlikView Administrators" groups), my LOAD INLINE loads fine.
If I use "qvadmin" as owner (only in "QlikView Administrators" group), LOAD INLINE doesn't work.
Is there a reason for LOAD INLINE to need local administrator provileges? (whereas other LOAD statements don't)
Correct me if I'm wrong, but the documentation don't say that the ower of QV services have to be a local administrator (except for clustering matters).
When a LOAD INLINE is scripted, Qvb.exe tries to write a temp file in the root folder (something like "C:\INLDxxX.tmp").
By default, a simple user can't write on the root.
If I give write access to the owner of the services, it works!