generator-jhipster: JHipster gae error

Hi,

I cannot make Jhipster gae work. It gives me some errors, but I wonder if everybody is having the same problem when using GAE. (I tried with a clean Jhipster project)

Overview of the issue

D:\JHipster\testheroku660>jhipster gae INFO! Using JHipster version installed locally in current project’s node_modules INFO! Executing jhipster:gae INFO! Options: from-cli: true Welcome to Google App Engine Generator ? Google Cloud Project ID kk2probandosdk This project already has an App Engine location set, using location “us-east4” ? Google App Engine Service Name testheroku-660 ? Google App Engine Instance Class F2 - 1.2GHz, 512MB, Automatic Scaling Instance Class “F2” can only be automatically scaled. Setting scaling type to automatic. ? How many instances minimum ? 1 ? How many instances max (0 for unlimited) ? 0 ? Use a Cloud SQL instance (Y/N) ? Y ERROR: (gcloud.sql.instances.list) Name expected [:(settings.userLabels:alias=labels:label=LABELS) table(name,databaseVersion,firstof(gceZone,region):label=LOCATION,settings.tier,ip_addresses.filter(“type:PRIMARY”).map(1).extract(ip_address).flatten().yesno(no=“-”):label=PRIMARY_ADDRESS,ip_addresses.filter(“type:PRIVATE”).map(1).extract(ip_address).flatten().yesno(no=“-”):label=PRIVATE_ADDRESS,state:label=STATUS) HERE ‘valueseparator=:’]. × ERROR: (gcloud.sql.instances.list) Name expected [:(settings.userLabels:alias=labels:label=LABELS) table(name,databaseVersion,firstof(gceZone,region):label=LOCATION,settings.tier,ip_addresses.filter(“type:PRIMARY”).map(1).extract(ip_address).flatten().yesno(no=“-”):label=PRIMARY_ADDRESS,ip_addresses.filter(“type:PRIVATE”).map(1).extract(ip_address).flatten().yesno(no=“-”):label=PRIVATE_ADDRESS,state:label=STATUS) HERE ‘valueseparator=:’].

? Google Cloud SQL Instance Name New Cloud SQL Instance ? Google Cloud SQL Instance Name testheroku660 ? Google Cloud SQL User Name root ? Google Cloud SQL Password [hidden]

Creating New Cloud SQL Instance

… Running: gcloud sql instances create “testheroku660” --region=‘us-east4’ --project=kk2probandosdk --database-version=“POSTGRES_9_6” --tier=“db-g1-small” × ERROR: (gcloud.sql.instances.create) HTTPError 400: Invalid request: Invalid value for region: ‘us-east4’.

INFO! Congratulations, JHipster execution is complete!

Motivation for or Use Case

I’m not sure if it is a bug or if it is a problem in my config, but it will be nice if anyone can test it and see if it works for them.

Reproduce the error

It is above

Related issues

Suggest a Fix

JHipster Version(s)

v6.6.0 with gradle

JHipster configuration

{ “generator-jhipster”: { “promptValues”: { “packageName”: “test.heroku.v660” }, “jhipsterVersion”: “6.6.0”, “applicationType”: “monolith”, “baseName”: “testheroku660”, “packageName”: “test.heroku.v660”, “packageFolder”: “test/heroku/v660”, “serverPort”: “8080”, “authenticationType”: “jwt”, “cacheProvider”: “ehcache”, “enableHibernateCache”: true, “websocket”: false, “databaseType”: “sql”, “devDatabaseType”: “h2Disk”, “prodDatabaseType”: “postgresql”, “searchEngine”: false, “messageBroker”: false, “serviceDiscoveryType”: false, “buildTool”: “gradle”, “enableSwaggerCodegen”: false, “jwtSecretKey”: “NTQxZmEzYTk1MTlmZmE3Njk4YjQzMDk2NDViNzAzMWRlZGNkZjRmMzQzOGFjNmY5NTExZTcxOTFiMjMxZDBjMDA2ZTQ3OGQwNmQ2MWFlNjUwN2YwNDJmMjI4OGE0MTNiOTM4MTdmY2EzOGJkZDVlYjE2ZjgyNjZmNzkxYzdhOTc=”, “embeddableLaunchScript”: false, “useSass”: true, “clientPackageManager”: “npm”, “clientFramework”: “angularX”, “clientTheme”: “none”, “clientThemeVariant”: “”, “creationTimestamp”: 1580224509059, “testFrameworks”: [], “jhiPrefix”: “jhi”, “entitySuffix”: “”, “dtoSuffix”: “DTO”, “otherModules”: [], “enableTranslation”: false, “blueprints”: [], “herokuAppName”: “testheroku-660”, “herokuDeployType”: “git”, “gcpProjectId”: “kk2probandosdk”, “gcpCloudSqlInstanceName”: “”, “gcpCloudSqlUserName”: “root”, “gcpCloudSqlDatabaseName”: “testheroku660”, “gaeServiceName”: “testheroku-660”, “gaeLocation”: “us-east4”, “gaeInstanceClass”: “F2”, “gaeScalingType”: “automatic”, “gaeMinInstances”: “1”, “gaeMaxInstances”: “0”, “gaeCloudSQLInstanceNeeded”: “Y” } }

Entity configuration(s) entityName.json files generated in the .jhipster directory

None. It fails with a clean project

Browsers and Operating System

• Checking this box is mandatory (this is just to show you read everything)