Problem with creating a new monitor in MOM 2007 RRS feed

  • Question

  • Goal: trying to create a monitor that will return an alert when a process set to autostart is not on
    I am currently using the following script:
    ' Monitor if automatic process is not running
    Dim oAPI, oBag
    Set oAPI = CreateObject("MOM.ScriptAPI")
    Set oBag = oAPI.CreatePropertyBag()
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    strComputer = "."
    Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root
    Set colListOfServices = objWMIService.ExecQuery _
    ("Select * from Win32_Service Where StartMode = 'Auto'")
    For Each objService in colListOfServices
    If Not objService.Started = True Then
    strDesc = "Service " & objService.Caption & " is not running!"
    Call oBag.AddValue("Description", strDesc)
    Call oBag.AddValue("State", "BAD")
    Call oBag.AddValue("State", "GOOD")
    End If
    I get the following error from the create a unit monitor wizard:
    Date: 6/16/2009 9:27:11 AM
    Application: System Center Operations Manager 2007
    Application Version: 6.0.6278.0
    Severity: Error

    : Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
    Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
    The transaction log for database 'OperationsManager' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

    Tuesday, June 16, 2009 1:32 PM


  • You have a database issue, not a scripting issue. You need to troubleshoot your transaction logs for the OM database.

    "Fear disturbs your concentration"
    • Marked as answer by S. Halsey Tuesday, June 16, 2009 5:07 PM
    Tuesday, June 16, 2009 2:41 PM