Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatasuresh
Creator
Creator

Incremental Load failed

Hi All,

In My project the incremental load Task runs every 5min based on the EDX, its talking to Sequel:Database.

and full load task runs every mid night 3:00 am,after full load QVD sizes are


1.Obsrvation.qvd -1.50 MB

2.Procedure.qvd-316 MB


once incremental load start running those QVD's are growing upto ("Observatin.qvd-14 GB ,Procedure.qvd 4GB")


then Incremental Task got failed, bellow the error log

Task log::

21/07/2016 18:36:51.2924467ErrorThe task "IncrementalLoadProdData" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.ThreadPoolJobStillRunningException: Aborting reload. Error: QDSMain.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)

21/07/2016 18:36:52.7432467InformationTask Execute Duration=01:31:52.2209403
21/07/2016 18:36:52.7432467InformationSending Alert mail
21/07/2016 18:37:00.7304467InformationTaskResult.status=Finished
21/07/2016 18:37:01.6664467InformationNotifying all triggers of new state:FinishedWithErrors
21/07/2016 18:37:01.6820467InformationNotifying all triggers of new state:FinishedWithErrors - completed
21/07/2016 18:37:01.6820467InformationSaving Task Result

Document log::


PFA!


! please give me your comments

thanks in advance

Thanks,

Venkatasuresh.V

2 Replies
narendiran
Partner - Creator
Partner - Creator

Hi Venkatasuresh,

Check primary key is strong enough?

Gysbert_Wassenaar

21/07/2016 18:35:35.9288467Information21/07/2016 17:54:00: 0067        STORE OBSERVATION INTO \\...\QlikView\SourceDocs\Production\QVDData\OBSERVATION.qvd
21/07/2016 18:36:31.6052467Information21/07/2016 18:35:35:             General Script Error
21/07/2016 18:36:31.6208467Information21/07/2016 18:36:31:             Execution Failed

That means Qlikview couldn't write to that qvd file. Perhaps it was locked by another process. Or you ran out of disk space.


talk is cheap, supply exceeds demand