VMware Cloud Community
mvrk
Enthusiast
Enthusiast

vCenter 6.7 - Health warning - vc.health.error.dbjob3

Hi,

Today i realized i have this warning on my vCenter:

pastedImage_0.png

Anyone has any idea what it might be?

Reply
0 Kudos
10 Replies
daphnissov
Immortal
Immortal

Absolutely no idea with just one screenshot and no logs or other info.

Reply
0 Kudos
Alex_Romeo
Leadership
Leadership

Hi,

you can provide us with log files. I provide you with a link that tells you where to find them.

VMware Knowledge Base

ARomeo

Blog: https://www.aleadmin.it/
Reply
0 Kudos
mvrk
Enthusiast
Enthusiast

Which one(s) you need?

vpxd/vpxd.log ?

Reply
0 Kudos
Alex_Romeo
Leadership
Leadership

Yes

Blog: https://www.aleadmin.it/
Reply
0 Kudos
mvrk
Enthusiast
Enthusiast

Here are the logs.

Reply
0 Kudos
Ajay1988
Expert
Expert

Hello ,

vc.health.error.dbjob3 = "Performance statistics rollup from Past Month to Past Year is not occurring in the database"

Check if below partition are highly utilized. If yes ; try to cut down on some old events/tasks. Also perform a shutdown of the VCSA/PSC and then power them up.

/storage/db

/storage/seat

Regards,
AJ

If you think your queries have been answered
Mark this response as "Correct" or "Helpful".

Regards,
AJ
Reply
0 Kudos
mvrk
Enthusiast
Enthusiast

vc.health.error.dbjob3 = "Performance statistics rollup from Past Month to Past Year is not occurring in the database"

Oh, in that case, i already had this issue on 6.5 and 6.0, it started when i upgraded from 5.5 to 6.0 and i was never able to fix it (https://communities.vmware.com/thread/581857)

It seems it just shows in different way in 6.7.

Check if below partition are highly utilized. If yes ; try to cut down on some old events/tasks. Also perform a shutdown of the VCSA/PSC and then power them up.

/storage/db

/storage/seat

pastedImage_24.png

I already rebooted several times, and still have the same warning.

Reply
0 Kudos
mdinisoae
Enthusiast
Enthusiast

I got the same error after I made an upgrade from 6.7.0.43000 to 6.7.0.44000.

pastedImage_1.png

I found a work around by uncheck parameter for 1 day in Statistics:

pastedImage_2.png

pastedImage_3.png

... but in my case, as result of the upgrade I found more damages on vCenter level: vSphere Client (HTML).

  • You cannot Acknowledge or Reset to Green vCenter Alarms
  • Errors if you want to check "Configuration" (Administration -> Single Sign On -> Configuration-> Active Directory Domain)
  • Suddenly is disconnecting the user from vCenter Client UI

Luckily the old vSphere Web Client (flash version) is still working ...so I'm still digging ....

MDINISOAE Please mark "Helpful" or "Correct Answer" if my answer satisfies your query.
Reply
0 Kudos
mdinisoae
Enthusiast
Enthusiast

I managed to upgrade my problematic VC 6.7 (build 44000) to VC 7.0 and the error has been disappeared;  if you receive following error:

pastedImage_2.png

then you need to disable all statistics and redo the Phase 2:

pastedImage_1.png

...and at the end the update will complete without any errors:

pastedImage_4.png

Enjoy!

MDINISOAE Please mark "Helpful" or "Correct Answer" if my answer satisfies your query.
Reply
0 Kudos
valteesjunior
Enthusiast
Enthusiast

I have the same problem here. The services that are going down is vCenter Server and vAPI Endpoint. All ESXi hosts are disconnected, with "Cannot synchonize host" alert. I disabled all Statistics configuration and all disks have available space.

Could you help me?

Best Regards.

Valter Junior

Reply
0 Kudos