VERIFIED SOLUTION i
X

Dataflow server terminates while using disk sort in parallel

Issue

Dataflow server terminates while running plan that uses disk sort in parallel ('DiskSortInputBuffers' registry parameters has a NON-zero value). 

Cause

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

Resolution

UPDATED: August 9, 2018


To avoid Dataflow server termination, set DiskSortInputBuffers in the registry settings to '0'. This enables serial processing in disk sort.

Environment Details

Product Feature: DataFlow Server

Downloads

  • No Downloads