8 Replies Latest reply: Jun 13, 2013 9:57 AM by Nicolas MARTIN RSS

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

    Nicolas MARTIN

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

        • Re: My server can't reload application with "LOAD INLINE"
          Nicolas MARTIN

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

          • Re: My server can't reload application with "LOAD INLINE"
            Jefferson Martins

            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

              • Re: My server can't reload application with "LOAD INLINE"
                Nicolas MARTIN

                Unfortunately, yes, I have applied the licence successfully

                  • Re: My server can't reload application with "LOAD INLINE"
                    Nicolas MARTIN

                    Here is the log file:

                     

                     

                     

                    13/06/2013 10:43:39.4122866InformationStarting 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.4122866InformationEntering Task Execution.
                    13/06/2013 10:43:39.4122866InformationClusterID=1
                    13/06/2013 10:43:39.4122866InformationQDSID=4d30910d-4864-6566-685a-7f39805c8f82
                    13/06/2013 10:43:39.4122866InformationTaskID=2d092dc2-e073-4e1c-b220-897b52548c63
                    13/06/2013 10:43:39.4122866InformationMaxRunTime=06:00:00
                    13/06/2013 10:43:39.4122866InformationMachineName=QV_TEST
                    13/06/2013 10:43:39.4122866InformationMax attempts:1
                    13/06/2013 10:43:39.4122866InformationCurrent Attempt=0
                    13/06/2013 10:43:39.4122866InformationTask Dependencies are OK
                    13/06/2013 10:43:39.4278866InformationDocument is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
                    13/06/2013 10:43:39.4278866InformationOpening "E:\QlikView\Published-Applications\TEST RELOAD.qvw"
                    13/06/2013 10:43:39.4278866InformationAllocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
                    13/06/2013 10:43:39.4278866InformationMax retries:5
                    13/06/2013 10:43:39.4278866InformationAttempt:01
                    13/06/2013 10:43:39.9582876InformationAllocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=11.
                    13/06/2013 10:43:39.9582876InformationLoading document "E:\QlikView\Published-Applications\TEST RELOAD.qvw" (0.14 Mb)
                    13/06/2013 10:43:40.0050876InformationPhysical 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.0050876InformationAttempted to load the document without data.
                    13/06/2013 10:43:40.0050876InformationThe document was loaded successfully.
                    13/06/2013 10:43:40.0050876InformationDocument was opened successfully
                    13/06/2013 10:43:40.0050876InformationStarting reload
                    13/06/2013 10:43:40.0206877InformationQlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
                    13/06/2013 10:43:40.0206877InformationWaiting for the document log "E:\QlikView\Published-Applications\TEST RELOAD.qvw" to become available..
                    13/06/2013 10:43:40.0206877InformationThe Source Document is being reloaded. DocumentPath=E:\QlikView\Published-Applications\TEST RELOAD.qvw
                    13/06/2013 10:43:40.0830878InformationFound a document log. FileName=E:\QlikView\Published-Applications\TEST RELOAD.qvw.log
                    13/06/2013 10:43:40.0830878InformationWriting documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20130613\104339 - TEST RELOAD.qvw\DocumentLog.txt
                    13/06/2013 10:43:41.0190894InformationReloading.
                    13/06/2013 10:43:42.0330912InformationReloading..
                    13/06/2013 10:43:43.0470930InformationReloading...
                    13/06/2013 10:43:44.0610948InformationReloading....
                    13/06/2013 10:43:45.0750965InformationReloading.....
                    13/06/2013 10:43:46.0890983InformationReloading......
                    13/06/2013 10:43:47.1031001InformationReloading.......
                    13/06/2013 10:43:48.1171019InformationReloading........
                    13/06/2013 10:43:49.1311037InformationReloading.........
                    13/06/2013 10:43:50.1451055InformationReloading..........
                    13/06/2013 10:43:51.1591072InformationSlow down logging. Log every <2> seconds.
                    13/06/2013 10:43:51.1591072InformationReloading
                    13/06/2013 10:43:53.1871108InformationReloading.
                    13/06/2013 10:43:55.2151144InformationReloading..
                    13/06/2013 10:43:57.2431179InformationReloading...
                    13/06/2013 10:43:59.2711215InformationReloading....
                    13/06/2013 10:44:01.2991250InformationReloading.....
                    13/06/2013 10:44:03.3271286InformationReloading......
                    13/06/2013 10:44:05.3551322InformationReloading.......
                    13/06/2013 10:44:07.3831357InformationReloading........
                    13/06/2013 10:44:09.4111393InformationReloading.........
                    13/06/2013 10:44:11.4391429InformationReloading..........
                    13/06/2013 10:44:13.4671464InformationSlow down logging. Log every <10> seconds.
                    13/06/2013 10:44:13.4671464InformationReloading
                    13/06/2013 10:44:23.6071642InformationReloading.
                    13/06/2013 10:44:33.7471820InformationReloading..
                    13/06/2013 10:44:43.8871998InformationReloading...
                    13/06/2013 10:44:54.0272177InformationReloading....
                    13/06/2013 10:45:04.1672355InformationReloading.....
                    13/06/2013 10:45:14.3072533InformationReloading......
                    13/06/2013 10:45:24.4472711InformationReloading.......
                    13/06/2013 10:45:34.5872889InformationReloading........
                    13/06/2013 10:45:44.7273067InformationReloading.........
                    13/06/2013 10:45:54.8673245InformationReloading..........
                    13/06/2013 10:46:05.1633426InformationSlow down logging. Log every <60> seconds.
                    13/06/2013 10:46:05.1633426InformationReloading
                    13/06/2013 10:47:06.0034495InformationReloading.

                     

                     

                    And it lasts hours... When max time is reached, it fails.

                • Re: My server can't reload application with "LOAD INLINE"
                  Nicolas MARTIN

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

                  • Re: My server can't reload application with "LOAD INLINE"
                    Bill Britt

                    Hi,

                     

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

                     

                    Bill

                      • Re: My server can't reload application with "LOAD INLINE"
                        Nicolas MARTIN

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