3 Replies Latest reply: Feb 27, 2012 10:00 AM by M Paeper RSS

    QV10 SBS - model reload runs but fails

    M Paeper

      Running QV10 SR4 small business edition.

       

      QV models located on local server drive and SMB shared with the network.

       

      The xls source data file to update the model is in a subfolder on the same shared Qlikview path. i.e. D:\Qlikview\20 MASTER DATA

       

      Both the paths to the data are local folders as far as QV server goes.

       

      On server I set a scheduled reload task to run, but in the logs I see this."Source Document was NOT reloaded successfully"

       

       

      (2012-02-21 11:37:53) Information: Executing ClusterID=1, QDSID=cdf754c0-1e8b-fe7e-ed7e-65864483eb5b QDSMain.DistributeTask

      (2012-02-21 11:37:53) Information: Starting task "FinishingDashboard.qvw" (Attempt 1 of 1)

      (2012-02-21 11:37:53) Information: Max run time: 06:00:00

      (2012-02-21 11:37:53) Information: Document is marked for refresh; Initializing Reload.

      (2012-02-21 11:37:53) Information: Opening "D:\Qlikview\40 MODELS\FinishingDashboard.qvw"

      (2012-02-21 11:37:53) Information: Allocating QlikView Engine

      (2012-02-21 11:37:53) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

      (2012-02-21 11:37:53) Information: An instance of the QlikView Engine is being created

      (2012-02-21 11:37:53) Information: Starting QlikView Engine

      (2012-02-21 11:37:54) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=6

      (2012-02-21 11:37:54) Information: Loading document "D:\Qlikview\40 MODELS\FinishingDashboard.qvw" (0.16 Mb)

      (2012-02-21 11:37:54) Information: Physical FileSize=0.16 Mb. Memory Allocation Delta for this file=7.87 Mb. Available Physical Memory Before Open=14128.40 Mb. Available Physical Memory After Open=14119.85 Mb. Total Physical Memory=16378.94 Mb.

      (2012-02-21 11:37:54) Information: The document was loaded successfully.

      (2012-02-21 11:37:54) Information: Initializing Checkout (0), Loading document (968), Initializing load (968), Checking read (968), Creating QlikView Engine (968), Checking Size (968), Load (983), Load Completed (1030), Tables read (1108), Opened successfully (1139)

      (2012-02-21 11:37:54) Information: Document was opened successfully

      (2012-02-21 11:37:54) Information: Opened successfully (0)

      (2012-02-21 11:37:54) Information: Starting reload

      (2012-02-21 11:37:54) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

      (2012-02-21 11:37:54) Information: The Source Document is being reloaded. DocumentPath=D:\Qlikview\40 MODELS\FinishingDashboard.qvw

      (2012-02-21 11:37:54) Information: The Source Document reload complete. DocumentPath=D:\Qlikview\40 MODELS\FinishingDashboard.qvw

      (2012-02-21 11:37:54) Information: Memory Allocation Delta for this file=0.00 Mb. Available Physical Memory Before Reload=14119.88 Mb. Available Physical Memory After Reload=14119.47 Mb. Total Physical Memory=14119.47 Mb.

      (2012-02-21 11:37:54) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview\40 MODELS\FinishingDashboard.qvw.

      (2012-02-21 11:37:54) Information: Initializing Reload (0), Finished (125)

      (2012-02-21 11:37:54) Error: Reload failed.

      (2012-02-21 11:37:55) Information: Closing the document.

      (2012-02-21 11:37:55) Information: Closed the QlikView Engine successfully. ProcessID=4236

      (2012-02-21 11:37:55) Information: Initializing (0), Finished (281)

      (2012-02-21 11:37:55) Error: Reload failed. Distribution skipped.

      (2012-02-21 11:37:55) Error: The task "FinishingDashboard.qvw" failed. ErrorCount=3

       

      I tried with a different model - same issue - it runs but fails to reload sucessfully

       

       

      (2012-02-21 11:29:17) Information: Executing ClusterID=1, QDSID=cdf754c0-1e8b-fe7e-ed7e-65864483eb5b QDSMain.DistributeTask

      (2012-02-21 11:29:17) Information: Starting task "OperationsDashboard.qvw" (Attempt 1 of 1)

      (2012-02-21 11:29:17) Information: Max run time: 06:00:00

      (2012-02-21 11:29:17) Information: Document is marked for refresh; Initializing Reload.

      (2012-02-21 11:29:17) Information: Opening "D:\Qlikview\40 MODELS\OperationsDashboard.qvw"

      (2012-02-21 11:29:17) Information: Allocating QlikView Engine

      (2012-02-21 11:29:17) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

      (2012-02-21 11:29:17) Information: An instance of the QlikView Engine is being created

      (2012-02-21 11:29:17) Information: Starting QlikView Engine

      (2012-02-21 11:29:18) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=3

      (2012-02-21 11:29:18) Information: Loading document "D:\Qlikview\40 MODELS\OperationsDashboard.qvw" (13.59 Mb)

      (2012-02-21 11:29:19) Information: Loading. LoadTime=00:00:01.0140018

      (2012-02-21 11:29:19) Information: Physical FileSize=13.59 Mb. Memory Allocation Delta for this file=60.73 Mb. Available Physical Memory Before Open=14159.55 Mb. Available Physical Memory After Open=14098.99 Mb. Total Physical Memory=16378.94 Mb.

      (2012-02-21 11:29:19) Information: The document was loaded successfully.

      (2012-02-21 11:29:19) Information: Initializing Checkout (0), Loading document (968), Initializing load (968), Checking read (968), Creating QlikView Engine (968), Checking Size (983), Load (983), Load Completed (1826), Tables read (1997), Opened successfully (2028)

      (2012-02-21 11:29:19) Information: Document was opened successfully

      (2012-02-21 11:29:19) Information: Opened successfully (0)

      (2012-02-21 11:29:19) Information: Starting reload

      (2012-02-21 11:29:19) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

      (2012-02-21 11:29:19) Information: The Source Document is being reloaded. DocumentPath=D:\Qlikview\40 MODELS\OperationsDashboard.qvw

      (2012-02-21 11:29:19) Information: The Source Document reload complete. DocumentPath=D:\Qlikview\40 MODELS\OperationsDashboard.qvw

      (2012-02-21 11:29:19) Information: Memory Allocation Delta for this file=17.93 Mb. Available Physical Memory Before Reload=14099.02 Mb. Available Physical Memory After Reload=14096.40 Mb. Total Physical Memory=14096.40 Mb.

      (2012-02-21 11:29:19) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview\40 MODELS\OperationsDashboard.qvw.

      (2012-02-21 11:29:19) Information: Initializing Reload (0), Finished (608)

      (2012-02-21 11:29:19) Error: Reload failed.

      (2012-02-21 11:29:19) Information: Closing the document.

      (2012-02-21 11:29:20) Information: Closed the QlikView Engine successfully. ProcessID=3892

      (2012-02-21 11:29:20) Information: Initializing (0), Finished (281)

      (2012-02-21 11:29:20) Error: Reload failed. Distribution skipped.

      (2012-02-21 11:29:20) Error: The task "OperationsDashboard.qvw" failed. ErrorCount=3

        • QV10 SBS - model reload runs but fails
          Daniel Rozental

          Make sure the "generate log file" option is checked, then run again and check the application log. You should be able to find it in the same folder as the qvw file, same name with a .log extension.qv1.png

          • QV10 SBS - model reload runs but fails
            Bill Britt

            What does the document log show?

              • Re: QV10 SBS - model reload runs but fails
                M Paeper

                Hi Bill,

                 

                Hmmm, yes interesting - well 1st Q would be "what document log", so thanks for that Daniel. I'd seen the feature but never enabled it because I couldnt see the point or relevance to what I was doing. Now I do.

                 

                I enabled it, found the logs and got pointed in the right direction. Model 1 was showing me "cannot access source data file or some such - an XLSX - when creating the model I'd mapped a local drive from a shared network folder, i.e. my model was fetching data from location x:\mysharedfolder. After checking permissions etc which I knew were OK I figured why ... I hadnt mapped that same location on the QV server where clearly the QV scheduler engine was running from - in hindsight my blindspot was assuming that since share was local folder on QV server that QV would find it, but my script referred to a mapped drive location and not the local server folder which was shared. I entered a UNC location of the equivalent of //myqlikviewserver/mysharedfolder into the model load script saved it and all was well. The scheduling running of the script now works fine.

                 

                The 2nd model, was giving me a general script error in the doc log - I opened the model ran the script refresh manually - saw no errors - then tried again running it scheduled and the log reports success.

                 

                Thanks for pointing me in the direction of the doc logs, once I saw those I could understand and work with - at least in case 1. case 2 I'll put down as an aberation, because I changed nothing consiously but it works now as well.

                 

                Issue resolved, thanks all for your sterling assistance.