Cannot delete deployment due to malformed name with error "Missing input object (TelException)"

Products

• VCF Automation

Issue/Introduction

Custom naming expression was used to name deployments but was malformed leading to a deployment being created with the expression as the name. Cannot delete the deployment due to this scenario with the error message "Missing input object (TelException)"

Environment

Aria Automation 8.18.x

Cause

Cannot be deleted due to input variables

Resolution

Prerequisites

Please take a backup of your Aria Automation nodes before proceeding.

Procedure

1. SSH to a Aria Automation node
2. Run this command to connect to the catalog-db
   1. vracli dev psql catalog-db
   2. Use this command to enable extended view
      1. \x
3. Find the problematic deployment from Service Broker and copy the deployment id from the URL (example: https://<Aria Automation URL>/automation/#/service/automation-ui/deployment-ui;ash=%2Fworkload%2Fdeployment%2F########-####-####-####-############)
4. Use this command to find the deployment in the catalog database
   1. select * from dep_deployment where id = 'deployment_id';
5. Update the name of the deployment so you can delete it successfully using this command
   1. update dep_deployment set name = 'new_name' where id = 'deployment_id';
6. Login to Aria Automation user interface and retry the deployment deletion.