Search the VMware Knowledge Base (KB)
View by Article ID

VMware vRealize Configuration Manager database heartbeat job fails with error 4121 (2003452)

  • 1 Ratings


  • The VMware vRealize Configuration Manager (formerly known as vCenter Configuration Manager) Database Heartbeat job fails.
  • The error contains this message:

    Cannot find either column "dbo" or the user-defined function or aggregate "dbo.<function>", or the name is ambiguous. [SQLSTATE 42000] (Error 4121)


This error occurs when the function named in the error does not exists in the vRealize Configuration Manager
 database but is undefined.


To resolve this issue, recreate the function and its definition:
  1. Go to Administration > Settings > Asset Extention Settings > Hardware Configuration > VCM Devices.
  2. Recreate the missing information:

    1. Select the function.
    2. Click Edit.
    3. Work through the wizard to recreate the missing defnition.


heartbeat-job-fails  undefined-function  missing-function

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.


  • 1 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)

Please enter the Captcha code before clicking Submit.
  • 1 Ratings