Microsoft KB Archive/263359

= SMS: When Deleting an Advertisement You Receive a &quot;No Status&quot; Error Message =

Article ID: 263359

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2.0 Service Pack 1
 * Microsoft Systems Management Server 2.0 Service Pack 2

-



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 &quot;No Status&quot; 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. $$ Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The handle is invalid. $$ Info>: Resetting the default heartbeat timer. It will expire by: Mon Aug 21 11:00:00 2000~ $$ ---> SMS_OFFER_STATUS_SUMMARIZER stopping. The exit code is 0xfffffffe $$ SMS_OFFER_STATUS_SUMMARIZER stopped $$<Mon Aug 21 10:20:52.031 2000 Pacific Daylight Time><thread=564 (0x234)>

<div class="workaround_section">

WORKAROUND
After the SQL services are running again, you can delete the advertisement.

Additional query words: prodsms

Keywords: kbbug kbnofix kbprb kbsms200presp3 KB263359

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.