Category Archives: Inventory Service
Until have a problem I do not know what is behind of Inventory Service and how inventory service could be nightmare …
I don’t know X-Hive/DB or VMware use kind a XML database to keep inventory
Also more then six years never faced any issue with vCenter Server, we do not know what a problem with Vmware products means not like *indows products.
One day whatever happened happened like 11th television episode of the fifth season of ABC’s Lost 🙂 vCenter Web Client stop connecting vCenter Server Inventory service.
“The vSphere Client could not connect to <server> You do not have permission to login to the server.”
Long to Short
Our issue is no any software could connect inventory service like Web Client , Veeam and vCloud Director.
Our hero is “Yvonne” from VMware
vCenter Server version 5.5
Database is MSSQL
What articles not helped ?
Mostly all articles talk about permissions , reinstall vCenter Server or reset/re-create inventory db are not worked !
Then how we solve the issue ?
First you need to check your vCenter database size , it is the first point you should start to suspect !
Then check three table, VPX_EVENT, VPX_EVENT_ARG, VPX_TEXT_ARRAY. Also some more like VPX_TASK, VPX_ENTITY_LAST_EVENT too !
Then delete it , truncate it , what you wan’t but before do that if you have a support, call support , wait what they execute procedures and show our case to they , maybe they already published but sometime someone could need this solution …
select count(*) from VPX_EVENT;
select count(*) from VPX_EVENT_ARG;
select count(*) from VPX_TEXT_ARRAY;
SELECT * into VPX_TEXT_ARRAY_BK FROM VPX_TEXT_ARRAY
WHERE EXISTS(SELECT 1 FROM VPX_ENTITY WHERE ID=VPX_TEXT_ARRAY.MO_ID);
truncate table VPX_TEXT_ARRAY;
insert into VPX_TEXT_ARRAY (ARRAY_ID,[TYPE_ID],VALUE,MO_TYPE,MO_ID)
select ARRAY_ID,[TYPE_ID],VALUE,MO_TYPE,MO_ID from VPX_TEXT_ARRAY_BK;
drop table VPX_TEXT_ARRAY_BK;
alter table VPX_EVENT_ARG drop constraint FK_VPX_EVENT_ARG_REF_EVENT,FK_VPX_EVENT_ARG_REF_ENTITY
alter table VPX_ENTITY_LAST_EVENT drop constraint FK_VPX_LAST_EVENT_EVENT
truncate table VPX_TASK
truncate table VPX_ENTITY_LAST_EVENT
truncate table VPX_EVENT
truncate table VPX_EVENT_ARG
alter table VPX_EVENT_ARG add constraint FK_VPX_EVENT_ARG_REF_EVENT foreign key(EVENT_ID) references VPX_EVENT (EVENT_ID) ondelete cascade, constraint FK_VPX_EVENT_ARG_REF_ENTITY foreign key (OBJ_TYPE) referencesVPX_OBJECT_TYPE (ID)
alter table VPX_ENTITY_LAST_EVENT add constraint FK_VPX_LAST_EVENT_EVENT foreign key(LAST_EVENT_ID) references VPX_EVENT (EVENT_ID)on delete cascade