We upgrade from ESXi 3.5 to 4.1, new server hw, new DB as well (ORacle 10g).
The vCenter Service Status is showing Storage Management Service "Service initialization failed"
sms.log file shows numerous errors like:
2010-12-28 11:45:28,332 [pool-38-thread-2] ERROR com.vmware.vim.sms.provider.VcProviderImpl - PopulateStorageInfoTask Failed : com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/vmware/vim/sms/data/xml/CacheDbQuerySqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the insert_scsiTarget-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: org.h2.jdbc.JdbcSQLException: NULL not allowed for column ENTITYID [90006-64]
After much research, I found the query in the V:\Program Files\VMware\Infrastructure\tomcat\webapps\sms\WEB-INF\services\smService\com\vmware\vim\sms\data\xml\VcDbQueryOracleSqlMap.xml that is actually returning the NULL (and it is a NULL). The storage in question is iSCSI (DELLon backend)
iSCSI piece of Query:
SELECT DISTINCT PSA_TARGET_TRANSPORT.PORT_WWN AS PORT_WWN,
PSA_TARGET_TRANSPORT.NODE_WWN AS NODE_WWN,
PSA_TARGET_TRANSPORT.ISCSI_NAME AS ISCSI_NAME,
PSA_TARGET_TRANSPORT.ISCSI_ALIAS AS ISCSI_ALIAS,
CASE PSA_TARGET_TRANSPORT.VPX_TYPE
WHEN N'vim.host.ParallelScsiTargetTransport' THEN 'parallelScsi'
WHEN N'vim.host.FibreChannelTargetTransport' THEN 'fc'
WHEN N'vim.host.InternetScsiTargetTransport' THEN 'iscsi'
ELSE 'block'
END AS TARGET_TYPE,
'unknown' AS VENDOR,
CASE VPX_TYPE
WHEN N'vim.host.FibreChannelTargetTransport' THEN PORT_WWN
ELSE ISCSI_NAME
END AS ENTITY_ID
FROM VPX_PSA_TARGET_TRANSPORT PSA_TARGET_TRANSPORT
WHERE (PSA_TARGET_TRANSPORT.VPX_TYPE != N'vim.host.ParallelScsiTargetTransport' AND
PSA_TARGET_TRANSPORT.VPX_TYPE != N'vim.host.BlockAdapterTargetTransport')
The big question is, how do I get the ISCSI_NAME NOT to be NULL? Does anyone have any ideas?
TIA,
-=john=-
