Microsoft KB Archive/271181

= SMS: Interval X Not Found Error in Offersum.log =

Article ID: 271181

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 Q271181



SYMPTOMS
Offer or Advertisement status messages may not populate the Systems Management Server database. When you make Structured Query Language (SQL) tracing available, messages such as the following are recorded in the Offersum.log file:

SQL>>>SELECT OfferID,SiteCode,LastUpdate,Replicate,oi.DisplayInterval,oi.ScheduleToken, OfferRecieved,OfferFailure, ProgramStarted,ProgramSuccess,ProgramFailure FROM OfferStatusSummary o (NOLOCK),OfferStatusSummaryDetail od (NOLOCK), OfferStatusIntervals   oi (NOLOCK) WHERE o.OfferStatusSummaryID = od.OfferStatusSummaryID AND oi.DisplayInterval = od.DisplayInterval AND Replicate != 0 $$ SQL>>>>> Done. $$ Warn>: Interval 8 not found in the OfferSummaryDetail record EN120014 $$  STATMSG: ID=3807 SEV=W LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_OFFER_STATUS_SUMMARIZER&quot; SYS=ECGJ01 SITE=OH1 PID=259 TID=170 GMTDATE=Tue Jul 18 21:38:07.530 2000 ISTR0=&quot;8&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 -or- Info>: Processing replication file... $$  Warn>: Interval 7 not found in the OfferSummaryDetail record EN12000F $$<SMS_OFFER_STATUS_SUMMARIZER><Fri Jul 14 08:37:37.180 2000 Eastern Daylight Time> <thread=66 (0x42)> STATMSG: ID=3807 SEV=W LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_OFFER_STATUS_SUMMARIZER&quot; SYS=ECGJ01 SITE=OH1 PID=258 TID=66 GMTDATE=Fri Jul 14 12:37:37.180 2000 ISTR0=&quot;7&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 $$<SMS_OFFER_STATUS_SUMMARIZER> <Fri Jul 14 08:37:37.180 2000 Eastern Daylight Time><thread=66 (0x42)> Warn>: Interval 7 not found in the OfferSummaryDetail record EN120010 $$<SMS_OFFER_STATUS_SUMMARIZER><Fri Jul 14 08:37:37.180 2000 Eastern Daylight Time> <thread=66 (0x42)> STATMSG: ID=3807 SEV=W LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_OFFER_STATUS_SUMMARIZER&quot; SYS=ECGJ01 SITE=OH1 PID=258 TID=66 GMTDATE=Fri Jul 14 12:37:37.190 2000 ISTR0=&quot;7&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 $$<SMS_OFFER_STATUS_SUMMARIZER> <Fri Jul 14 08:37:37.190 2000 Eastern Daylight Time><thread=66 (0x42)>

<div class="cause_section">

CAUSE
These messages indicate that Systems Management Server is attempting to read the information stored in the DisplayInterval field of either the OfferStatusIntervals table or the OfferStatusSummaryDetail table, one of which may be corrupted.

To determine if this is the cause of the error in your site, follow these steps: <ol> <li>Open Microsoft SQL Query analyzer for SQL 7.0 or Microsoft ISQL/w for SQL 6.5, and then select the Systems Management Server database.</li> <li>Execute the following query against the Systems Management Server database:

SELECT * FROM OFFERSTATUSINTERVALS

</li></ol>

The results set should appear similar to the following table:

If the entries in the DisplayInterval column are not sequential and have a break around 7 or 8, as in the following table, you may see errors like those described in the &quot;Symptoms&quot; section of this article. The OfferStatusSummaryDetail table is probably also corrupted because it stores the same entries. It is for this reason that the Offer status messages are not being reported correctly back to the site.

An incorrectly ordered table may appear similar to the following example:

When the table's format no longer matches the data being passed to it, the data is discarded or not processed. If it is not processed, the data may continue to back up on the computer until the drive is filled.

<div class="workaround_section">

WORKAROUND
If the information in the OfferStatusIntervals table is corrupted, verify whether the OfferStatusSummaryDetail table has been affected and restore the necessary tables from backup copies.

If you have determined that corruption of these tables is the reason status is not being reported back to the site for your offers or advertisements, please contact Microsoft Product Support Services for a resolution. Modifying the Systems Management Server database directly is not supported and may cause irreparable damage to the site's database.

<div class="moreinformation_section">

MORE INFORMATION
If you have specific questions about restoring tables to a SQL database, or or you need more information about your SQL database, please contact a SQL Support Professional for assistance.

Additional query words: prodsms

Keywords: kbadvertisement kbdatabase kbprb kbquery kbstatsum KB271181

-

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

© Microsoft Corporation. All rights reserved.