After upgrading vRA from 7.5 to 7.6 several services show up as unavailable in the VAMI
Arun Nukula
1 min read
After upgrading vRA from 7.5 to 7.6 , following services might show up as unavailable
advanced-designer-service - UNAVAILABLE
o11n-gateway-service -UNAVAILABLE
shell-ui-app - UNAVAILABLE
vco - null
Going through logs you might see following exception
com.vmware.o11n.sdk.exception.RestApiException: com.vmware.o11n.service.version.ContentVersionException: org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2;
nested exception is javax.persistence.NonUniqueResultException: query did not return a unique result: 2
To resolve, check the vmo_contentversioncontrol table in vRA's Postgres database to see if there is a duplicate __SYSTEM record. if so, remove the one with id = 2
This is how that table should look
Once the second id is removed , services should start properly.
Never miss a post
New guides on VMware Cloud Foundation, Aria Suite, and infrastructure automation. Follow along in your feed reader and new posts show up as soon as they are published.
Subscribe via RSS