My server can't reload application with "LOAD INLINE"

[#1]

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...

[#2]

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...

[jeffmartins]

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

[#4]

Unfortunately, yes, I have applied the licence successfully

[#5]

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.

[#6]

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, ...)

[Bill_Britt]

Hi,

I have just tested this and it works fine for me.

Bill

[#8]

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).

[#9 · Accepted solution]

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!