vRA 7.3 - bulk import - bad icons

[bdamian]

Hi all, I'm having a hard time with the bulk import tool of vRealize Automation 7.3

After I've done all the steps described here:

Import a Virtual Machine to a vRealize Automation Environment

Everything seems to be OK but the Virtual Machine icon is wrong. It shows a "generic component" icon instead the vSphere icon:

The first (and second) machine where imported with the CSV file. The last one was deployed using the vRA console. The first and last VM are associated to the same blueprint.

Any ideas how to fix this?

Thanks a lot.

[bdamian]

Is there anybody out there who has the same issue?

[qc4vmware]

Yes we had the same issue and VMware just shrugged their shoulders.  It wasn't a high priority for us to get it corrected so we kind of just dropped the ball with support.  Obviously a bug in the import process.

[bdamian · Accepted solution]

Ok, this is an issue of vRA and the only way I found to fix it is to change it directly in the postgres database (if you are fan of extreme sports!!!).

[ProsKong]

Do you have the steps to change the icons?

[bdamian]

Yes, is something like this:

1) Connect vRA appliance on ssh as root

2) start postgress client (psql -U postgres vcac)

3) Select your VM with bad icon (or ignore de name part to get all VMs without icon):

select name, resourcetype_id, icon_id, status from cat_resource where status='ACTIVE' and resourcetype_id ='Infrastructure.Virtual' and icon_id is null and name = 'vm-name';

4) Update the icons:

update cat_resource set icon_id = 'Infrastructure.CatalogItem.Machine.Virtual.vSphere' where status='ACTIVE' and resourcetype_id ='Infrastructure.Virtual' and icon_id is null and name = 'vm-name';

Hope this helps you