cancel
Showing results for 
Search instead for 
Did you mean: 

Cloud Foundry : Failed to deployed MTA application

guigui
Employee
Employee
0 Kudos

Hello everyone,

Anyone else is experiencing issues with hdi-container service ?

I'm trying to deploy a MTA application on CF but the following errors is displayed:

Creating service "hdi_pharma1234_db" from MTA resource "hdi_pharma1234_db"...Error monitoring creation of services: Error creating service "hdi_pharma1234_db" from offering "hana" and plan "hdi-shared": Failed to create HDI container on database 'b41c40e1-7edc-40d8-b2f2-3fee5bff38bf' (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:21920), because of: Call to HANA DI failed, requestId 2278, because of: Could not create the container "PHARMA1234" (8211042), because of: The container "PHARMA1234" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) with error: unique constraint violation on pos=0 for table H00::_SYS_DI:CONTAINERS_$delta_1$en, key: CONTAINER_NAME=PHARMA1234 already exists as udiv=4 (8201003), because of: Creating the container "PHARMA1234"... failed (8214129)Unexpected error: Error creating service "hdi_pharma1234_db" from offering "hana" and plan "hdi-shared": Failed to create HDI container on database 'b41c40e1-7edc-40d8-b2f2-3fee5bff38bf' (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:21920), because of: Call to HANA DI failed, requestId 2278, because of: Could not create the container "PHARMA1234" (8211042), because of: The container "PHARMA1234" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) with error: unique constraint violation on pos=0 for table H00::_SYS_DI:CONTAINERS_$delta_1$en, key: CONTAINER_NAME=PHARMA1234 already exists as udiv=4 (8201003), because of: Creating the container "PHARMA1234"... failed (8214129)Exception occured during execution: "Error creating service "hdi_pharma1234_db" from offering "hana" and plan "hdi-shared": Failed to create HDI container on database 'b41c40e1-7edc-40d8-b2f2-3fee5bff38bf' (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:21920), because of: Call to HANA DI failed, requestId 2278, because of: Could not create the container "PHARMA1234" (8211042), because of: The container "PHARMA1234" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) with error: unique constraint violation on pos=0 for table H00::_SYS_DI:CONTAINERS_$delta_1$en, key: CONTAINER_NAME=PHARMA1234 already exists as udiv=4 (8201003), because of: Creating the container "PHARMA1234"... failed (8214129)"To download logs of the process, use the multi-target application plug-in for the Cloud Foundry CLI command "cf dmol -i 32072579" directly in your Cloud Foundry space.

The Hana database version is 2.0 SPS 04

I do not know where to investigate to fix that issue, if you have any advice, please let me know.

Regards/

Guillaume

Accepted Solutions (0)

Answers (3)

Answers (3)

zzottaa
Discoverer
0 Kudos

Hello everyone,

Have you found any solution to this issue?

Best Regards,

Andreea

jwschwab
Member
0 Kudos

Hi Ivan,
we have the same issue, Guillaume describes.
We deleted Application and Service Instance of the HDI container on the XS console, but the error sustains.

What do you exanctly mean with "a) delete the container" ?

Best Regards

Josef


Error details:
Error creating services: Error creating service "hdi_BB_DB_APPR" from offering "hana" and plan "hdi-shared": Controller operation failed: 400 Bad Request: Could not create service "hdi_BB_DB_APPR": Asynchronous job 'Creating service instance 'hdi_BB_DB_APPR' [service: 'hana', plan:'hdi-shared'] of [Org 'Linde', Space 'DEV'].' failed: Failed to create HDI container on database '45290a62-de5b-4589-b4a7-15c6902b0eba' (dmlxd1.le.grp:30115), because of: Call to HANA DI failed, requestId 27958, because of: Creating the container "BB_DB_APPR"... failed (8214129), because of: Could not create the container "BB_DB_APPR" (8211042), because of: The container "BB_DB_APPR" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) (8201003) Unexpected error: Error creating service "hdi_BB_DB_APPR" from offering "hana" and plan "hdi-shared": Controller operation failed: 400 Bad Request: Could not create service "hdi_BB_DB_APPR": Asynchronous job 'Creating service instance 'hdi_BB_DB_APPR' [service: 'hana', plan:'hdi-shared'] of [Org 'Linde', Space 'DEV'].' failed: Failed to create HDI container on database '45290a62-de5b-4589-b4a7-15c6902b0eba' (dmlxd1.le.grp:30115), because of: Call to HANA DI failed, requestId 27958, because of: Creating the container "BB_DB_APPR"... failed (8214129), because of: Could not create the container "BB_DB_APPR" (8211042), because of: The container "BB_DB_APPR" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) (8201003) Exception occured during execution: "Error creating service "hdi_BB_DB_APPR" from offering "hana" and plan "hdi-shared": Controller operation failed: 400 Bad Request: Could not create service "hdi_BB_DB_APPR": Asynchronous job 'Creating service instance 'hdi_BB_DB_APPR' [service: 'hana', plan:'hdi-shared'] of [Org 'Linde', Space 'DEV'].' failed: Failed to create HDI container on database '45290a62-de5b-4589-b4a7-15c6902b0eba' (dmlxd1.le.grp:30115), because of: Call to HANA DI failed, requestId 27958, because of: Creating the container "BB_DB_APPR"... failed (8214129), because of: Could not create the container "BB_DB_APPR" (8211042), because of: The container "BB_DB_APPR" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) (8201003)" ERR Error creating services: Error creating service "hdi_BB_DB_APPR" from offering "hana" and plan "hdi-shared": Controller operation failed: 400 Bad Request: Could not create service "hdi_BB_DB_APPR": Asynchronous job 'Creating service instance 'hdi_BB_DB_APPR' [service: 'hana', plan:'hdi-shared'] of [Org 'Linde', Space 'DEV'].' failed: Failed to create HDI container on database '45290a62-de5b-4589-b4a7-15c6902b0eba' (dmlxd1.le.grp:30115), because of: Call to HANA DI failed, requestId 27958, because of: Creating the container "BB_DB_APPR"... failed (8214129), because of: Could not create the container "BB_DB_APPR" (8211042), because of: The container "BB_DB_APPR" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) (8201003) Unexpected error: Error creating service "hdi_BB_DB_APPR" from offering "hana" and plan "hdi-shared": Controller operation failed: 400 Bad Request: Could not create service "hdi_BB_DB_APPR": Asynchronous job 'Creating service instance 'hdi_BB_DB_APPR' [service: 'hana', plan:'hdi-shared'] of [Org 'Linde', Space 'DEV'].' failed: Failed to create HDI container on database '45290a62-de5b-4589-b4a7-15c6902b0eba' (dmlxd1.le.grp:30115), because of: Call to HANA DI failed, requestId 27958, because of: Creating the container "BB_DB_APPR"... failed (8214129), because of: Could not create the container "BB_DB_APPR" (8211042), because of: The container "BB_DB_APPR" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) (8201003) Exception occured during execution: "Error creating service "hdi_BB_DB_APPR" from offering "hana" and plan "hdi-shared": Controller operation failed: 400 Bad Request: Could not create service "hdi_BB_DB_APPR": Asynchronous job 'Creating service instance 'hdi_BB_DB_APPR' [service: 'hana', plan:'hdi-shared'] of [Org 'Linde', Space 'DEV'].' failed: Failed to create HDI container on database '45290a62-de5b-4589-b4a7-15c6902b0eba' (dmlxd1.le.grp:30115), because of: Call to HANA DI failed, requestId 27958, because of: Creating the container "BB_DB_APPR"... failed (8214129), because of: Could not create the container "BB_DB_APPR" (8211042), because of: The container "BB_DB_APPR" already exists (8211040), because of: Database error 301: : unique constraint violated: Table(CONTAINERS_) (8201003)"

Ivan-Mirisola
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi jwschwab

Could you share your mta here to I can have a look?

Best regards,
Ivan

Ivan-Mirisola
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi jwschwab

Apparently I've missed this comment. Could you please read my comment above.

Best regards,
Ivan

Ivan-Mirisola
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Guillaume,

The error seems pretty clear to me that there is an HDI container in that space with the same name:

The container "PHARMA1234" already exists

You could: a) delete the container b) change the container name c) adapt your mta to use the existing container instead of letting SCP to create one for you.

Best regards,
Ivan

sahud
Participant
0 Kudos

Hi Ivan,

Is there a way to use the existing container if it exists else create a new one. If you could help with the keyword, that would be great.

We have a scenario where 2 node modules (mtas) are using the sap container so it fails when the second MTA is deployed

Thanks.

Ivan-Mirisola
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi sahud,My understanding is that the MTA that contains the hdb module should contain a resource of type "com.sap.xs.hdi-container". According to the documentation, this HDI container will be created only once (the firt time you deploy it to CF). Usually you see a message on WebIDE on the deployer stating that there is no need to create the container as it already existis in the space.
Since you've mentioned you have another MTA, that one should have a resource with type "org.cloudfoundry.existing-service" and shouldn't have a db module. You might want to work with the cross-container access if you require some two MTAs with their own db modules to access data from each other.

If you share the contents of your MTAs, I'd glad to have look at them.

Best regards,
Ivan