1 Reply Latest reply: Oct 30, 2014 10:58 AM by Jin Kim RSS

    Reload fail

      Hi folks, having a trouble here that reloading a qvw on QMC fails but has no problem reloading it manually on my local desktop. Here's the log I regarding the failed reload-

       

      (2014-10-29 16:32:12) Information: Starting task 'Production/Data Generator/Exposure Analysis Data Generator/test_server.qvw'. Id:dc368a83-e227-4c4a-b7b2-4e45a96cf761. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

       

       

      (2014-10-29 16:32:12) Information: Entering Task Execution.

       

       

      (2014-10-29 16:32:12) Information: ClusterID=1

       

       

      (2014-10-29 16:32:12) Information: QDSID=0505bb8a-8759-7f03-3bec-b1d95bef63d2

       

       

      (2014-10-29 16:32:12) Information: TaskID=dc368a83-e227-4c4a-b7b2-4e45a96cf761

       

       

      (2014-10-29 16:32:12) Information: MaxRunTime=06:00:00

       

       

      (2014-10-29 16:32:12) Information: MachineName=NYC-QLIK01

       

       

      (2014-10-29 16:32:12) Information: Max attempts:1

       

       

      (2014-10-29 16:32:12) Information: Current Attempt=0

       

       

      (2014-10-29 16:32:12) Information: Task Dependencies are OK

       

       

      (2014-10-29 16:32:12) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

       

       

      (2014-10-29 16:32:12) Information: Opening "\\NYC-_________\COMMON\RISK\QLIKVIEW\PRODUCTION\Data Generator\Exposure Analysis Data Generator\test_server.qvw"

       

       

      (2014-10-29 16:32:12) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

       

       

      (2014-10-29 16:32:12) Information: Max retries:5

       

       

      (2014-10-29 16:32:12) Information: Attempt:01

       

       

      (2014-10-29 16:32:12) Information: Opened the QlikView Engine successfully. ProcessID=6732

       

       

      (2014-10-29 16:32:12) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=237.

       

       

      (2014-10-29 16:32:12) Information: Loading document "\\NYC-_________\COMMON\RISK\QLIKVIEW\PRODUCTION\Data Generator\Exposure Analysis Data Generator\test_server.qvw" (0.15 Mb)

       

       

      (2014-10-29 16:32:13) Information: Physical FileSize=0.15 Mb. Memory Allocation Delta for this file=2.63 Mb. Available Physical Memory Before Open=11276.44 Mb. Available Physical Memory After Open=11272.76 Mb. Total Physical Memory=16383.49 Mb.

       

       

      (2014-10-29 16:32:13) Information: Attempted to load the document without data.

       

       

      (2014-10-29 16:32:13) Information: The document was loaded successfully.

       

       

      (2014-10-29 16:32:13) Information: Document was opened successfully

       

       

      (2014-10-29 16:32:13) Information: Starting reload

       

       

      (2014-10-29 16:32:13) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

       

       

      (2014-10-29 16:32:13) Information: The Source Document is being reloaded. DocumentPath=\\NYC-_________\COMMON\RISK\QLIKVIEW\PRODUCTION\Data Generator\Exposure Analysis Data Generator\test_server.qvw

       

       

      (2014-10-29 16:32:13) Information: The Source Document reload complete. DocumentPath=\\NYC-_________\COMMON\RISK\QLIKVIEW\PRODUCTION\Data Generator\Exposure Analysis Data Generator\test_server.qvw

       

       

      (2014-10-29 16:32:13) Information: Memory Allocation Delta for this file=1.13 Mb. Available Physical Memory Before Reload=11272.75 Mb. Available Physical Memory After Reload=11268.25 Mb. Total Physical Memory=11268.25 Mb.

       

       

      (2014-10-29 16:32:13) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\NYC-_________\COMMON\RISK\QLIKVIEW\PRODUCTION\Data Generator\Exposure Analysis Data Generator\test_server.qvw.

       

       

      (2014-10-29 16:32:13) Information: Closing the document.

       

       

      (2014-10-29 16:32:14) Information: Closed the QlikView Engine successfully. ProcessID=6732

       

       

      (2014-10-29 16:32:14) Error: The task "Production/Data Generator/Exposure Analysis Data Generator/test_server.qvw" failed. Exception:

       

       

      (2014-10-29 16:32:14) Error: 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=\\NYC-_________\COMMON\RISK\QLIKVIEW\PRODUCTION\Data Generator\Exposure Analysis Data Generator\test_server.qvw.

       

       

      (2014-10-29 16:32:14) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

       

       

      (2014-10-29 16:32:14) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

       

       

      (2014-10-29 16:32:14) Error:    --- End of inner exception stack trace ---

       

       

      (2014-10-29 16:32:14) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

       

       

      (2014-10-29 16:32:14) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

       

       

      (2014-10-29 16:32:14) Error:    --- End of inner exception stack trace ---

       

       

      (2014-10-29 16:32:14) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

       

       

      (2014-10-29 16:32:14) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

       

       

      (2014-10-29 16:32:14) Information: Task Execute Duration=00:00:01.7004218

       

       

      (2014-10-29 16:32:14) Information: TaskResult.status=Finished

       

       

      (2014-10-29 16:32:14) Information: Notifying all triggers of new state:FinishedWithErrors

       

       

      So I get the following error

      'Error: The Source Document was NOT reloaded successfully. DocumentPath='

      It's likely to do with my connection to the SQL server because I'm only reading one single table from the SQL database

       

      If anybody has encountered this error before and arrived at a solution, please do share! I've also read similar threads on Qlik community but no recommendations seem to work here. Thanks!