HTTP failure response error Unable to add integration project association when using Bit integration

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Reconnecting an integration to a project.

Symptoms:

• You see the following error when creating an integration with a project:

  Http failure response for https://FQDN/content/api/projects/project_ID/integrations: 400 OK'

Environment

VMware Aria Automation 8.x

Resolution

VMware is aware of this issue. See the Workaround section below for additional information. [Before proceeding with the steps below, please take snapshots of all nodes in the cluster to ensure data integrity and facilitate potential rollbacks if needed.]

Workaround:

1. SSH into a node in the Aria Automation cluster.
2. kubectl exec -it -n prelude postgres-0 -- bash
3. su postgres
4. psql cgs-db or \c cgs-db
5. \x for readability
6. select * from cgs_integrationandproject;

Note: This will list all integrations linked to projects and abx functions. Search the DB output for the integration artifact for bit bucket. copy the id info form the db.
Example:

cgs-db=# select * from cgs_contentsource;
-[ RECORD 1 ]---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
id              | 13xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
name            | Bit Bucket name
description     |
type            | BITBUCKET_SAAS
created_at      | 2021-08-19 15:06:15.793475
last_updated_at | 2021-08-19 15:06:15.793475
config          | {"path": "", "branch": "master", "repository": "path/branch", "contentType": "BLUEPRINT", "projectName": "Autolab", "integrationId": "05xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"}
created_by      | xxxxxadmin
last_updated_by | xxxxxadmin
org_id          | 18xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
version         | 0
is_sync_enabled | t
is_deleted      | t
project_id      | c2xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx

7. delete from cgs_integrationand projectwhere id = 'Id_Found_Above';
8. exit to leave the db
9. exit again to leave the postgres user.
10. exit one final time to leave the postgres pod exec.
11. Continue into vra to add a new integration of bit bucket into vra.

Additional Information

Impact/Risks:
Manual modification of the vPostgres database can have unintended consequences.

Please create backups before proceeding.