Hi all,

I have a query which is running fine all the while. However, i encountered a problem recently.When i restored last month data and it was running fine. It is caused by data problem? But the record of the data i run is much less than the last month data.

Error number: 1501, Severity:20,State:1, Message: sort failure.

I have increased the "min memory per query" to higher value but still the same. Any idea?

Thanks 

austen:

Hi all,

I have a query which is running fine all the while. However, i encountered a problem recently.When i restored last month data and it was running fine. It is caused by data problem? But the record of the data i run is much less than the last month data.

Error number: 1501, Severity:20,State:1, Message: sort failure.

I have increased the "min memory per query" to higher value but still the same. Any idea?

Thanks 

 

without more information, can't really help you there. can you post up the query?