"ODBC error [Oracle] - ORA-22275: invalid LOB locator specified" error when upgrading to vCenter Server service 6.0

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options, you observe these symptoms:

• vCenter Server service stops and fails.
• In the vpxd.log file, you see entries similar to:

2016-04-04T13:05:16.255-05:00 error vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] [VdbStatement] Execute result code: -1
2016-04-04T13:05:16.255-05:00 warning vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] [VdbStatement] SQL execution failed: INSERT INTO VPX_SDRS_STATS_VM (VM_ID, QUANTILES, SPACE_STATS) VALUES (?, ?, ?)
2016-04-04T13:05:16.255-05:00 warning vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] [VdbStatement] Execution elapsed time: 2085 ms
2016-04-04T13:05:16.255-05:00 warning vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] [VdbStatement] Statement diagnostic data from driver is HY000:0:22275:[Oracle][ODBC][Ora]ORA-22275: invalid LOB locator specified
--> ?? ?? ?? ?? ?? ?? ??
2016-04-04T13:05:16.255-05:00 error vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] [Vdb::IsRecoverableErrorCode] Unable to recover from HY000:22275
2016-04-04T13:05:16.255-05:00 error vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] [VdbStatement] SQLError was thrown: "ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-22275: invalid LOB locator specified
--> " is returned when executing SQL statement "INSERT INTO VPX_SDRS_STATS_VM (VM_ID, QUANTILES, SPACE_STATS) VALUES (?, ?, ?)"
2016-04-04T13:05:16.256-05:00 warning vpxd[19264] [Originator@6876 sub=drmLogger opID=CollectRemoteStats-35c314b3] [VpxDrmStatsManager::SaveToDb] Failed with "ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-22275: invalid LOB locator specified
--> " is returned when executing SQL statement "INSERT INTO VPX_SDRS_STATS_VM (VM_ID, QUANTILES, SPACE_STATS) VALUES (?, ?, ?)"

The errors above are causing the backtrace below which is essentially a vpxd crash (vCenter Server Service)...

2016-04-04T13:05:16.260-05:00 error vpxd[19264] [Originator@6876 sub=Default opID=CollectRemoteStats-35c314b3] Alert:false@ bora\vim\lib\vdb\vdb.cpp:4193

--> Backtrace:

-->
--> [backtrace begin] product: VMware VirtualCenter, version: 6.0.0, build: build-3634793, tag: vpxd
--> backtrace[00] vmacore.dll[0x001C599A]
--> backtrace[01] vmacore.dll[0x0005C8BF]
--> backtrace[02] vmacore.dll[0x0005DA0E]
--> backtrace[03] vmacore.dll[0x00025E93]
--> backtrace[04] vpxd.exe[0x0001BB14]
--> backtrace[05] vpxd.exe[0x00FE576C]
--> backtrace[06] vpxd.exe[0x00FFE932]
--> backtrace[07] vpxd.exe[0x00F7E6A1]
--> backtrace[08] vpxd.exe[0x00379A7D]
--> backtrace[09] vpxd.exe[0x009F30F9]
--> backtrace[10] vpxd.exe[0x00062876]
--> backtrace[11] vpxd.exe[0x0006292F]
--> backtrace[12] vmacore.dll[0x0015A18E]
--> backtrace[13] vmacore.dll[0x0015D9FF]
--> backtrace[14] vmacore.dll[0x0015EF51]
--> backtrace[15] vmacore.dll[0x00160C85]
--> backtrace[16] vmacore.dll[0x00065E1B]
--> backtrace[17] vmacore.dll[0x0015C110]
--> backtrace[18] vmacore.dll[0x001D2A5B]
--> backtrace[19] MSVCR90.dll[0x00002FDF]
--> backtrace[20] MSVCR90.dll[0x00003080]
--> backtrace[21] KERNEL32.DLL[0x000013D2]
--> backtrace[22] ntdll.dll[0x000154E4]
--> [backtrace end]
-->

Environment

VMware vCenter Server 6.0

Cause

This issue occurs due to an Oracle database known bug 14494406 causing the vCenter Server services to stop and crashed.

Resolution

To resolve this issue, apply Oracle database 11.2.0.4 (server patch set).