VERIFIED SOLUTION i
X

Resolve Dataflow server terminatinatin after 'key columns' set in the 'Sort Union transform' are deleted only from one of the input 'column select' transform

Issue

In a plan containing more than one 'Column select transform' and at-least one 'Sort Union transform', when 'key columns' are deleted only from the second input 'column select' transform and not from the first one, the Dataflow server (Sagent Dataflow Service) gets terminated or crashes.

Cause

The 'Sorted union transform' tries accessing the vector of sorting keys based on the size of the keys for the first input dataflow. If the columns are only deleted from the first column select but not from the second 'column select' then the termination/crash does not occur since the vector of sorting keys are accessed based on the size of the keys for the first input dataflow.

Resolution

UPDATED: March 15, 2018


As a workaround, follow either of below steps :
  • Delete the columns from both the input 'column select' transforms
  • When deleting columns from only one of the input column select transform open the 'sorted union transform' dialog and click 'OK' to update the schema.
PS: Deleting columns from only one of the input 'Column Select' transform is an invalid Plan Design scenario and should be avoided.

Environment Details

Product Feature: DataFlow Server

Downloads

  • No Downloads