unable to deploy db folder in hana database and CAP

[manu-deore]

hello connections ,

i am facing some issues regarding deploying DB folder in MYhanaapp database.

facing error :Executing task in folder myhanaapp: echo 'Prepared environment for deployment' && (npm ls --depth 0 --production || npm install) && (node ../db/node_modules/@sap/hdi-deploy/deploy.js "--exit")

Prepared environment for deployment

npm WARN config production Use `--omit=dev` instead.

deploy@ /home/user/projects/myhanaapp/db

└── @Sap/hdi-deploy@4.6.0

VCAP_SERVICES: {

"hana": [

{

"name": "myhanaapp-hdi",

"instance_name": "myhanaapp-hdi",

"label": "hana",

"tags": [

"hana",

"database",

"relational",

"mta-resource-name:myhanaapp-db",

"endpoint:https://api.cf.us10-001.hana.ondemand.com",

"org:66335cd5trial",

"space:dev"

],

"plan": "hdi-shared",

"credentials": {

"certificate": "-----BEGIN CERTIFICATE-----\nMIIDrzCCApegAwIBAgIQCDvgVpBCRrGhdWrJWZHHSjANBgkqhkiG9w0BAQUFADBh\nMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3\nd3cuZGlnaWNlcnQuY29tMSAwHgYDVQQDExdEaWdpQ2VydCBHbG9iYWwgUm9vdCBD\nQTAeFw0wNjExMTAwMDAwMDBaFw0zMTExMTAwMDAwMDBaMGExCzAJBgNVBAYTAlVT\nMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5j\nb20xIDAeBgNVBAMTF0RpZ2lDZXJ0IEdsb2JhbCBSb290IENBMIIBIjANBgkqhkiG\n9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4jvhEXLeqKTTo1eqUKKPC3eQyaKl7hLOllsB\nCSDMAZOnTjC3U/dDxGkAV53ijSLdhwZAAIEJzs4bg7/fzTtxRuLWZscFs3YnFo97\nnh6Vfe63SKMI2tavegw5BmV/Sl0fvBf4q77uKNd0f3p4mVmFaG5cIzJLv07A6Fpt\n43C/dxC//AH2hdmoRBBYMql1GNXRor5H4idq9Joz+EkIYIvUX7Q6hL+hqkpMfT7P\nT19sdl6gSzeRntwi5m3OFBqOasv+zbMUZBfHWymeMr/y7vrTC0LUq7dBMtoM1O/4\ngdW7jVg/tRvoSSiicNoxBN33shbyTApOB6jtSj1etX+jkMOvJwIDAQABo2MwYTAO\nBgNVHQ8BAf8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAdBgNVHQ4EFgQUA95QNVbR\nTLtm8KPiGxvDl7I90VUwHwYDVR0jBBgwFoAUA95QNVbRTLtm8KPiGxvDl7I90VUw\nDQYJKoZIhvcNAQEFBQADggEBAMucN6pIExIK+t1EnE9SsPTfrgT1eXkIoyQY/Esr\nhMAtudXH/vTBH1jLuG2cenTnmCmrEbXjcKChzUyImZOMkXDiqw8cvpOp/2PV5Adg\n06O/nVsJ8dWO41P0jmP6P6fbtGbfYmbW0W5BjfIttep3Sp+dWOIrWcBAI+0tKIJF\nPnlUkiaY4IBIqDfv8NZ5YBberOgOzW6sRBc4L0na4UU+Krk2U886UAb3LujEV0ls\nYSEY1QSteDwsOoBrp+uvFRTp2InBuThs4pFsiv9kuXclVzDAGySj4dzp30d8tbQk\nCAUw7C29C79Fv1C5qfPrmAESrciIxpg0X40KPMbp1ZWVbd4=\n-----END CERTIFICATE-----",

"database_id": "ca513dcf-9277-4548-b93b-ed13a5242eb8",

"driver": "com.sap.db.jdbc.Driver",

"hdi_p[...]

"hdi_user": "MYHANAAPP_HDI_MYHANAAPP_DB_DEPLOYER_1_6FS3WXLE93FH2OSK3RAOP6ZN3_DT",

"host": "ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com",

"p[...]

"port": "443",

"schema": "MYHANAAPP_HDI_MYHANAAPP_DB_DEPLOYER_1",

"service_key_name": "SharedDevKey",

"url": "jdbc:sap://ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443?encrypt=true&validateCertificate=true¤tschema=MYHANAAPP_HDI_MYHANAAPP_DB_DEPLOYER_1",

"user": "MYHANAAPP_HDI_MYHANAAPP_DB_DEPLOYER_1_6FS3WXLE93FH2OSK3RAOP6ZN3_RT"

}

}

]

}

@Sap/hdi-deploy, version 4.6.0 (mode default), server version unknown (0.0.0.0), cloud version , node version 16.19.0, HDI version -1, container API version -1

Deployment started at 2023-04-11 13:54:18

Using hana-client for connection

Detection of server version failed; root cause: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:43540 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

Detection of cloud version failed; root cause: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:60358 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

Detection of container API version failed; root cause: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:52628 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

Detection of HDI version failed; root cause: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:52646 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

Using default environment variables from file "default-env.json"

The server does not support live updating of make messages. The messages will be displayed, when the make is done.

No ignore file at /home/user/projects/myhanaapp/db/.hdiignore.

Collecting files...

Collecting files... ok (0s 4ms)

2 directories collected

17 files collected

0 reusable modules collected

Target service: myhanaapp-hdi

Could not check if session variable APPLICATION is set correctly: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:43564 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

Could not determine status of last build: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:52668 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

Processing revoke files...

Processing revoke files... ok (0s 0ms)

Processing grants files...

Processing grants files... ok (0s 0ms)

Preprocessing files...

Preprocessing files... ok (0s 1ms)

Connecting to the container "MYHANAAPP_HDI_MYHANAAPP_DB_DEPLOYER_1"...

Deployment to container MYHANAAPP_HDI_MYHANAAPP_DB_DEPLOYER_1 failed - error: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed (100.96.21.68:60388 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443)) [Deployment ID: none].

Deployment ended at 2023-04-11 13:54:18

Error: Connection failed (RTE:[300015] SSL certificate validation failed: error code: 337047686, file:../ssl/statem/statem_clnt.c, line:1914 - error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

(100.96.21.68:60388 -> ca513dcf-9277-4548-b93b-ed13a5242eb8.hana.trial-us10.hanacloud.ondemand.com:443))

(0s 354ms

* The terminal process "/bin/bash '-c', 'echo 'Prepared environment for deployment' && (npm ls --depth 0 --production || npm install) && (node ../db/node_modules/@sap/hdi-deploy/deploy.js "--exit")'" terminated with exit code: 1.

* Terminal will be reused by tasks, press any key to close it.

[mmarkvillanueva]

I'm facing a similar issue. db-deployer log says "Could not check if session variable APPLICATION is set correctly". did you already solve your issue? thanks!