openSAP HANA 7 exercise 2.8 - service for the hdi container is not available after mtar deployment

[FranklinAsis]

Hello,

Installation scenario: Hana express edition on preconfigured VM on my laptop.

I've downloaded the mtar file from github as indicated in the exercise. I deployed the mtar via XS CLI using ''xs deploy <file> --use-namespaces". I encountered an error was regarding the task "deploy" not being executed for the mtar.

12 Aug 2020, 14:13:10 | ATTENTION | XSA_ADMIN | Failed to stage app 'openSAP.CentralDB.db' [Org 'HANAExpress', Space 'SAP'].

12 Aug 2020, 14:13:10 | ERROR | XSA_ADMIN | Failed to stage droplet with id 1 of app 'openSAP.CentralDB.db' [Org 'HANAExpress', Space 'SAP']. For more information see '/hana/shared/HXE/xs/controller_data/controller/tracing/droplet/4ae76c3c-2e55-436d-8382-5ffed6da1ff1-stdout' and '/hana/shared/HXE/xs/controller_data/controller/tracing/droplet/4ae76c3c-2e55-436d-8382-5ffed6da1ff1-stderr'.

I then tried the command again, but got the error that deployment was cancelled because nothing was changed/updated in the mtar file. I navigated to the XSA Cockpit via webide, space "SAP" - I saw the application already there, so I restaged and started the app.

I proceeded with step 2, trying to add a new service connection, but the service isn't available.

Did I miss anything? Please advise, thanks!

Best,

Frank

[thomas_jung · Accepted solution]

The xs deploy does several things. It not only stages and starts the application but also creates and binds service instances. Just restaging and starting the application might well not fix the issue.

You need to know why the initial deployment failed. Those linked logs in the original error message are critical to knowing what went wrong. Without them all we know is there was an error but not what that error was.

[FranklinAsis · Accepted solution]

Hi Thomas,

Thanks for your response.

I navigated to the deploy-service logs and filtered it for "opensap.CentralDB" (I can send the whole log - all 4k+ lines if you're interested):

(9223372036854773304)[+1597205508097] [APP/2-0] ERR Process "17587" attempting to acquire lock for operation on MTA "openSAP.CentralDB"
(9223372036854773308)[+1597205509445] [APP/2-0] ERR Process "17587" acquired lock for operation on MTA "openSAP.CentralDB"
(9223372036854773655)[+1597205529049] [APP/2-0] ERR Creating service "openSAP.CentralDB.opensap-central-container" from MTA resource "opensap-central-container"...
(9223372036854773659)[+1597205554512] [APP/2-0] ERR Creating application "openSAP.CentralDB.db" from MTA module "db"...
(9223372036854773663)[+1597205561610] [APP/2-0] ERR Uploading application "openSAP.CentralDB.db"...
(9223372036854773667)[+1597205583998] [APP/2-0] ERR Staging application "openSAP.CentralDB.db"...
(9223372036854773671)[+1597205603048] [APP/2-0] ERR Error staging application "openSAP.CentralDB.db": 200 Application staging failed
(9223372036854773762)[+1597209163343] [APP/2-0] ERR Process "17587" attempting to release lock for operation on MTA "openSAP.CentralDB"
(9223372036854773766)[+1597209163698] [APP/2-0] ERR Process "17587" released lock for operation on MTA "openSAP.CentralDB"
(9223372036854773804)[+1597209259263] [APP/2-0] ERR Process "17973" attempting to acquire lock for operation on MTA "openSAP.CentralDB"
(9223372036854773810)[+1597209263543] [APP/2-0] ERR Process "17973" acquired lock for operation on MTA "openSAP.CentralDB"
(9223372036854774161)[+1597209289210] [APP/2-0] ERR Detected deployed MTA with ID "openSAP.CentralDB" and version "1.1.2019"
(9223372036854774223)[+1597209667371] [APP/2-0] ERR Service "openSAP.CentralDB.opensap-central-container" is not modified and will not be updated
(9223372036854774269)[+1597209822249] [APP/2-0] ERR Updating application "openSAP.CentralDB.db"...
(9223372036854774273)[+1597209822653] [APP/2-0] ERR Service "openSAP.CentralDB.opensap-central-container" will not be rebound to application "openSAP.CentralDB.db" because the binding parameters are not modified
(9223372036854774277)[+1597209822680] [APP/2-0] ERR Application "openSAP.CentralDB.db" is not modified and will not be updated
(9223372036854774281)[+1597209823116] [APP/2-0] ERR Uploading application "openSAP.CentralDB.db"...
(9223372036854774307)[+1597209863428] [APP/2-0] ERR Executing task "deploy" on application "openSAP.CentralDB.db"...
(9223372036854774313)[+1597209864683] [APP/2-0] ERR Error executing task "deploy" on application "openSAP.CentralDB.db": Controller operation failed: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774318)[+1597209864796] [APP/2-0] ERR org.cloudfoundry.client.lib.CloudControllerException: Controller operation failed: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774348)[+1597209864796] [APP/2-0] ERR Caused by: org.cloudfoundry.client.lib.CloudOperationException: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774355)[+1597209864796] [APP/2-0] ERR Caused by: com.sap.xs2rt.client.exceptions.ResourceNotFoundException: Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774361)[+1597209864796] [APP/2-0] ERR Caused by: com.sap.xs2rt.core.rest.client.RestResponseException: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774369)[+1597209868585] [APP/2-0] ERR org.flowable.common.engine.api.FlowableException: Controller operation failed: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774392)[+1597209868585] [APP/2-0] ERR Caused by: org.cloudfoundry.client.lib.CloudControllerException: Controller operation failed: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774402)[+1597209868585] [APP/2-0] ERR Caused by: org.cloudfoundry.client.lib.CloudOperationException: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774409)[+1597209868585] [APP/2-0] ERR Caused by: com.sap.xs2rt.client.exceptions.ResourceNotFoundException: Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774415)[+1597209868585] [APP/2-0] ERR Caused by: com.sap.xs2rt.core.rest.client.RestResponseException: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).
(9223372036854774508)[+1597214825916] [APP/2-0] ERR Process "17973" attempting to release lock for operation on MTA "openSAP.CentralDB"
(9223372036854774512)[+1597214840424] [APP/2-0] ERR Process "17973" released lock for operation on MTA "openSAP.CentralDB"

I tried xs deploy several times;

1st attempt ended with : Error staging application "openSAP.CentralDB.db": 200 Application staging failed

2nd attempt : prompted me a y/n question about an ongoing process, which i presumed to be my first failed attempt - this ended up with several messages:

- ERR Detected deployed MTA with ID "openSAP.CentralDB" and version "1.1.2019"

- ERR Service "openSAP.CentralDB.opensap-central-container" is not modified and will not be updated ERR Updating application "openSAP.CentralDB.db"...

- ERR Service "openSAP.CentralDB.opensap-central-container" will not be rebound to application "openSAP.CentralDB.db" because the binding parameters are not modified

- ERR Application "openSAP.CentralDB.db" is not modified and will not be updated

After which, I got the error: Error executing task "deploy" on application "openSAP.CentralDB.db": Controller operation failed: 404 Not Found: Could not run task "deploy" on application "openSAP.CentralDB.db": Could not run task deploy on app openSAP.CentralDB.db, resource not found: Cannot start task on unstaged application "openSAP.CentralDB.db" (no droplet available).

This was the point I went on to XSA Cockpit and saw the application there, I figured maybe, I just need to restage and restart.

I can see the service binding for the app though.

How can I fix this? And what did I do wrong on my initial deployment?

Thanks again for having the time to look at this.

Best,

Frank

[thomas_jung · Accepted solution]

There is nothing here to point to a specific error with the content, just an unable to stage which would seem to be a low level technical/infrastructure issue.

But you show in the cockpit that the HDI container is created but you don't see it in the Database Explorer? Are you sure you aren't just mismatching the spaces. I can see from your screenshots you are importing into the SAP space (which is unusual). In the Database Explorer perhaps you are only looking at/have access to the containers in the dev space?

[FranklinAsis · Accepted solution]

Hi Thomas,

I can see the service binding in the cockpit and I was also able to add the database and open the tables and data in the DB explorer. However, when I try adding a new HANA Service connection for the db module of my project, I don't see the HDI container for the opensap.centralDB:

Best,

Frank

[thomas_jung · Accepted solution]

This is likely because of what I said earlier. You are importing this into the SAP space but your DB Explorer is only showing you the development space.

[FranklinAsis · Accepted solution]

Finally solved it.

- in xs cli, I logged onto the SAP space and undeployed the app and deleted the service that came with the app

- then logged onto the development space and deployed the mtar

Thanks for your time and all your help Thomas!

Best,

Frank