VMware Cloud Community
kiwijj
Contributor
Contributor

Problem with upgrade of vCenter from 2.5 to 4 with Update 1

Hi,

After the upgrade when looking at vCenter Service Status it shows

Performance statistics rollup from Past Day to Past Week is not occuring in the database

Performance statistics rollup from Past Week to Past Month is not occuring in the database

Performance statistics rollup from Past Month to Past Year is not occuring in the database

We are running SQL 2005 Express on a Windows 2008 64bit server.

Any idea how I can resolve this ?

thanks,

John

0 Kudos
5 Replies
marcelo_soares
Champion
Champion

Deja vu... check this one: http://kb.vmware.com/kb/1013820

Marcelo Soares

VMWare Certified Professional 310/410

Virtualization Tech Master

Globant Argentina

Consider awarding points for "helpful" and/or "correct" answers.

Marcelo Soares
0 Kudos
kiwijj
Contributor
Contributor

Hi Marcelo,

Thanks for the link but that does not resolve my issue. I get the error when I go to Home and click on vCenter Service Status using the vSphere client

thanks,

John

0 Kudos
bluebull2rhyme
Enthusiast
Enthusiast

Hi..Check do u have the following DBO on the SQL server

stats_rollup2_proc && exec purge_stat2_proc

stats_rollup3_proc && exec purge_stat3_proc

stats_rollup1_proc && exec purge_stat1_proc

If you find that try adding to the Jobs running on it.Each job should have 2 dbo's mapped to get the graph.

1.)Past Week stats rollupVirtualCenter - EXECUTE stats_rollup2_proc && exec purge_stat2_proc

This job is to roll up past week stats and should run every 2 hours

2.)Past Month stats rollupVirtualCenter - EXECUTE stats_rollup3_proc && exec purge_stat3_proc

This job is to roll up Past Month stats and should run every day

3.)Past Day stats rollupVirtualCenter - EXECUTE stats_rollup1_proc && exec purge_stat1_proc

This job is to roll up 5 min stats and should run every 30 mins

If you find this useful,award me Helpful or Correct answer

If you find this useful,award me Helpful or Correct answer
0 Kudos
kiwijj
Contributor
Contributor

Hi,

As mentioned, we are running SQL Express and as such those jobs as I understand it are for the full version of SQL.

I may as well just reinstall VC with a new database. Looks like the upgrade has some issues.

thanks,

John

0 Kudos
kiwijj
Contributor
Contributor

Hi,

As an update to this thread. I reinstalled vCenter with a new database rather than using the old one and it now works fine.

cheers,

John

0 Kudos