3206874 - Not able to create or import HDI container due to the container already exists

After upgrading or reinstalling the XSA component, you may encounter an error indicating that the container already exists in the system, preventing you from deploying the package while importing the container. This issue persists even after manually deleting the container.

From the MAIN_LOG, you can observe the following exception:

Caused by: com.sap.xs2rt.client.exceptions.XsClientException: Asynchronous job 'Creating service instance 'hdi_hana1' [service: 'hana', plan:'hdi-shared'] of [Org 'orgname', Space 'PROD'].' failed: Failed to create HDI container on database 'xxxxxxxxxxxxxx' (<hostname>:<port>), because of: Call to HANA DI failed, requestId 123456789, because of: Could not create the container "HANA1" (8211042), because of: The container "HANA1" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) with error: unique constraint violation on pos=0 for table HA2::_SYS_DI:CONTAINERS_en, key: CONTAINER_NAME=HANA1 already exists as udiv=8 (8201003), because of: Creating the container "HANA1 "... failed (8214129)

• SAP HANA, platform edition 2.0
• SAP HANA Cloud 1.0
• SAP Busyness Application  
• HDI
• SAP WEB IDE

XS Advanced, XSA, HDI, delete-service, ds, Failed to deprovision service instance, Could not delete the container, bas, Could not create the container, (8211042), The container already exists (8211040), because of: Database error 301: unique constraint violated: Table(CONTAINERS_), unique constraint violation for table H00::_SYS_DI:CONTAINERS_en, key: CONTAINER_NAME=XXX already exists , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , Known Error