Hi Lenny, I have the same in my lab and SQL broker is enabled (Value =1). I have also seen this on other SP1 installations. I have tried disabling the broker and re-enabling it again, but no change. Best regards John Taggaard > Is SQL Broker enabled? > > This query should tell you: > > select is_broker_enabled from sys.databases where name = > 'operationsmanager' > > If its not (value =0), then enable it: > > ALTER DATABASE operationsmanager SET ENABLE_BROKER > > Stop the 3 services on the RMS while setting broker. > > We added a monitor in SP1 to verify broker is enabled (broker is > required for receiving task status). > > Lenny Wile > > ------------------------- > This posting is provided "AS IS" with no warranties, and confers no > rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm > "opsmgr" wrote in message > news:C805CFB6-7E38-4643-A39F-36D75932A70A@microsoft.com... > >> After installing SP1, we keep getting this error on our RMS. Anyone >> seen >> this >> on their enviornment or know how to fix it? Thanks. >> Last modified by: System >> Alert: OleDB: Results Error >> Source: RMS.xyz.com >> Path: RMS.xyz.com >> Last modified time: 7/3/2008 8:57:28 AM >> Alert description: OleDb Module encountered a failure 0x80004005 >> during >> execution and will post it as output data item. Unspecified error >> Workflow name: Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor >> Instance name: RMS.xyz.com >> Instance ID: {E8D68465-E771-F04E-2A13-72CB8D0B60B1} >> Management group: ABC
Just wanted to add, that I haven't had the alert in 1 day now after I manually closed it. I have though a repeat count of 12 on the alert. Best regards John Taggaard > Hi Lenny, > I have the same in my lab and SQL broker is enabled (Value =1). I have > also > seen this on other SP1 installations. I have tried disabling the > broker and > re-enabling it again, but no change. > Best regards > John Taggaard >> Is SQL Broker enabled? >> >> This query should tell you: >> >> select is_broker_enabled from sys.databases where name = >> 'operationsmanager' >> >> If its not (value =0), then enable it: >> >> ALTER DATABASE operationsmanager SET ENABLE_BROKER >> >> Stop the 3 services on the RMS while setting broker. >> >> We added a monitor in SP1 to verify broker is enabled (broker is >> required for receiving task status). >> >> Lenny Wile >> >> ------------------------- >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> Use of included script samples are subject to the terms specified at >> http://www.microsoft.com/info/cpyright.htm >> "opsmgr" wrote in message >> news:C805CFB6-7E38-4643-A39F-36D75932A70A@microsoft.com... >>> After installing SP1, we keep getting this error on our RMS. Anyone >>> seen >>> this >>> on their enviornment or know how to fix it? Thanks. >>> Last modified by: System >>> Alert: OleDB: Results Error >>> Source: RMS.xyz.com >>> Path: RMS.xyz.com >>> Last modified time: 7/3/2008 8:57:28 AM >>> Alert description: OleDb Module encountered a failure 0x80004005 >>> during >>> execution and will post it as output data item. Unspecified error >>> Workflow name: Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor >>> Instance name: RMS.xyz.com >>> Instance ID: {E8D68465-E771-F04E-2A13-72CB8D0B60B1} >>> Management group: ABC
