Loading

×Sorry to interrupt
CSS Error

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

Update Manager fails to scan a host with an unknown error (1017377)

Last Updated: 3/20/2024Categories: TroubleshootingTotal Views: 39412Language:
Chinese (Simplified)JapaneseEnglish

Subscribe to get an email
newsletter with new updates

Please provide article feedback:

Symptoms

vCenter Update Manager fails to scan an ESX host

You may see these errors:

Scan Entity <name of host> VMware vCenter Update Manager had an unknown failure. Check Tasks and Events tab and logs for more details.

Unknown Error

You see this error in vmware-vum-server-log4cpp.log (located in C:\Documents and Settings\All Users\Application Data\VMware\Update Manager or C:\Users\All Users\VMware\VMware Update Manager\Logs):

[2009-11-26 18:11:27:691 'BaselineMgr' 3784 WARN] [vciUtilities, 2777] Could not recompute baseline compliance for entity host-29: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.vci_CheckBaselineConflict", or the name is ambiguous." is returned when executing SQL statement "{CALL vci_compBaselineComplianceLeaf(?,?,?,?)}"

[2011-09-16 13:17:55:715 'SingleHostScanTask.SingleHostScanTask{99}' 3332 ERROR] [singleHostScanTask, 399] SingleHostScan caught exception: Database error (vdb) "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.vci_CheckBaselineConflict", or the name is ambiguous." is returned when executing SQL statement "{CALL vci_compBaselineComplianceLeaf(?,?,?,?)}" with code: -1
[2011-09-16 13:17:55:728 'SingleHostScanTask.SingleHostScanTask{99}' 3332 ERROR] [vciTaskBase, 564] Task execution has failed: Database error (vdb) "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.vci_CheckBaselineConflict", or the name is ambiguous." is returned when executing SQL statement "{CALL vci_compBaselineComplianceLeaf(?,?,?,?)}"

Resolution

This issue is resolved in VMware vSphere Update Manager 5.0 Update 1. You can download this version from the vSphere Download Center.

Prior to Update Manager 5.0 Update 1, this issue occurs when the vCenter Update Manager database is installed in a schema other than DBO.

To verify that the database tables are part of another schema on SQL:

Log in to the SQL instance using SQL Management Studio.

Select the Update Manager database.

Expand the tables and check the prefix. The tables should be named dbo.vci_xxx. If the tables start with any other prefix then it is not part of DBO schema.

To resolve this issue, change the database schema to DBO:

Connect to the SQL Server via SQL Server Management Studio. If you are unsure of how to do this, consult Microsoft's website on downloading or obtaining this utility.

When SQL Server Management Studio is open, navigate to Security > Logins.

Right-click the user specified in your ODBC for the vCenter Update Manager database and click Properties.

Select User Mappings on the left.

Select the vCenter Update Manager database name.

Change the Default Schema to dbo.

When the user mapping has been corrected, uninstall and reinstall vCenter Update Manager.

Alternatively, you can create a new Update Manager Database, ensuring that it is part of the DBO schema. For more information on how the database should be created, see Configure a Microsoft SQL Server Database in the VMware vCenter Update Manager Administration Guide.

Note: A Database Administrator is required to implement both resolutions.

Related Information

Update Manager 未能扫描主机并出现未知错误

Update Manager が不明なエラーでホストのスキャンに失敗する

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
Chinese (Simplified)JapaneseEnglish

Attachments

Additional Resources

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

KB
•
Internet Explorer の Lab Manager 用 MKS プラグインを手動でインストールおよびアンインストールする (1021554)

KB
•
Suporte de ferramenta de gerenciamento de servidor ESXi 5.0 para LSI (2004166)

Results 1-3 of 3

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

Related Versions:

Take Our Survey

Support Assistant