SMS: When Deleting an Advertisement You Receive a "No Status" Error Message (263359)


The information in this article applies to:

  • Microsoft Systems Management Server 2.0
  • Microsoft Systems Management Server 2.0 SP1
  • Microsoft Systems Management Server 2.0 SP2
This article was previously published under Q263359

SYMPTOMS

If you try to delete an advertisement when Microsoft SQL Server is not running, and the advertisement is not deleted, you receive a "No Status" error message.

CAUSE

The process of deleting an advertisement within the Systems Management Server Administrator console appears to take longer, and the deleted advertisement is no longer displayed. After restarting the SQL service, the deleted advertisement is displayed again. The error messages in the Offersum.log file are the only indication that the advertisement could not be removed.

Here is an example from an Offersum.log file:
Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The handle is invalid.~~ $$<SMS_OFFER_STATUS_SUMMARIZER><Mon Aug 21 10:12:30.296 2000 Pacific Daylight Time><thread=564 (0x234)> Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The handle is invalid.~~ $$<SMS_OFFER_STATUS_SUMMARIZER><Mon Aug 21 10:20:47.015 2000 Pacific Daylight Time><thread=564 (0x234)> Info>: Resetting the default heartbeat timer. It will expire by: Mon Aug 21 11:00:00 2000~ $$<SMS_OFFER_STATUS_SUMMARIZER><Mon Aug 21 10:20:52.031 2000 Pacific Daylight Time><thread=564 (0x234)> ---> SMS_OFFER_STATUS_SUMMARIZER stopping. The exit code is 0xfffffffe $$<SMS_OFFER_STATUS_SUMMARIZER><Mon Aug 21 10:20:52.031 2000 Pacific Daylight Time><thread=564 (0x234)> SMS_OFFER_STATUS_SUMMARIZER stopped $$<SMS_OFFER_STATUS_SUMMARIZER><Mon Aug 21 10:20:52.031 2000 Pacific Daylight Time><thread=564 (0x234)>

WORKAROUND

After the SQL services are running again, you can delete the advertisement.
Modification Type:MinorLast Reviewed:1/14/2006
Keywords:kbBug kbnofix kbprb kbsms200preSP3 KB263359
©2004 Microsoft Corporation. All rights reserved.