Update HDI Container from copied Tenant

[draschke]

Hi experts,

we could use some help.

We have copied a Hana (sps05) tenant on the same host, which has worked quite well so far.

Afterwards we wanted to remove the HDI containers copied to the new tenant, but unfortunately we haven't managed to do that yet.

Since there was no space from the source after the copy, we deleted the users SYS_XS* on the new tenant to be able to activate the new tenant for XSA. This worked as far as it could.

Steps:

1.

DROP USER SYS_XSA CASCADE;

DROP USER SYS_XS_HANA_BROKER CASCADE;

DROP USER SYS_XS_HANA_BROKER_INTERNAL CASCADE;

2.

xs enable-tenant-database NEW-TENANT

The only problem is that the old HDI containers are still there, although we had hoped that these would disappear with the XSA activation of the new tenant.

Does anyone have an idea how we can get the old HDI containers undeployed?

[draschke]

It would be even better if we could update the HDI container in the new copied tenant.

Unfortunately, deploying is not possible and always ends with an error "HDI container already exists".

This message is of course correct, as it was also copied intentionally. However, we would like to continue using and updating the HDI container!

Any help would be great!

[draschke]

xs deploy -f your.mtar

Deployment fails with....

Creating service "your-hdi-container"...

create in progress

FAILED: Asynchronous job 'Creating service instance 'your-hdi-container' [service: 'hana', plan:'hdi-shared'] of [Org 'TEMPLATE', Space 'SECURITY'].' failed: Failed to check existence of container 'YOUR-CONTAINER_NAME', because of: Container 'your-container_name'

exists in wrong container group 'CG_SYS_XS_HANA_BROKER_0' (expected container group 'CG_SYS_XS_HANA_BROKER_1'

Call procedure and move the container to the expected group 'CG_SYS_XS_HANA_BROKER_1'

CALL _SYS_DI.MOVE_CONTAINER_TO_GROUP('YOUR-CONTAINER_NAME', 'CG_SYS_XS_HANA_BROKER_1', _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);

After executing the procedure check the group

SELECT * FROM _SYS_DI.M_ALL_CONTAINERS where CONTAINER_NAME = 'YOUR-CONTAINER_NAME'

| CONTAINER_NAME | CREATE_USER_NAME | CREATE_APPUSER_NAME | CREATE_TIMESTAMP_UTC | CONTAINER_GROUP_NAME |

| YOUR-CONTAINER_NAME | SYS_XS_HANA_BROKER | SYS_XS_HANA_BROKER | 01.08.2022, 19:33:19.688 | CG_SYS_XS_HANA_BROKER_1 |

set reuse_hdi_container on true

xs create-service hana hdi-shared your-hdi-container -c '{"schema": "YOUR-CONTAINER_NAME", "reuse_hdi_container": true}'

sidadm@host:/usr/sap/sidadm/home/deploy/sec>

xs ds -f your-hdi-container

Deleting service instance "your-hdi-container"...

delete in progress

delete succeeded

OK

Now you are ready to update your mtar. 🙂

xs deploy -f your.mtar