VMware Cloud Community
mdonovan
Contributor
Contributor

SQL errors in system logs

I was notified of a problem where an alert was set up to alarm at 90% CPU. This alarm has triggered several times, but looking at the CPU statistics does not show any points where the CPU went to 90%. In researching this I found these entries in the system logs. It looks to me there is a bug wither in VMWare code, or the field in the database needs changed to a larger number format. Anyone else see this?

Diagnostic data from driver is 22003:1:8115:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.

Diagnostic data from driver is 01000:2:3621:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

Diagnostic data from driver is 22003:3:8115:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.

Diagnostic data from driver is 01000:4:3621:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

Diagnostic data from driver is 22003:5:8115:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.

Diagnostic data from driver is 01000:6:3621:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

Diagnostic data from driver is 22003:7:8115:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.

Diagnostic data from driver is 01000:8:3621:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

Diagnostic data from driver is 22003:9:8115:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.

Diagnostic data from driver is 01000:10:3621:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

Diagnostic data from driver is 22003:11:8115:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.

Diagnostic data from driver is 01000:12:3621:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

Bind parameters:

datatype: 2, size: 4,arraySize: 45

value = 0

datatype: 1, size: 4,arraySize: 45

value = 0

datatype: 11, size: 284,arraySize: 45

datatype: 1, size: 4,arraySize: 45

value = 60

datatype: 3, size: 21,arraySize: 45

value = 1257446852379279360

datatype: 11, size: 0,arraySize: 45

VcStatsProvider::CollectLongTermValues database error while flushing stats data: "ODBC error: () - " is returned when executing SQL statement "{ call load_stats_proc(?, ?, ?, ?, ?, ?) }"

0 Kudos
1 Reply
mdonovan
Contributor
Contributor

0 Kudos