VERIFIED SOLUTION i
Resolve Dataflow server terminatinatin after 'key columns' set in the 'Sort Union transform' are deleted only from one of the input 'column select' transform
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.
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.
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.
Product Feature: DataFlow Server
- No Downloads