6 Replies Latest reply: Mar 20, 2013 12:43 PM by Bill Britt RSS

    Publisher Error on Load

    Raghu Dubey

      Hi All,

       

      I have configured a job on Publisher for the first time. Here is the error I get. I am able to see that the QVD file gets generated and I setup the job to write to a log file. All the logs show that records got loaded and QVD generates as usual. Application log also did not show any error. Why does the publisher job Fail then will below errors? am I doing something wrong?

       

      3/19/2013 16:51:31.7127717InformationStarting task 'DataViz_Product_Dim_Daily_Load_Test'. Id:490c3283-676e-49ca-af16-b8cf4e5c343c. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
      3/19/2013 16:51:31.7127717InformationEntering Task Execution.
      3/19/2013 16:51:31.7127717InformationClusterID=1
      3/19/2013 16:51:31.7127717InformationQDSID=cfcfda3e-3f29-32b0-1d4c-ab3c43763910
      3/19/2013 16:51:31.7127717InformationTaskID=490c3283-676e-49ca-af16-b8cf4e5c343c
      3/19/2013 16:51:31.7127717InformationMaxRunTime=1.00:00:00
      3/19/2013 16:51:31.7127717InformationMachineName=QLIKVIEWD1-JSMV
      3/19/2013 16:51:31.7127717InformationMax attempts:1
      3/19/2013 16:51:31.7127717InformationCurrent Attempt=0
      3/19/2013 16:51:31.7127717InformationTask Dependencies are OK
      3/19/2013 16:51:31.7283967InformationDocument is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
      3/19/2013 16:51:31.7283967InformationOpening "D:\Raghu\Dimensions\Product_Dimension_Daily_Load_QVD_Generator.qvw"
      3/19/2013 16:51:31.7283967InformationAllocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).
      3/19/2013 16:51:31.7283967InformationMax retries:5
      3/19/2013 16:51:31.7283967InformationAttempt:01
      3/19/2013 16:51:33.1815217InformationAllocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=11.
      3/19/2013 16:51:33.1815217InformationLoading document "D:\Raghu\Dimensions\Product_Dimension_Daily_Load_QVD_Generator.qvw" (0.16 Mb)
      3/19/2013 16:51:33.3690217InformationPhysical FileSize=0.16 Mb. Memory Allocation Delta for this file=2.64 Mb. Available Physical Memory Before Open=10726.01 Mb. Available Physical Memory After Open=10719.84 Mb. Total Physical Memory=16383.55 Mb.
      3/19/2013 16:51:33.3690217InformationAttempted to load the document without data.
      3/19/2013 16:51:33.3690217InformationThe document was loaded successfully.
      3/19/2013 16:51:33.3690217InformationDocument was opened successfully
      3/19/2013 16:51:33.3690217InformationStarting reload
      3/19/2013 16:51:33.4158967InformationQlikView->Settings->Document Peferences->Generate Logfile in document is not set.
      3/19/2013 16:51:33.4158967InformationThe Source Document is being reloaded. DocumentPath=D:\Raghu\Dimensions\Product_Dimension_Daily_Load_QVD_Generator.qvw
      3/19/2013 16:51:34.3690217InformationReloading.
      3/19/2013 16:51:34.7127717InformationThe Source Document reload complete. DocumentPath=D:\Raghu\Dimensions\Product_Dimension_Daily_Load_QVD_Generator.qvw
      3/19/2013 16:51:34.7127717InformationMemory Allocation Delta for this file=17.70 Mb. Available Physical Memory Before Reload=10719.83 Mb. Available Physical Memory After Reload=10705.10 Mb. Total Physical Memory=10705.10 Mb.
      3/19/2013 16:51:35.3690217InformationReloading..
      3/19/2013 16:51:35.4627717ErrorThe Source Document was NOT reloaded successfully. DocumentPath=D:\Raghu\Dimensions\Product_Dimension_Daily_Load_QVD_Generator.qvw.
      3/19/2013 16:51:35.5096467InformationClosing the document.
      3/19/2013 16:51:36.1346467InformationClosed the QlikView Engine successfully. ProcessID=1284
      3/19/2013 16:51:36.1346467ErrorThe task "DataViz_Product_Dim_Daily_Load_Test" failed. Exception:

      QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\Raghu\Dimensions\Product_Dimension_Daily_Load_QVD_Generator.qvw.

         at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

         at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

         --- End of inner exception stack trace ---

         at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

         at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

         --- End of inner exception stack trace ---

         at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

         at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

      3/19/2013 16:51:36.1346467InformationTask Execute Duration=00:00:04.4218750
      3/19/2013 16:51:36.1346467InformationTaskResult.status=Finished
      3/19/2013 16:51:36.1346467InformationNotifying all triggers of new state:FinishedWithErrors
      3/19/2013 16:51:36.1346467InformationNotifying all triggers of new state:FinishedWithErrors - completed
      3/19/2013 16:51:36.1502717InformationSaving Task Result
        • Re: Publisher Error on Load
          Raghu Dubey

          Hi All,

           

          I found one thing. I enabled application log.

          When I run the file from QlikView Publisher. The end of my log file is:

           

          ====

          2013-03-19 19:13:02: 0027      Directory J:\7_Logs\Information\

          2013-03-19 19:13:02: 0028      STORE Log into Product_Dimensions.txt (txt)

          2013-03-19 19:13:02: 0029      SET vLogQvd=

          2013-03-19 19:13:02: 0030    END SUB

          2013-03-19 19:13:02: 0033    STORE Product_Dimensions INTO J:\\Layer_1\Dimensions\Product_Dimensions.QVD

          2013-03-19 19:13:02:         General Script Error

          2013-03-19 19:13:02:         Execution Failed

          2013-03-19 19:13:02:      Execution finished.

          ============

           

           

          When run from Desktop manually:

          --------

          2013-03-19 19:10:04: 0026     
          2013-03-19 19:10:04:          1 fields found: LogMessage, 1 lines fetched

          2013-03-19 19:10:04: 0027      Directory J:\7_Logs\Information\

          2013-03-19 19:10:04: 0028      STORE Log into Product_Dimensions.txt (txt)

          2013-03-19 19:10:04: 0029      SET vLogQvd=

          2013-03-19 19:10:04: 0030    END SUB

          2013-03-19 19:10:04: 0033    STORE Product_Dimensions INTO J:\3_QVD\Layer_1\Dimensions\Product_Dimensions.QVD

          2013-03-19 19:10:05: 0035  ENDIF

          2013-03-19 19:10:05: 0036  DROP TABLE Product_Dimensions

          2013-03-19 19:10:05:      Execution finished.

          ========

           

          Seems like Publisher is not able to execute the Drop Table command....is it related to security.

          I am the local admin of the machine and also on the QliKView Administrator group.

          I have enables everything on the Security tab of document properties.

           

          Please help.

           

           

          Thanks

          Raghu