CAP DB Deployer crashing, Not loading data from backend HANA Cloud

[mubashirp27]

I tried to make a trial fiori launchpad through SAP BTP. Hana Cloud as backend. I redeployed it many time and i am facing the db-deployer crashing issues many times.

ALSO PLEASE SUGGEST ME THE GOOD FULL STACK TUTORIAL FOR A CUSTOM LAUNCHPAD USING SAP BTP, SAP UI5, FIORI ETC.

I don't what is the reason behind this issue. At first i faced an issue related to MTA deployment stating nodejs buildpack is not working. As per: https://answers.sap.com/questions/13526726/error-staging-nodejs-application-cloud-foundry.html

Tried adding engine, nodes new versions, nodejs buildpack direct zip file, but still db deployer crashes.

I thought might be the space issues, space is not utilized much so still that's not the issue.

PACKAGE.JSON:

{ "name": "MyHANAApp", "version": "1.0.0", "description": "A simple CAP project.", "repository": "<Add your repository here>", "license": "UNLICENSED", "private": true, "dependencies": { "@sap/cds": "^5", "@sap/hana-client": "^2.12.13", "express": "^4", "hdb": "^0.18.3" }, "scripts": { "start": "cds run", "undeploy": "cf undeploy MyHANAApp --delete-services --delete-service-keys", "watch-front_ui_mat": "cds watch --open front_ui_mat/webapp/index.html?sap-ui-xx-viewCache=false#fe-lrop-v4" }, "eslintConfig": { "extends": "eslint:recommended", "env": { "es2020": true, "node": true, "jest": true, "mocha": true }, "globals": { "SELECT": true, "INSERT": true, "UPDATE": true, "DELETE": true, "CREATE": true, "DROP": true, "CDL": true, "CQL": true, "CXL": true, "cds": true }, "rules": { "no-console": "off", "require-atomic-updates": "off" } }, "cds": { "build": { "target": "." }, "hana": { "deploy-format": "hdbtable" }, "requires": { "db": { "kind": "hana" } } }, "devDependencies": { "@sap/hdi-deploy": "4.3.0", "@sap/ux-specification": "^1.96.9" }, "sapux": [ "app/frondend", "app/frontend2", "app/front_ui_mat" ]}

Problems showing this warning:

Problems loading reference 'vscode://schemas/workspaceConfig': Unable to load schema from 'vscode://schemas/workspaceConfig': A resource provider for 'vscode://schemas/workspaceConfig' is not registered.
_generated_diagnostic_collection_name_#1bcd0320-82b4-448b-96a7-e36dd603e7fc(768)
[1, 1]<br>

MTA.YAML file:

_schema-version: "3.1"ID: MyHANAAppdescription: A simple CAP project.version: 1.0.0modules:- name: MyHANAApp-srv type: nodejs path: srv requires: - name: MyHANAApp-db - name: uaa_MyHANAApp provides: - name: srv-api properties: srv-url: ${default-url} parameters: buildpack: nodejs_buildpack hostname: ${appname} build-parameters: builder: npm-ci ignore: - .env - ./node_modules- name: MyHANAApp-db-deployer type: hdb path: db requires: - name: MyHANAApp-db parameters: buildpack: https://github.com/cloudfoundry/nodejs-buildpack/releases/download/v1.7.25/nodejs-buildpack-cflinuxf... build-parameters: ignore: - .env - ./node_modules- name: MyHANAApp-destination-content type: com.sap.application.content requires: - name: MyHANAApp-destination-service parameters: content-target: true - name: MyHANAApp_html_repo_host parameters: service-key: name: MyHANAApp_html_repo_host-key - name: uaa_MyHANAApp parameters: service-key: name: uaa_MyHANAApp-key parameters: content: instance: destinations: - Name: hana_app_MyHANAApp_html_repo_host ServiceInstanceName: MyHANAApp-html5-app-host-service ServiceKeyName: MyHANAApp_html_repo_host-key sap.cloud.service: hana.app - Authentication: OAuth2UserTokenExchange Name: hana_app_uaa_MyHANAApp ServiceInstanceName: MyHANAApp-xsuaa-service ServiceKeyName: uaa_MyHANAApp-key sap.cloud.service: hana.app existing_destinations_policy: ignore build-parameters: no-source: true- name: MyHANAApp-app-content type: com.sap.application.content path: . requires: - name: MyHANAApp_html_repo_host parameters: content-target: true build-parameters: build-result: resources requires: - artifacts: - frondend.zip name: frondend target-path: resources/ - artifacts: - frontend2.zip name: frontend2 target-path: resources/ - artifacts: - frontuimat.zip name: frontuimat target-path: resources/- name: frondend type: html5 path: app/frondend build-parameters: build-result: dist builder: custom commands: - npm install - npm run build:cf supported-platforms: []- name: frontend2 type: html5 path: app/frontend2 build-parameters: build-result: dist builder: custom commands: - npm install - npm run build:cf supported-platforms: []- name: frontuimat type: html5 path: app/front_ui_mat build-parameters: build-result: dist builder: custom commands: - npm install - npm run build:cf supported-platforms: []resources:- name: MyHANAApp-db type: com.sap.xs.hdi-container parameters: service: hana service-plan: hdi-shared properties: hdi-service-name: ${service-name}- name: MyHANAApp-destination-service type: org.cloudfoundry.managed-service parameters: config: HTML5Runtime_enabled: true init_data: instance: destinations: - Authentication: NoAuthentication Name: ui5 ProxyType: Internet Type: HTTP URL: https://ui5.sap.com existing_destinations_policy: update version: 1.0.0 service: destination service-name: MyHANAApp-destination-service service-plan: lite- name: MyHANAApp_html_repo_host type: org.cloudfoundry.managed-service parameters: service: html5-apps-repo service-name: MyHANAApp-html5-app-host-service service-plan: app-host- name: uaa_MyHANAApp type: org.cloudfoundry.managed-service parameters: path: ./xs-security.json service: xsuaa service-name: MyHANAApp-xsuaa-service service-plan: applicationparameters: appname: unique-2002 deploy_mode: html5-repo enable-parallel-deployments: truebuild-parameters: before-all: - builder: custom commands: - npm ci - npx -p @sap/cds-dk cds build --production

[gregorw]

If you format your question better I think it might have chances to get answered.