Results 1 to 6 of 6

Thread: Error: 17883, Severity: 1, State: 0

  1. #1
    Join Date
    Oct 2003
    Posts
    24

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    It's fixed in sql2k sp3a.

  3. #3
    Join Date
    Oct 2003
    Posts
    24
    Thanks for your reply.

    What about applying SP4.

    Regards,

    Albert

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    It's better.

  5. #5
    Join Date
    Oct 2003
    Posts
    24
    I will try it.

    Thanks,

    Albert

  6. #6
    Join Date
    Mar 2008
    Posts
    1

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •