Update to moving OperationsManager Database Steps

re: Update to moving OperationsManager Database Steps

Ernie — Fri, 23 Sep 2011 10:01:04 GMT

Hello Again

Apart from the above, can you please clarify do I run the SQL script on the OperationsManager or the OperationsManagerDW database?

Thank you

Ernie

ErnestBrant@Hotmail.co.uk

re: Update to moving OperationsManager Database Steps

Ernie — Fri, 23 Sep 2011 09:38:32 GMT

Hello Matt

I recently moved the OperationsManager and OperationsManagerDW database due to a DR. The DBA could not move the Reporting Services Database (So I am getting a specific error stating SCOM cannot connect to the Reporting Database). Forgetting the Reporting Server database for a moment (unless it is related to my issue below). I have the following type or error as described in your post. My issue is I receive the following errors in the following order i.e. first, second etc

Event ID 31561

Failed to enumerate (discover) Data Warehouse objects and relationships among them. The operation will be retried.

Exception 'SqlException': Error 777970008, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Discovery.StandardDataSet

Instance name: Client Monitoring data set

Instance ID: {77BF2D8B-DDAD-2240-E3EC-570CC68A626D}

Management group: XXXX

Event ID 31561

Failed to enumerate (discover) Data Warehouse objects and relationships among them. The operation will be retried.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Discovery.StandardDataSet

Instance name: State data set

Instance ID: {91134D4D-B1CE-CD48-C215-CD883816511E}

Management group: XXXX

Event ID 31561

Failed to enumerate (discover) Data Warehouse objects and relationships among them. The operation will be retried.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Discovery.StandardDataSet

Instance name: Performance data set

Instance ID: {56EACCD9-8AD9-D50B-2E59-9B697731F893}

Management group: XXXX

Event ID 31561

Failed to enumerate (discover) Data Warehouse objects and relationships among them. The operation will be retried.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Discovery.StandardDataSet

Instance name: Alert data set

Instance ID: {4D6765C1-5C91-B99B-38B6-D1367AB45B74}

Management group: XXXX

The DBA did not recovery the Master Databae I believe, rather they attached the OperationsManager and OperationsManagerDW databases to an already installed instance

I have SCOM 2007 R2 CU3 and SQL 2008

Does your script still apply to my environment? (particularly as the DBA did not recover the maste database)

Will your Script work on SQL 2008? (as it states SQL 2005)

Please let me know, Thanks in advance

Ernie

ErnestBrant@Hotmail.co.uk

re: Update to moving OperationsManager Database Steps

Martin Otter — Wed, 23 Dec 2009 11:06:46 GMT

Hi Matt,

I'm getting an error as shown below:

Error 778263, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.

U used your sql file and altered it so error 778263 is now also added.

But i still don't know what kind of error this is. Can you help me?

re: Update to moving OperationsManager Database Steps

Luis Claudio-Jaramillo — Fri, 19 Jun 2009 14:08:56 GMT

Hello Matt! We recently did a DB move for SCOM OP and DW and we are still getting this error as of 6/15/09. Granted, when we executed this procedure, we did it on the RTM version of SCOM. Just wanted to drop a line and let you know.

LC-J

re: Update to moving OperationsManager Database Steps

Matt Goedtel (MSFT) — Sun, 14 Jun 2009 03:25:08 GMT

Luis,

I don't believe this is required any longer and the Operations Guide has the most up-to-date and accurate information.

If you find that is not the case, please let me know.

Thanks,

Matt

re: Update to moving OperationsManager Database Steps

Luis Claudio-Jaramillo — Tue, 02 Jun 2009 14:31:41 GMT

Is this procedure still necessary?

System Center Forum - FIX: Update to Steps Moving the OperationsManager Database

Tue, 14 Aug 2007 16:23:38 GMT

PingBack from http://systemcenterforum.org/fix-update-to-steps-moving-the-operationsmanager-database/