Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Maintenance error in CM 07?

7 views
Skip to first unread message

spac...@yahoo.com

unread,
Sep 18, 2009, 10:52:44 AM9/18/09
to
Hi!

Receives maintenance error (taken from SCOM 2007), which I thought was
a SQL Server 2005 error but is a CM 07 server error, according to a
SQL expert. See below:
===
ConfigMgr 2007 Status: Database Notification Monitor failed to execute
a Site Maintenance task. A new monitored SMS status message on machine
SACHS from component SMS_DATABASE_NOTIFICATION_MONITOR with message ID
2401 was found in the site STO database. The status message contains
message properties Machine Name: SACHS Module Name: SMS Server
Component:
SMS_DATABASE_NOTIFICATION_MONITOR Message ID: 2401 Win32 Error:0 Top
Level Site Code: Database Record ID:9656312
===

I have no clue on what this is and what to do. I would appreciate any
comment on this

TIA

spac...@yahoo.com

unread,
Sep 30, 2009, 10:10:07 AM9/30/09
to
I can also add that we have noticed that the above leads to a stored
procedure, sp_DeleteOldSDMPackageData in SMS_STO database. Creating a
small routine in SQL Query window that's calling the
sp_DeleteOldSDMPackageData with the parameter value = 3, creates the
following:

Msg 530, Level 16, State 1, Procedure sp_DeleteOldSDMPackageData, Line
18
The statement terminated. The maximum recursion 100 has been exhausted
before statement completion.

Then we are stuck.

Anyone???

0 new messages