delete the DC extensions when web ui failed to remove

Products

• VMware Cloud Director

Issue/Introduction

delete the unwanted DC extension from vcd provider DB directly

Symptoms:
after modify some configuration in L2 applicance from On-perm extender, there is no update in provider extender side due to somewhere stucked,  neither customer is able to delete the DC extension for next try.
there is also endless rotative error log on the deletion request.

Environment

VMware vCloud Director Extender 1.x

Resolution

1.login to vcd provider extender:
password=`grep -w password /opt/vmware/mobility-service/conf/connconfig.yaml | awk -F':' '{print $2}' | tr -d "[[:space:]]" | tr -d "\'"` && export PGPASSWORD=$password && /opt/vmware/vpostgres/current/bin/psql mobility_db mobility_db

2.select * from stretched_network_tbl;

3.make sure which item is unwanted and perform:

delete from stretched_network_tbl where id = '';

if only one item defined:

delete from stretched_network_tbl;

4.login to vcd extender web ui and check if the DC extension removed.