VERIFIED SOLUTION i
Dataflow server terminates while using disk sort in parallel
Dataflow server terminates while running plan that uses disk sort in parallel ('DiskSortInputBuffers' registry parameters has a NON-zero value).
Possible root cause of the scenario is parallel processing in disk sort. This is inferred since:
- DC log confirms that 'disk sort' was running before the termination of Dataflow server (logs are not created once server is down).
- Dump analysis confirms that failure module is 'SaTFDSrt' which refers to 'Disk Sort transform'.
UPDATED: August 9, 2018
To avoid Dataflow server termination, set DiskSortInputBuffers in the registry settings to '0'. This enables serial processing in disk sort.
Product Feature: DataFlow Server
- No Downloads