Incremental Load failed

venkatasuresh — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Incremental Load failed

narendiran — Fri, 22 Jul 2016 11:31:12 GMT

Hi Venkatasuresh,

Check primary key is strong enough?

Re: Incremental Load failed

Gysbert_Wassenaar — Fri, 22 Jul 2016 11:48:08 GMT

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.

topic Re: Incremental Load failed in QlikView

Incremental Load failed

Re: Incremental Load failed

Re: Incremental Load failed