Question Re: Create HANA DB on Cloudfoundry via CLI in Technology Q&A

Create HANA DB on Cloudfoundry via CLI

MarcoHöpner — Fri, 29 Oct 2021 12:50:34 GMT

Hi,

on cloudfoundry i'm trying to create a hana db without success.

I'm using a trial account and my cli looks like :

cf create-service hana-cloud-trial hana myhana -c '{"SystemPassword":"1234567","SourceIP":"0.0.0.0.0/0","dpserver":"true","vcpu":"2","memory":"30","storage":"120"}'

I always get the error:

Service broker error : Service broker hana-cloud-trail failed with: Invalid Paramter (memory): Required for HANA [....]

If i use the -v flag i got error:

HTTP/1.1 502 Bad Gateway ...

"code": 10001

"error_code":" CF-ServiceBrokerBadResponse"

I'm using the V7 Version of the cli.

Any help is welcome.

Marco

Re: Create HANA DB on Cloudfoundry via CLI

gregorw — Fri, 29 Oct 2021 19:23:39 GMT

Have you tried to leave out the memory parameter?

Re: Create HANA DB on Cloudfoundry via CLI

MarcoHöpner — Sat, 30 Oct 2021 11:03:41 GMT

Hi,

yes always the same error.

cf -v create-service hana-cloud-trial hana mh_hana_db -c '{"SystemPassword":"tUller2013","SourceIP":"0.0.0.0/0","dpserver":"true","vcpu":"2","storage":"120"}'

If i take a look into the verbose output i found the following information.

"service_instance": {
"create": {
"parameters": {
"$schema": "http://json-schema.org/draft-04/schema#",
"additionalProperties": false,
"definitions": {
"extensionservice": {
"properties": {
"enabled": {
"type": "boolean"
},
...........

"memory": {
"description": "HANA memory size (RAM) in GB",
"format": "int64",
"maximum": 45,
"minimum": 30,
"type": "integer"
},

.....

at the end i found the following POST Request.

REQUEST: [2021-10-30T12:47:38+02:00]
POST /v2/service_instances?accepts_incomplete=true HTTP/1.1
Host: api.cf.eu10.hana.ondemand.com
Accept: application/json
Authorization: [PRIVATE DATA HIDDEN]
Content-Type: application/json
User-Agent: cf/7.3.0+645c3ce6a.2021-08-16 (go1.16.6; amd64 linux)
{
"name": "mh_hana_db",
"parameters": {
"SourceIP": "0.0.0.0/0",
"SystemPassword": "[PRIVATE DATA HIDDEN]",
"dpserver": "true",
"storage": "120",
"vcpu": "2"
},
"service_plan_guid": "xxxxxxxxxxxxxxxxxxxx",
"space_guid": "xxxxxxxxxxxxxxxxxxxxxxxxx"
}

RESPONSE: [2021-10-30T12:47:40+02:00]
HTTP/1.1 502 Bad Gateway
Content-Length: 290
Content-Type: application/json;charset=utf-8
Date: Sat, 30 Oct 2021 10:47:40 GMT
Server: nginx
Strict-Transport-Security: max-age=31536000; includeSubDomains; preload;
X-B3-Spanid: 9ddd652b2c93ed63
X-B3-Traceid: 9ddd652b2c93ed63
X-Content-Type-Options: nosniff
X-Ratelimit-Limit: 40000
X-Ratelimit-Remaining: 39999
X-Ratelimit-Reset: 1635594309
X-Vcap-Request-Id: 5a4b738e-bc73-48e7-6628-c8f88e484cbb::84682fa3-21a5-4c25-ba0c-6bc9526edae2
{
"code": 10001,
"description": "Service broker error: Service broker hana-cloud-trial failed with: Invalid Parameter (memory): Required for HANA [ref 20DtCoagW3DnXvPKq9hJfZZKqQw]",
"error_code": "CF-ServiceBrokerBadResponse",
"http": {
"method": "PUT",
"status": 422

.......

I'm interesting in:

Are you able to deploy a hana db with my command?

Which commandline are you using to deploy a service like Hana?

How can i take a deeper look into the service broker to verify which parameters are supported/used?

Is the Service Broker "hana-cloud-trial" the correct Broker? I'm not sure because of the http 502 Response Error Code.

Best Regards

Marco

Re: Create HANA DB on Cloudfoundry via CLI

dvankempen — Mon, 01 Nov 2021 10:40:18 GMT

Hi Marco,

SAP HANA Cloud is available on the US for the trial, cf

https://answers.sap.com/questions/13508076/sap-hana-cloud-trial-cf-eu10-no-longer-available.html?childToView=13509244

You can create an instance using, for example, command

cf create-service hana-cloud-trial hana my_hana_db -c '{ "data": {"memory": 30, "systempassword": "Initial1"}}'

For production, the memory increments in 30 GB in AWS and GCP and 32 for Azure, cf

Create an SAP HANA Database Instance Using the CLI

Re: Create HANA DB on Cloudfoundry via CLI

MarcoHöpner — Tue, 02 Nov 2021 12:00:12 GMT

Hi Denys,

it works now.

Thank you very much.

Is there a place/blog/URL to keep informed about such changes?

Best Regards

Marco

Re: Create HANA DB on Cloudfoundry via CLI

dvankempen — Tue, 02 Nov 2021 16:23:02 GMT

Not yet, will cook something up. To be continued ...

Re: Create HANA DB on Cloudfoundry via CLI

Dan_vL — Wed, 25 Oct 2023 18:01:45 GMT

The following tutorial demonstrates executing various administrative tasks such as start/stop/create/update/upgrade of an SAP HANA Cloud instance using the BTP and CF CLIs.

Executing SAP HANA Cloud Tasks from the Command Line