Unable to Locate Project Details in Integrations Section and Encountering '500 Internal Server Error'

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Unable to locate project details within the integrations section. Additionally, attempts to add a new project result in a 500 Internal Server Error.

From the logs, we observed that the GET operation was failing due to a NullPointerException in the IntegrationProjectAssociationController

2024-06-07T05:27:18.356Z ERROR provisioning [host='provisioning-service-app-774794986-gssx2' thread='reactor-http-epoll-16' user='provisioning-9LAxJ6h7VLsjVc9r()' org='<ORG_ID>' trace='e086a58e-27f3-4442-b854-05f8ccadffec' parent='7ff9ea8e-117e-4663-99ae-37e0310537df' span='e3add757-85e9-4095-affc-e48d90e79fc1'] o.s.b.a.w.r.e.AbstractErrorWebExceptionHandler.error:102 - [ac22785f-4551007]  500 Server Error for HTTP GET "/provisioning/activedirectory/api/providers/integration/11eb4be1-c56e-4e3f-b1b0-7d4ecfd8d31b?page=0&size=20"

Environment

Aria Automation 8.x

Cause

This issue appears to be due to a row in the ad_integration_project_association table where the project_id field is NULL. This may have been caused by the movement of an AD resource.

Resolution

This issue is fixed in version 8.18.0.

If you need assistance for workaround, contact technical support and note this Knowledge Article ID (373104) For more information, see How to Submit a Support Request.

Additional Information

This issue may have been caused by a "change project" action on resources followed by project deletion in a previous version of vRA