You are browsing the archive for 2009 May.

Avatar of alkin

by alkin

Opsmgr DB Create wizard System.InvalidOperationException

7:19 pm in Uncategorized by alkin

Today I wanted to install my OperationsmanagerDB on my SQL cluster 2005 SP2 actif-passive.

So I started the DBCreatewizard.exe and I got a very strange error mentioning something about

 

Severity: Error Message: Database creation failed. The database might have been incompletly created or modified. System.InvalidOperationException: An error occurred while trying to create the database on your SQL Server. Check your logs for more information. at Microsoft.EnterpriseManagement.Setup.DBCreateWizard.Program.LaunchDBCreation() at Microsoft.EnterpriseManagement.Setup.DBCreateWizard.SummaryPage.BackgroundThread()

 

clip_image002

 

To make a long story short:

We had a lab environment and production environment. Both environments are exact replicas: ip, users, servers, everything is the same. I did the install in the lab environment on my sql cluster and didn’t encounter any problems.

Now in production I had this strange error and asked my dba (that installed the sql cluster in lab and production) to confirm that everything was ok and that everything was the exact replica of the lab….

Now here comes the catch….and also the moment I wanted to kill my DBA….

I analyzed the dbcreatewizard error log that you can find here:

 

C:\Documents and Settings\user\Local Settings\Temp\1

image

And found the following sentence

 

10:31: CreateDB:  Attempting to create OperationsManager on ELSQL3E\WSSCOM threw the following sql exception Cannot use file ‘J:\SCOMOPLOG\OperationsManager.ldf’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

 

image

I checked on my cluster resource and indeed: the Log disk was missing as a dependency!!

image

So my production environment was not the exact replica as my lab environment. I had to add the Log file disk as a dependency for my sql resource group:

image

 

And now I was able to run the dbcreatewizard.exe succesfully!

 

image

 

Hope this helps,

Alexandre Verkinderen

Avatar of alkin

by alkin

Optimizing the performance of your Opsmgr Console and reducing DB size

9:12 am in Uncategorized by alkin

I had troubles with the Opmsgr Console performance at serveral clients.

One of the most important things to boost your console performance is to reduce the Opsmgr DB size.

 

If you want to know which tabel is taking most of your DB size run the following query:

Simple query to display large tables, to determine what is taking up space in the database:

SELECT so.name,
8 * Sum(CASE WHEN si.indid IN (0, 1) THEN si.reserved END) AS data_kb,
Coalesce(8 * Sum(CASE WHEN si.indid NOT IN (0, 1, 255) THEN si.reserved END), 0) AS index_kb,
Coalesce(8 * Sum(CASE WHEN si.indid IN (255) THEN si.reserved END), 0) AS blob_kb
FROM dbo.sysobjects AS so JOIN dbo.sysindexes AS si ON (si.id = so.id)
WHERE ‘U’ = so.type GROUP BY so.name  ORDER BY data_kb DESC

clip_image001

 

In my case the localizedtable was taking most of the disk space. Kevin Holman already blogged about this: http://blogs.technet.com/kevinholman/archive/2008/10/13/does-your-opsdb-keep-growing-is-your-localizedtext-table-using-all-the-space.aspx 

 

I followed his procedure, I will describe all the steps I did and has to say I was really suprise by the results! :-)

 

  • Count the rows in the localizedtable

select count(*) from localizedtext

clip_image002

In a normal environment with the typical management packs imported the total count of rows should be around the million. In one of my environments it was 22 milion!! So I defenitely needed to clean up this localizedtable!

 

  • Look at the most common events in the localized table

select messageid, ltvalue, count(*) as Count from publishermessages with(nolock)
inner join localizedtext with(nolock)
on messagestringId = localizedtext.ltstringid
group by messageid, ltvalue
order by Count DESC

 

In my case it was the exchange management pack that produced the most ammount of events.

 

  • Run the clean up script

Kevin Holman has provided a script to clean up the localized table. You can download it from his blog DeletePublisherMessages.zip .

Notice that this script is NOT supported by Microsoft, as it has not been thoroughly tested!  I’ve run the script in several environments now and didn’t run into issues but as a good Sys admin be carefull and take a backup of your opsmgr DB before running the script. Also make sure that your TEMPDB has enough space. And with enough space I really mean ENOUGH SPACE! Also the transaction logs of the TEMPDB will need a huge amount of free space. Also don’t run this scripts during the day when you have several operators running the opsmgr console. My CPU went crazy to 100 % processor time so my advice is to run the query at night or during the weekend.

 

 

  • Reindex the DB

USE OperationsManager
go
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET NUMERIC_ROUNDABORT OFF
EXEC SP_MSForEachTable “Print ‘Reindexing ‘+’?’ DBCC DBREINDEX (‘?’)”

 

 

Now the results! :-)

 

Before running the script:

clip_image002[4]

After running the script:

image

 

Gain in diskspace:

OperationsManager free space in %:

 

image

 

OperationsManager free space in MB:

clip_image002[10]

 

 

 

 

I was really suprised by the ammount of free space I had now. With cleaning up the localizetable I won about 60 % of space!

 

My Opsmgr console is running really smootly now!

 

Hope this helps,

Alexandre Verkinderen

Avatar of alkin

by alkin

savision Live maps for Opsmgr 2007

8:28 pm in Uncategorized by alkin

I’ve just done some big implementations of Savision Live maps and I’ve to addmit…I just love it!

 

Some screenshots:

 

image

 

 

 

 

It’s THE product that brings Opsmgr to a higher level and really gives the WOOW effect.

 

Savision also has a blog and some nice How to video’s:

 

  • Create Dynamic Views by IP Subnet in Microsoft Operations Manager

 

 

 

 

  • Create Advanced Network Topologies with Microsoft Operations Manager

Avatar of alkin

by alkin

Upgrading Opsmgr 2007 R2 RC consoles to Opsmgr 2007 R2 RTM

7:37 pm in Uncategorized by alkin

When you want to start upgrading your consoles from the opmsgr 2007 R2 RC version to the Opsmgr 2007 R2 RTM version be carefull with:

  • third party extensions like the Savision live maps for example. You will first need to uninstall the extensions and reinstall them afterwarts. You can download the extensions from http://savision.com/download
  • Also check that no opmsgr 2007 agents are installed on the same box. You will need to uninstall the agents prior to be able to upgrade the console

 

Next, There is no upgrade path from the opsmgr authoring console 2007 RC to the R2 version:

 

Oringal authoring console verions:

clip_image001

Upgrade:

clip_image003

Did an uninstall of the old one and install of the new authoring console:

clip_image004

 

Why provide an upgrade path for the Operations console but not for the authoring console???

grtz,

Alexandre Verkinderen

Avatar of alkin

by alkin

Upgrade Opsmgr 2007 R2 RC to Opsmgr 2007 R2 RTM

11:46 am in Uncategorized by alkin

I’ve several production environmnets running the Opmsgr 2007 R2 Release Candidate version. Now that the Opsmgr 2007 R2 Rtm is available I wanted to test the upgrade from RC to RTM in my lab environment before upgrading my production environments.

Start the SetupOM.exe

 

image

the setup will detect that you run on “older” version of opsmgr2007

image

The prerequisiter check failed because of the savision livemaps RC extensions:

image

 

Uninstall the savision rc extensions and your ready to go:

image

 

After upgrading backup your encription key.

 

image

 

Don’t forget to approve the agent pending update

image

 

After the upgrade from SCOM R2 RC to R2 RTM you can  reinstall the Savision Livemaps RC extensions from http://www.savision.com/download . Savision confirms that the Livemaps RC extensions works on SCOM 2007 R2 RTM and that they will release an update within a few weeks to fully support the new SCOM 2007 R2 and add some new functionalities.

Now that I’m sure the upgrade from RC to R2 works like a charm I can upgrade my other RC environments at customers sites!

 

Grtz,

Alexandre Verkinderen

Avatar of alkin

by alkin

Opsmgr on Social Forum!

5:40 pm in Uncategorized by alkin

We just moved from the old news servers to the new social forum platform!

 

So start asking your questions, issues, share your knowledge etc on the new platform and make it as good as the old NNTP groups!

 

http://social.technet.microsoft.com/Forums/en-US/category/systemcenteroperationsmanager

 

grtz,

ALexandre Verkinderen

http://scug.be

 

Avatar of alkin

by alkin

SCOM 2007 R2 is RTM!

12:29 pm in Uncategorized by alkin

SCOM 2007 R2 is RTM!

 

Download the scom 2007 R2 here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=93ddf25b-1ef0-4851-81b0-5fb9a2f76181

Brief Description
Microsoft System Center Operations Manager 2007 R2 delivers end-to-end service management of applications and IT services running across the Windows, UNIX and Linux servers in your datacenter.

System Requirements

  • Supported Operating Systems: Windows Server 2003; Windows Server 2008; Windows Vista; Windows XP

For the Microsoft System Center Operations Manager 2007 R2 Management, Web, Database and Reporting Servers:

  • Computer with an x86 or x64 2.8 GHz or faster processor
  • Windows Server ® 2008 Enterprise, Standard, or Datacenter (x86 or x64) edition
  • 4 GB or more RAM; 100 GB or more of available hard-disk space
  • Microsoft SQL Server 2008 Standard or Enterprise edition (for the Database Server)
  • Microsoft SQL Server 2008 Reporting Services with Service Pack 1 (for the Reporting Server)
  • Microsoft .NET Framework 2.0 and 3.0 (for the Management Server)
  • Microsoft WS-Management 1.1 (for the Management Server)
  • Microsoft Core XML Services (MSXML) 6.0
  • Microsoft Internet Information Services configured with ASP.NET (for the Web Server)
  • Microsoft ASP.NET AJAX 1.0 (for the Web Server)
  • Network adapter

For the Microsoft System Center Operations Manager 2007 R2 Consoles:

  • Computer with an x86 or x64 1.8 GHz or faster processor running Windows Vista ® or
  • Windows ® XP Professional with Service Pack 1 (or later)
  • 2 GB or more of RAM; 5 GB or more of available hard-disk space
  • Windows PowerShell TM
  • Microsoft .NET Framework 2.0 and 3.0
  • Network adapter

Avatar of alkin

by alkin

Opsmgr Data Warehouse failed to enumerate database components to be deployed

9:04 am in Uncategorized by alkin

Today I ran into this issue:

image

 

Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. The operation will be retried. Exception ‘SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: scom.be Instance ID: {AC6FACD9-

 

Issue:This error appears immediately after a management pack is imported. The installaion of the reports in the MP is failing.

Resolution:Run exec sp_updatestats on the OperationsManagerDW db (the data warehouse).

 

When running the exec sp_updatestats doesn’t help follow these steps:

 

Download and extract the following hotfix:

 

http://support.microsoft.com/?kbid=954643

image

 

Run the SQL query Managementpackinstall.sp.sql

image

 

And directly after running the query I got the following event:

image

 

Everything is fine now and I have green management server:

 

image

 

Hope this help,

Alexandre Verkinderen

http://scug.be

Avatar of alkin

by alkin

Third Edition of Microsoft Community Day !!

7:21 am in Uncategorized by alkin

Community Day is back again, are you ready for our Third Edition of Microsoft Community Day?

Eleven Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharing
event. A unique opportunity to learn about Microsoft’s latest developments and technologies like Exchange
2010, Silverlight 3, Visual Studio 2010, SQL Server 2008, Windows 2008R2, Powershell V2, Forefront
Identity Manager 2010, XNA 3.1. and OCS R2.
 
Microsoft Community Day will take place on Thursday 25th June 2009 in Utopolis, Mechelen, where we will
bring together 300 IT Pro’s and developers.
 
The Microsoft Community Day 2009 is supported by BESUG, BIWUG, IT-Talks, MVUG, Pro-Exchange, SCUG, SQLUG, VBIB, Visug, WinSec, XNA-BUG“
 
Register now for free for this all day event!

http://www.communityday.be/CD/

 

The System Center User Belgium will have two slots! We will speak about “Setting up & Configuring SQL Server to support your SCCM & SCOM environment” and “Thin, thick or hybrid imaging in sccm – Notes from the field”.

Hope to see you there!

Grtz,

Alexandre Verkinderen

Avatar of alkin

by alkin

SystemCenterCentral.com Launch

5:56 pm in Uncategorized by alkin

 

Guys,

 

You definitely have to check this out!!

PRESS RELEASE

We are proud to announce SystemCenterCentral.com, the site to visit for “Everything System Center”.

SystemCenterCentral.com was founded by three System Center community members; Pete Zerger, Rory McCaw and Maarten Goet. SystemCenterCentral.com is a community initiative that will combine a number of existing Internet properties under a single community site and strive to become the leading community landing page for all System Center technologies.

As Microsoft continues to invest in its System Center brand, we feel that there is a need for a community site that focuses exclusively on the technologies included in this suite of products. Unlike other community sites, the motivation behind this site is to continue to give back to the community at large, one of the reasons why each of the founders have been awarded the Microsoft MVP title.

The official launch of SystemCenterCentral.com will be at the Microsoft Management Summit (MMS) in Las Vegas, NV, the week of April 27 to May 2, 2009. SystemCenterCentral.com has a dedicated community area where you can check out the site, get more information or become a member!

At this time you will find blogs, where well-known MVPs will start blogging in the coming days, a download area, a community “pack catalog” and forums. Later in May, we will be launching a wiki and a ‘community feedback’ platform and other exciting features.

SystemCenterCentral.com is a strong supporter of user groups. We have the commitment of the following user groups to user SystemCenterCentral.com as the main landing page to find their user group and some of these groups will transfer their internet presence to SystemCenterCentral.com in the following weeks:

Atlanta Systems Management User Group, Microsoft Enterprise Management User Group (Denver), System Center Professional’s User Group of Jax (Florida), New York System Center User Group, Portland EPG System Center User Group, Northwest System Center User Group (Seattle), Windows Management User Group (UK), System Center User Group (Netherlands), System Center User Group (Belgium), System Center User Group (Malaysia), System Center Virtual User Group and the Powershell Virtual User Group.

We would like to thank our sponsors for making this possible. Both Quest Software and Microsoft are supporting SystemCenterCentral.com as Gold Sponsors and will be active participant in this new online community. By having them as gold sponsors, we are confident this will become the go-to, online community for all things System Center..

Also, we would like to thank Bridgeways and SecureVantage, who are supporting SystemCenterCentral.com as Silver Sponsors.

Not going to MMS, but still want to check out this new System Center community site? Go to www.systemcentercentral.com now and join!

Best regards,

Peter Zerger, Rory McCaw and Maarten Goet

Visit Us On TwitterVisit Us On Linkedin