Incremental Load failed

[venkatasuresh]

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

Error

The 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.7432467	Information	Task Execute Duration=01:31:52.2209403
21/07/2016 18:36:52.7432467	Information	Sending Alert mail
21/07/2016 18:37:00.7304467	Information	TaskResult.status=Finished
21/07/2016 18:37:01.6664467	Information	Notifying all triggers of new state:FinishedWithErrors
21/07/2016 18:37:01.6820467	Information	Notifying all triggers of new state:FinishedWithErrors - completed
21/07/2016 18:37:01.6820467	Information	Saving Task Result

Document log::

PFA!

! please give me your comments

thanks in advance

Thanks,

Venkatasuresh.V

[narendiran]

Hi Venkatasuresh,

Check primary key is strong enough?

[Gysbert_Wassenaar]

21/07/2016 18:35:35.9288467	Information	21/07/2016 17:54:00: 0067        STORE OBSERVATION INTO \\...\QlikView\SourceDocs\Production\QVDData\OBSERVATION.qvd
21/07/2016 18:36:31.6052467	Information	21/07/2016 18:35:35:             General Script Error
21/07/2016 18:36:31.6208467	Information	21/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.