Error 1501: Sort Failure Severity:20 State:1

[JVKAdmin]

Hi,

I'm intermittantly getting this SQL Error in the event log on our SQL Server 2000 Enterprise Server.

"Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 12/14/2006
Time: 6:25:52 AM
User: *************** Blanked out for security
Computer: *************** Blanked out for security
Description:
Error: 1501, Severity: 20, State: 1
Sort failure. "

We have tried tracking this problem for a long time now. There is no consistant pattern occurring except that the reports typically get larger then during our off-season (were a highly seasonal business) but this problem happens intermittantly for different instances of the same Crystal report. The report is run from Crystal Reports XI/ Business Objects XI Server.

I have read the little information there is on the internet regarding this and tried to increase buffer memory as described in some cases to no avail.

I am wondering if anyone has come across this problem and managed to solve it or at least pointing me in the right direction ?

Any insight would be appreciated.

Thanks.

 

[Catadmin]

Have you run Profiler against the SQL Server this report is running against? It may give you a better clue as to what the error means.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[JVKAdmin]

Catadmin,

Hi,

No I haven't run profiler. I must confess I'm not that SQL Server literate. I mostly manage the systems but don't delve into SQL Server much.

Can you explain what profiler does and how I would use it ?

 

[Catadmin]

SQL Profiler can be found in the Programs menu under Microsoft SQL Server in your usual Windows OS start menu bar. It is a tool which monitors activity on a given database and can actually tell you what queries are running, who is running them, how long they're taking and give you information on locks, deadlocks, etc.

It is a beautiful, wonderful tool for seeing exactly what the SQL Server is doing at a given moment in time. Look up "Profiler" in Books Online for more information. There's too much information to give on the forum, unfortunately.

You can also filter your traces to specific logins if your Crystal applications are using one that is unique to them.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"