Sort Execution failure in DI studio

Reply
Contributor
Posts: 33

Sort Execution failure in DI studio

Hi,

Iam getting this error in extract transform of DI studio.

Error: Sort execution failure.

Although I have not used any order by clause in extract. Please suggest the reason for this error.

Vishal

Frequent Contributor
Posts: 85

Re: Sort Execution failure in DI studio

Depending on what you're doing, an Extract transform (SQL) may perform a sort without an order by clause being specified. 

If so, this error is "typically caused by a lack of disk space or memory or a less-than-optimal system option setting".  See 39705 - Troubleshooting Sort Initialization and Sort Execution Failure errors in SQL procedures in W...

When I get an unhelpful message like this, I always start with searching the SAS support site.

Hope this helps a bit.

Ask a Question
Discussion stats
  • 1 reply
  • 315 views
  • 0 likes
  • 2 in conversation