VMware Cloud Community
tdubb123
Expert
Expert
Jump to solution

VMware vCenter Update Manager had an unknown error.

Getting the following error below

Scan entity

xxxxxxxxxxxxxxx

VMware vCenter Update Manager had an

unknown error. Check the Tasks and Events

tab and log files for details.

xxxxxxxxxxxxxxx

xxxxxxxxxxxx

9/27/2010 8:22:21 AM

9/27/2010 8:22:21 AM

9/27/2010 8:22:22 AM

checked my logs in yum

Leave Validate. Succeeded for integrity.ComplianceStatusManager.queryEntityComplianceStatus on target: Integrity.ComplianceStatusMgr

QueryEntityComplianceStatus called by client on entity:domain-c61

baseline id: 6

baseline id: 10

baseline id: 13

getting baseline informaton from db

total elapsed time for BaselineGroup::FetchAllBaselineGroupsWithBaselines = 0 msec

Acquired lock and get baselines for 5 entities

get baselines for entity: host-162

get baselines for entity: host-202

get baselines for entity: host-217

get baselines for entity: host-326

get baselines for entity: host-396

size of EntityBaselinesMap = 2

Patch baselines attach information.

entity: host-162 baselines: 6

entity: host-202 baselines: 6 , 10

Upgrade baselines attach information.

entity: host-202 baselines: 13

total elapsed time for VciUtilities::GetAllApplicableBaselines = 15 msec

SQL execution failed: {CALL vci_queryEntityBLStatus(?, ?, ?)}

Bind parameters:

datatype: 1 size: 4datatype: INT32 size: 4Value: 1

datatype: 1 size: 4datatype: INT32 size: 4Value: 0

datatype: 1 size: 4datatype: INT32 size: 4Value: 0

"ODBC error: (42000) - [http://SQL Server Native Client 10.0|http://SQL Server Native Client 10.0][SQL Server]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP437_CI_AS" in the equal to operation." is returned when executing SQL statement "{CALL vci_queryEntityBLStatus(?, ?, ?)}"

Throw vim.fault.DatabaseError

Result:

(vim.fault.DatabaseError) {

dynamicType = ,

faultCause = (vmodl.MethodFault) null,

msg = "",

}

The number of tasks: 0

The number of tasks: 0

The number of tasks: 0

The number of tasks: 0

The number of tasks: 0

Internal Scheduled Tasks Manager Timer callback...

InvokeCallbacks. Total number of callbacks: 7

Internal Scheduled Tasks Manager Timer callback end of this timer slice.....Rescheduling after 300000000 microseconds

Patch store disk free space is: 23355469824

Temp directory disk free space is: 23355469824

VMware Update Manager Web Server is green

VMware Remote Device Server is green

The number of tasks: 0

any idea here? My odbc connection is fine. The db was upgraded when I installed new update manager and upgraded the db

Reply
0 Kudos
1 Solution

Accepted Solutions
Troy_Clavell
Immortal
Immortal
Jump to solution

this error is a little troubling.

complianceStatusMgr, 1108 "ODBC error: (42000) - Microsofthttp://SQL Server Native Client 10.0SQL ServerCannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP437_CI_AS" in the equal to operation." is returned when executing SQL statement "{CALL vci_queryEntityBLStatus(?, ?, ?)}"

According to the thread below, which doesn't have much information, as reinstall of VUM, with a fresh DB may resolve the issue.

http://communities.vmware.com/thread/276351

View solution in original post

Reply
0 Kudos
2 Replies
Troy_Clavell
Immortal
Immortal
Jump to solution

this error is a little troubling.

complianceStatusMgr, 1108 "ODBC error: (42000) - Microsofthttp://SQL Server Native Client 10.0SQL ServerCannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP437_CI_AS" in the equal to operation." is returned when executing SQL statement "{CALL vci_queryEntityBLStatus(?, ?, ?)}"

According to the thread below, which doesn't have much information, as reinstall of VUM, with a fresh DB may resolve the issue.

http://communities.vmware.com/thread/276351

Reply
0 Kudos
tdubb123
Expert
Expert
Jump to solution

ok reinstalling on new db works now.

Thanks

Reply
0 Kudos