Deploy a CAP Business Service to SAP Business Technology Platform - Deployment failed for my-bookshop-db-deployer

[FarozanFarman]

Tutorials: https://developers.sap.com/tutorials/cap-service-deploy.html

Issue: Deployment failed for my-bookshop-db-deployer

Steps to reproduce:

1. Follow: https://developers.sap.com/mission.cp-starter-extensions-cap.html
2. In the second tutorial: https://developers.sap.com/tutorials/cap-service-deploy.html
3. Step 3: Deploy using cf deploy

Here, the deployment fails:

The logs just reads that the connection to DB fails. On identifying and discovering, I found that if we change the configuration of the DB from "Allow only BTP IP addresses" to "Allow all IP addresses", the connection and deployment works fine.
This is because I am deploying it from VScode, which is an external client.

Solution:
As we are using VS code for editing and deployment,while mentioning the Prerequisites
"You’ve to Use an existing SAP HANA Cloud service instance or set up a new SAP HANA Cloud service instance to deploy your CAP application":
A note has to be made regarding the configuration of the DB from "Allow only BTP IP addresses" to "Allow all IP addresses"

In the mentioned link, in the "Set Up the SAP HANA Cloud Service" link - https://developers.sap.com/tutorials/btp-app-hana-cloud-setup.html#3b20e31c-e9eb-44f7-98ed-ceabfd9e586e, the DB is created using - "Allow all IP addresses"

Please make the changes accordingly.

Labels to me added:

Sprint Label: 2210A
Scenario Label: SCPTest-banode
Landscape Label: trial2
Priority: High

Thanks and Regards,
Farozan

[renejeglinsky]

Thanks you @FarozanFarman! Makes absolutely sense.

[renejeglinsky]

I decided to not recommend the "Allow all IP adresses" option, I included it as a troubleshooting note.