Agent Job - Fail due to memory
Hi,
Have an Agent Job that was running without any issues, but within the latest few days sometimes fail due to:
Update From Worksheets:Error: A buffer failed while allocating 104787192 bytes. |
We have increased the memory to 90GB and we still have this issue, but is intermittent, some days run, some days failed, we are somewhat confused so any help is very much appreciated, the error messages are always the same, no variance on the bytes volumes!!
Message | Message Source Name | Subcomponent Name |
Update From Worksheets:Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Excel Source returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. | Update From Worksheets | SSIS.Pipeline |
Update From Worksheets:Error: The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E. | Update From Worksheets | Excel Source [2] |
Update From Worksheets:Error: The system reports 78 percent memory load. There are 103078682624 bytes of physical memory with 22445264896 bytes free. There are 2147352576 bytes of virtual memory with 666824704 bytes free. The paging file has 113562497024 bytes with 32454103040 bytes free. | Update From Worksheets |
|
Update From Worksheets:Error: A buffer failed while allocating 104787192 bytes. | Update From Worksheets |
|
Thanks in advance,