Error: 17883, Severity: 1, State: 0

Printable View

02-14-2006, 04:54 AM
Aohene

Error: 17883, Severity: 1, State: 0

Hello,

The following error message has been appearing in my errorlog file ever since December, 2005.

The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x03743068.
Error: 17883, Severity: 1, State: 0

It usually happens during a daily backup to tape. I have two CPUs on the server. I have done an extensive search on the WEB for a solution but to no avail.

I would be grateful if you could help me out.

Thanks in advance.

Regards,

Albert
02-14-2006, 09:47 AM
rmiao

It's fixed in sql2k sp3a.
02-14-2006, 09:52 AM
Aohene

Thanks for your reply.

What about applying SP4.

Regards,

Albert
02-14-2006, 11:58 AM
rmiao

It's better.
02-15-2006, 06:18 AM
Aohene

I will try it.

Thanks,

Albert
03-28-2008, 11:53 AM
stever2008

SQL server 2000 Error: 17883, Severity: 1, State: 0

I am having a similar error which SQL 2000 service pack 3a does not correct.

Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x021F7F20.

In addition, when I try to open the database, for instance to add information to a table, the enterprise manager console immediately hangs. I believe this is due to the fact that my SQL 2000 server resides on a domain controller although this problem did not occur until a month ago and had been functioning correctly after the initial install. The database IS also still functional, I simply can't access it for management purposes. When I attempted to reinstall sp3a, the installer hangs at the "validating user" step. This occurs whether I use a Windows or SQL user account (even the SA account hangs on the validating password step) to run the service pack install.