VERIFIED SOLUTION i

Disk Sort Error while executing plan.

Sagent any version.
 

Cause of issue

Not having enough disk space available in the temporary folder where disk sort transform is creating the temporary files.

Resolution

Change registry parameters for temporary file creation path directory. Add new directory path having enough disk space.

Changes to be made: 

[HKEY_LOCAL_MACHINE\Software\Sagent\DataMart\DC] 
“AllowDiskSort”=1 

[HKEY_LOCAL_MACHINE\Software\Sagent\DataMart\DC] 
"AutomaticDiskSortPath"="D:\\Sagent\\Sort

[HKEY_LOCAL_MACHINE\Software\Sagent\DataMart\TF] 
"DiskSortPath"="D:\\Sagent\\Sort

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sagent\DataMart\TF] 
"DiskSortPath"="D:\\Sagent\\Sort"
 
UPDATED:  April 5, 2017