Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

VCM database heartbeat job fails with error 4121 (2003452)

Symptoms

  • The VCM 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)

Cause

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

Resolution

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.

Tags

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.

Feedback

  • 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)
  • 1 Ratings
Actions
KB: