The issue occurs due to the presence of special characters or space in the end of the folder name, this might have been authorized by vCenter Chargeback.
Note: The parameter of the SQL query SELECT and UPDATE need to be adapted to your case and environment. If you are unsure, contact your DBA.
To work around the issue :
- Open command prompt and start vCenter Server with this command:
vpxd.exe -s ,
Note: The vpxd.exe should be located in Program Files\Vmware\Infrastructure\Virtual Center
- Open Microsoft SQL Server Management Studio and connect to the vCenter Server database.
Note: Ensure you have a backup of you database before continuing further. Inaccuracies when executing the query could cause damage to the database.
- Right-click on the database and select New Query.
- Use the logs from vpxd to find the culprit entity ID:
For example:
- in "[yyyy-mm-dd 14:25:06.220 04812 error 'App'] Found group with invalid name 001 - color services - BLACK / WHITE. Removing /vpx/group/#v2555/"
- in "[yyyy-mm-dd 14:26:10.626 01044 error 'App'] Found group with invalid name My generic folder name . Removing /vpx/group/#v2590/"
In this example, the culprit IDs are 2555 and 2590 respectively.
- Perform these steps on the query window:
- First ensure you are working on the right entity by executing :
SELECT * FROM VPX_ENTITY WHERE ID = 'XXXX'
Where the XXXX represents the culprit ID.
In this example, the culprit ID is 2555:
SELECT * FROM VPX_ENTITY WHERE ID = '2555'
- Update the name of the entity using this command.
UPDATE VPX_ENTITY SET NAME = 'YYYY' WHERE ID = 'XXXX'
Where the XXXX represents the culprit ID and the YYYY represents the folder name.
In this example, the culprit ID is 2555 and 001 - color services - BLACK - WHITE is the folder name:
UPDATE VPX_ENTITY SET NAME = '001 - color services - BLACK - WHITE' WHERE ID = '2555'
- Repeat step 5 on other culprit IDs.
In this example, the other culprit ID is 2590:
SELECT * FROM VPX_ENTITY WHERE ID = '2590'
UPDATE VPX_ENTITY SET NAME = 'My generic folder name' WHERE ID = '2590'
Note: You can re-run the SELECT query to ensure that the name has been updated.
- Start the VirtualCenter Server service. If this fails again with the same error, apply the same procedure with updated ID and NAME.