VERIFIED SOLUTION i

Disk Sort Error while executing plan.

 

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"
 
Environment Details
Sagent any version.
UPDATED:  April 5, 2017