CF-ServicePlanNotUpdateable error ...

[gregorw]

Hello,

I am creating my first CAP application with postgreSQL as backend database. I followed all steps as explained in the following blog.

https://blogs.sap.com/2020/11/30/run-and-deploy-cap-with-postgresql-on-sap-cloud-platform-cloud-foun...

While deploying the mtar file, I am getting below error. "Test-postgreSQL" is the name of the pg instance.

Detected new MTA version: "1.0.0"
Processing service "Test-postgreSQL"...
Setting service "Test-postgreSQL" parameters from "pg-options.json"
Service operation failed: Controller operation failed: 400 Updating service "Test-postgreSQL" failed: Bad Request: CF-ServicePlanNotUpdateable(110004): The service does not support changing plans.

Appreciate your help...

[gregorw]

Please try if the deployment pg-beershop works. If yes try to adopt your project with according to it. If you still fail please provide a public accessible Git repository.

[cvasabat]

Thank you Gregor. I corrected the service plan in the resource module comparing the pg-beershop works.

Now, I have another issue - I completed the build and it generated the mtar file. While deploying, the service is crashing. I specified the engine vesion as well. "engines": { "node": "^16.15.0" },Error while deploing :-Execution of task "deploy_to_postgresql" on application "demoCAP-db-deployer" failed.
Download the application logs via the dmol command and check them for more information.
A step of the process has failed. Retrying it may solve the issue.
I published the code on Giit. https://github.com/phani0906/demoCAP/commit/9a72c95a9da58f37fe7e1cf88becc7660bdbd99cCan you please look into it what did I miss? Thanks again...

[gregorw]

Have you checked what node engine version I'm using in pg-beershop?

[cvasabat]

I downgraded node version as in pg-beershop, and the srv is running now. But the deployer module is crashing next. with the same error.

Error while deploing :-Execution of task "deploy_to_postgresql" on application "demoCAP-db-deployer" failed.

Do I have to mention the version for this too somewhere?

[cvasabat]

Gregor, I found the following error in the deployer log. Do I have to maintain login credentials somewhere. I thought it would read from environment variables.

#2.0#2022 09 02 03:31:25.855#Z#DEBUG#com.sap.cloud.lm.sl.xs2.550300f1-2a6f-11ed-b61a-eeee0a9fcdb5.demoCAP-db-deployer.executeTaskTask#######org.cloudfoundry.multiapps.controller.persistence.services.ProcessLogger########flowable-async-job-executor-thread-11432###[PollExecuteTaskStatusExecution] [demoCAP-db-deployer] c021e6d0-2e9e-4177-87ce-9063dc98492c [Fri Sep 02 03:31:23 UTC 2022] TypeError: Cannot read property 'username' of undefined (STDERR, APP/TASK/deploy_to_postgresql)#

[cvasabat]

Sorry Gregor for posting too many messages. I ran the command npx cds-dbm deploy, and got the following error messages...

TypeError: Cannot read properties of undefined (reading 'username')

at getCredentialsForClient (/home/user/projects/demoCAP/node_modules/cds-dbm/dist/adapter/PostgresAdapter.js:13:28)

at PostgresAdapter._synchronizeCloneDatabase (/home/user/projects/demoCAP/node_modules/cds-dbm/dist/adapter/PostgresAdapter.js:127:40)

at PostgresAdapter.deploy (/home/user/projects/demoCAP/node_modules/cds-dbm/dist/adapter/BaseAdapter.js:131:20)

at async Object.exports.handler (/home/user/projects/demoCAP/node_modules/cds-dbm/dist/cli/deploy.js:38:9)

Thanks for helping me on this...

[jojipams]

When I deploy postgreSQL sample project, I am getting the following error. Could you please help me to solve this issue.

#2.0#2023 03 29 04:45:48.136#Z#DEBUG#com.sap.cloud.lm.sl.xs2.5b928c0a-cdec-11ed-aef0-eeee0a8f79d8.devtoberfest-db-deployer.stageAppTask#######org.cloudfoundry.multiapps.controller.persistence.services.ProcessLogger########flowable-async-job-executor-thread-3037###[PollStageAppStatusExecution] [devtoberfest-db-deployer] 4785dd26-8d6d-4bea-b93b-e9624bcd57a1 [Wed Mar 29 04:45:44 UTC 2023] **ERROR** Unsupported stack (STDOUT, STG)#

[gregorw]

Is the deployer bound to the database service instance?

[cvasabat]

mta.txtyes, we did I guess. Please see the yaml file attached.

mta.txt