search

sap-tutorials / Issues

Creative Commons Attribution 4.0 International
7 stars 4 forks source link

Deploy a CAP Business Application to SAP Business Technology Platform #425

Closed Askullu closed 2 years ago

Askullu commented 3 years ago

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

Issue: The deployed application my-bookshop-srv is not able to load the data

Description: In step 3.3 After we deploy the application, it is able to launch the application but not able to find the table i.e if we click on Authors getting the "Internal server error" image

image

Logs: C:\Users\C5309305\my-bookshop>cf logs my-bookshop-srv --recent Retrieving logs for app my-bookshop-srv in org 4997ea4dtrial / space dev as akanksha.sherrie.kullu@sap.com...

2021-06-11T15:02:02.84+0530 [API/122] OUT Created app with guid 42c315a7-040d-4c69-8772-04605c103c8b 2021-06-11T15:02:05.42+0530 [API/82] OUT Uploading bits for app with guid 42c315a7-040d-4c69-8772-04605c103c8b 2021-06-11T15:02:12.27+0530 [API/71] OUT Creating build for app with guid 42c315a7-040d-4c69-8772-04605c103c8b 2021-06-11T15:02:12.55+0530 [API/71] OUT Updated app with guid 42c315a7-040d-4c69-8772-04605c103c8b ({"state"=>"STARTED"}) 2021-06-11T15:02:12.80+0530 [STG/0] OUT Downloading nodejs_buildpack... 2021-06-11T15:02:12.83+0530 [STG/0] OUT Downloaded nodejs_buildpack 2021-06-11T15:02:12.83+0530 [STG/0] OUT Cell d52c9115-37a6-473b-847d-4f8b095bd6a5 creating container for instance 9339efe8-82dc-4e38-89ae-be14c2027f8e 2021-06-11T15:02:14.47+0530 [STG/0] OUT Cell d52c9115-37a6-473b-847d-4f8b095bd6a5 successfully created container for instance 9339efe8-82dc-4e38-89ae-be14c2027f8e 2021-06-11T15:02:14.64+0530 [STG/0] OUT Downloading app package... 2021-06-11T15:02:14.69+0530 [STG/0] OUT Downloaded app package (10K) 2021-06-11T15:02:14.95+0530 [STG/0] OUT -----> Nodejs Buildpack version 1.7.48 2021-06-11T15:02:14.96+0530 [STG/0] OUT -----> Installing binaries 2021-06-11T15:02:14.96+0530 [STG/0] OUT engines.node (package.json): >=12 2021-06-11T15:02:14.96+0530 [STG/0] OUT engines.npm (package.json): unspecified (use default) 2021-06-11T15:02:14.96+0530 [STG/0] OUT WARNING Dangerous semver range (>) in engines.node. See: http://docs.cloudfoundry.org/buildpacks/node/node-tips.html 2021-06-11T15:02:14.96+0530 [STG/0] OUT -----> Installing node 15.14.0 2021-06-11T15:02:14.96+0530 [STG/0] OUT Copy [/tmp/buildpacks/55e5312e51b27a879c931648ff7864f2/dependencies/10bb57d3321ba474ae27bf5e6e8b4b6c/node_15.14.0_linux_x64_cflinuxfs3_306ae27c.tgz] 2021-06-11T15:02:15.20+0530 [STG/0] OUT WARNING node 15.x.x will no longer be available in new buildpacks released after 2021-06-01. 2021-06-11T15:02:15.20+0530 [STG/0] OUT See: https://github.com/nodejs/Release 2021-06-11T15:02:17.28+0530 [STG/0] OUT Using default npm version: 7.7.6 2021-06-11T15:02:17.28+0530 [STG/0] OUT -----> Installing yarn 1.22.10 2021-06-11T15:02:17.28+0530 [STG/0] OUT Copy [/tmp/buildpacks/55e5312e51b27a879c931648ff7864f2/dependencies/b7482b661544755fef03e2ceeb19057a/yarn_1.22.10_linux_noarch_any-stack_0057c1c9.tgz] 2021-06-11T15:02:17.78+0530 [STG/0] OUT Installed yarn 1.22.10 2021-06-11T15:02:17.78+0530 [STG/0] OUT -----> Creating runtime environment 2021-06-11T15:02:17.78+0530 [STG/0] OUT PRO TIP: It is recommended to vendor the application's Node.js dependencies 2021-06-11T15:02:17.78+0530 [STG/0] OUT Visit http://docs.cloudfoundry.org/buildpacks/node/index.html#vendoring 2021-06-11T15:02:17.78+0530 [STG/0] OUT NODE_ENV=production 2021-06-11T15:02:17.78+0530 [STG/0] OUT NODE_HOME=/tmp/contents590787799/deps/0/node 2021-06-11T15:02:17.78+0530 [STG/0] OUT NODE_MODULES_CACHE=true 2021-06-11T15:02:17.78+0530 [STG/0] OUT NODE_VERBOSE=false 2021-06-11T15:02:17.78+0530 [STG/0] OUT NPM_CONFIG_LOGLEVEL=error 2021-06-11T15:02:17.78+0530 [STG/0] OUT NPM_CONFIG_PRODUCTION=true 2021-06-11T15:02:17.78+0530 [STG/0] OUT -----> Building dependencies 2021-06-11T15:02:17.78+0530 [STG/0] OUT Installing node modules (package.json) 2021-06-11T15:02:33.72+0530 [STG/0] OUT added 184 packages, and audited 185 packages in 16s 2021-06-11T15:02:33.72+0530 [STG/0] OUT 31 packages are looking for funding 2021-06-11T15:02:33.72+0530 [STG/0] OUT run npm fund for details 2021-06-11T15:02:33.72+0530 [STG/0] OUT found 0 vulnerabilities 2021-06-11T15:02:33.72+0530 [STG/0] OUT npm notice 2021-06-11T15:02:33.72+0530 [STG/0] OUT npm notice New minor version of npm available! 7.7.6 -> 7.17.0 2021-06-11T15:02:33.72+0530 [STG/0] OUT npm notice Changelog: https://github.com/npm/cli/releases/tag/v7.17.0 2021-06-11T15:02:33.72+0530 [STG/0] OUT npm notice Run npm install -g npm@7.17.0 to update! 2021-06-11T15:02:33.72+0530 [STG/0] OUT npm notice 2021-06-11T15:02:34.43+0530 [STG/0] OUT WARNING Unmet dependencies don't fail npm install but may cause runtime issues 2021-06-11T15:02:34.43+0530 [STG/0] OUT See: https://github.com/npm/npm/issues/7494 2021-06-11T15:02:34.46+0530 [STG/0] OUT Contrast Security no credentials found. Will not write environment files. 2021-06-11T15:02:53.98+0530 [STG/0] OUT Exit status 0 2021-06-11T15:02:53.98+0530 [STG/0] OUT Uploading droplet, build artifacts cache... 2021-06-11T15:02:53.98+0530 [STG/0] OUT Uploading droplet... 2021-06-11T15:02:53.98+0530 [STG/0] OUT Uploading build artifacts cache... 2021-06-11T15:02:54.78+0530 [STG/0] OUT Uploaded build artifacts cache (51M) 2021-06-11T15:02:55.09+0530 [API/134] OUT Creating droplet for app with guid 42c315a7-040d-4c69-8772-04605c103c8b 2021-06-11T15:02:58.29+0530 [STG/0] OUT Uploaded droplet (82M) 2021-06-11T15:02:58.30+0530 [STG/0] OUT Uploading complete 2021-06-11T15:02:58.84+0530 [STG/0] OUT Cell d52c9115-37a6-473b-847d-4f8b095bd6a5 stopping instance 9339efe8-82dc-4e38-89ae-be14c2027f8e 2021-06-11T15:02:58.84+0530 [STG/0] OUT Cell d52c9115-37a6-473b-847d-4f8b095bd6a5 destroying container for instance 9339efe8-82dc-4e38-89ae-be14c2027f8e 2021-06-11T15:02:59.27+0530 [CELL/0] OUT Cell e01b20da-0266-4703-a307-ece2d99286d3 creating container for instance 632cc013-3593-493b-791a-6385 2021-06-11T15:03:00.75+0530 [STG/0] OUT Cell d52c9115-37a6-473b-847d-4f8b095bd6a5 successfully destroyed container for instance 9339efe8-82dc-4e38-89ae-be14c2027f8e 2021-06-11T15:03:01.03+0530 [CELL/0] OUT Cell e01b20da-0266-4703-a307-ece2d99286d3 successfully created container for instance 632cc013-3593-493b-791a-6385 2021-06-11T15:03:01.18+0530 [CELL/0] OUT Downloading droplet... 2021-06-11T15:03:05.91+0530 [CELL/0] OUT Downloaded droplet (82M) 2021-06-11T15:03:05.91+0530 [CELL/0] OUT Starting health monitoring of container 2021-06-11T15:03:07.01+0530 [APP/PROC/WEB/0] OUT > my-bookshop@1.0.0 start 2021-06-11T15:03:07.01+0530 [APP/PROC/WEB/0] OUT > cds run 2021-06-11T15:03:07.51+0530 [APP/PROC/WEB/0] OUT [cds] - model loaded from 1 file(s): 2021-06-11T15:03:07.51+0530 [APP/PROC/WEB/0] OUT 2021-06-11T15:03:07.51+0530 [APP/PROC/WEB/0] OUT ./srv/csn.json 2021-06-11T15:03:07.51+0530 [APP/PROC/WEB/0] OUT 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT [cds] - connect to db > hana { 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT host: 'zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT port: '23803', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT driver: 'com.sap.db.jdbc.Driver', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT url: 'jdbc:sap://zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:23803?encrypt=true&validateCertificate=true&currentschema=USR_7ED1ZLGZEK48WOLHFYGVR6V02', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT schema: 'USR_7ED1ZLGZEK48WOLHFYGVR6V02', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT user: 'USR_7ED1ZLGZEK48WOLHFYGVR6V02', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT password: '...', 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT certificate: '...' 2021-06-11T15:03:08.30+0530 [APP/PROC/WEB/0] OUT } 2021-06-11T15:03:08.46+0530 [APP/PROC/WEB/0] OUT [cds] - serving CatalogService { at: '/catalog', impl: './srv/cat-service.js' } 2021-06-11T15:03:08.47+0530 [APP/PROC/WEB/0] OUT [cds] - launched in: 1.160s 2021-06-11T15:03:08.47+0530 [APP/PROC/WEB/0] OUT [cds] - server listening on { url: 'http://localhost:8080' } 2021-06-11T15:03:10.32+0530 [CELL/0] OUT Container became healthy 2021-06-11T15:03:40.44+0530 [RTR/37] OUT my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com - [2021-06-11T09:33:40.322182777Z] "GET / HTTP/1.1" 200 0 2404 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" "-" "10.32.3.21:61163" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"6b128674-bbb8-4968-5032-7d3988eb27df" response_time:0.121685 gorouter_time:0.004509 app_id:"42c315a7-040d-4c69-8772-04605c103c8b" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"08d0479f-4623-4494-b089-48965ba5680f-60C32DF3-4909A2" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"4a9cdd7143200b5f" x_b3_spanid:"4a9cdd7143200b5f" x_b3_parentspanid:"-" b3:"4a9cdd7143200b5f-4a9cdd7143200b5f" 2021-06-11T15:03:40.44+0530 [RTR/37] OUT 2021-06-11T15:03:40.98+0530 [RTR/19] OUT my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com - [2021-06-11T09:33:40.958642844Z] "GET /favicon.ico HTTP/1.1" 200 0 15086 "https://my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" "-" "10.32.3.21:61163" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"f938f3dd-aa82-4bd0-78fa-3fa5ef32f7b8" response_time:0.023358 gorouter_time:0.000093 app_id:"42c315a7-040d-4c69-8772-04605c103c8b" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"08d0479f-4623-4494-b089-48965ba5680f-60C32DF4-490AD3" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"26fdc4fcdf379dd0" x_b3_spanid:"26fdc4fcdf379dd0" x_b3_parentspanid:"-" b3:"26fdc4fcdf379dd0-26fdc4fcdf379dd0" 2021-06-11T15:03:40.98+0530 [RTR/19] OUT 2021-06-11T15:03:52.81+0530 [APP/PROC/WEB/0] OUT [cds] - GET /catalog/Authors?$top=11 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT [hana] - effective pool configuration: { 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT min: 0, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT max: 100, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT testOnBorrow: true, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT acquireTimeoutMillis: 1000, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT softIdleTimeoutMillis: 30000, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT idleTimeoutMillis: 30000, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT evictionRunIntervalMillis: 60000, 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT numTestsPerEvictionRun: 34 2021-06-11T15:03:52.83+0530 [APP/PROC/WEB/0] OUT } 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR [cds] - Error: invalid table name: Could not find table/view LOCALIZED_CATALOGSERVICE_AUTHORS in schema USR_7ED1ZLGZEK48WOLHFYGVR6V02: line 1 col 40 (at pos 39) 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at Socket. (/home/vcap/deps/0/node_modules/@sap/hana-client/lib/index.js:52:13) 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at Socket.emit (node:events:369:20) 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at addChunk (node:internal/streams/readable:313:12)
2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at readableAddChunk (node:internal/streams/readable:288:9) 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at Socket.Readable.push (node:internal/streams/readable:227:10) 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at Pipe.onStreamRead (node:internal/stream_base_commons:190:23) 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR at Pipe.callbackTrampoline (node:internal/async_hooks:132:14) { 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR code: 259, 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR sqlState: 'HY000', 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR query: 'SELECT ID AS "ID", name AS "name" FROM localized_CatalogService_Authors ALIAS_1 ORDER BY ID ASC LIMIT 11', 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR id: '1143733', 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR timestamp: 1623404032959 2021-06-11T15:03:52.96+0530 [APP/PROC/WEB/0] ERR } 2021-06-11T15:03:52.96+0530 [RTR/46] OUT my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com - [2021-06-11T09:33:52.788883871Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 500 0 162 "https://my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" "-" "10.32.3.21:61163" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"2c9f5946-3017-4116-5dce-26faf21f5daa" response_time:0.177598 gorouter_time:0.000202 app_id:"42c315a7-040d-4c69-8772-04605c103c8b" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"08d0479f-4623-4494-b089-48965ba5680f-60C32E00-491D07" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"db364ceae6fc63c2" x_b3_spanid:"db364ceae6fc63c2" x_b3_parentspanid:"-" b3:"db364ceae6fc63c2-db364ceae6fc63c2" 2021-06-11T15:03:52.96+0530 [RTR/46] OUT 2021-06-11T15:03:59.51+0530 [APP/PROC/WEB/0] OUT [cds] - GET /catalog/Books?$top=11 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR [cds] - Error: invalid table name: Could not find table/view LOCALIZED_CATALOGSERVICE_BOOKS in schema USR_7ED1ZLGZEK48WOLHFYGVR6V02: line 1 col 86 (at pos 85) 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at Socket. (/home/vcap/deps/0/node_modules/@sap/hana-client/lib/index.js:52:13) 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at Socket.emit (node:events:369:20) 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at addChunk (node:internal/streams/readable:313:12)
2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at readableAddChunk (node:internal/streams/readable:288:9) 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at Socket.Readable.push (node:internal/streams/readable:227:10) 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at Pipe.onStreamRead (node:internal/stream_base_commons:190:23) 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR at Pipe.callbackTrampoline (node:internal/async_hooks:132:14) { 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR code: 259, 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR sqlState: 'HY000', 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR query: 'SELECT ID AS "ID", title AS "title", author_ID AS "author_ID", stock AS "stock" FROM localized_CatalogService_Books ALIAS_1 ORDER BY ID ASC LIMIT 11', 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR id: '1143733', 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR timestamp: 1623404039520 2021-06-11T15:03:59.52+0530 [APP/PROC/WEB/0] ERR } 2021-06-11T15:03:59.52+0530 [RTR/56] OUT my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com - [2021-06-11T09:33:59.431118727Z] "GET /catalog/Books?$top=11 HTTP/1.1" 500 0 162 "https://my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" "-" "10.32.3.21:61163" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"b8bd887e-0f8e-4fe8-63b3-97ad84e43e13" response_time:0.091179 gorouter_time:0.059061 app_id:"42c315a7-040d-4c69-8772-04605c103c8b" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"08d0479f-4623-4494-b089-48965ba5680f-60C32E07-4927B4" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"6779b313aedbc32d" x_b3_spanid:"6779b313aedbc32d" x_b3_parentspanid:"-" b3:"6779b313aedbc32d-6779b313aedbc32d" 2021-06-11T15:03:59.52+0530 [RTR/56] OUT 2021-06-11T15:04:19.41+0530 [APP/PROC/WEB/0] OUT [cds] - GET /catalog/Authors?$top=11 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR [cds] - Error: invalid table name: Could not find table/view LOCALIZED_CATALOGSERVICE_AUTHORS in schema USR_7ED1ZLGZEK48WOLHFYGVR6V02: line 1 col 40 (at pos 39) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at Socket. (/home/vcap/deps/0/node_modules/@sap/hana-client/lib/index.js:52:13) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at Socket.emit (node:events:369:20) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at addChunk (node:internal/streams/readable:313:12) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at readableAddChunk (node:internal/streams/readable:288:9) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at Socket.Readable.push (node:internal/streams/readable:227:10) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at Pipe.onStreamRead (node:internal/stream_base_commons:190:23) 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR at Pipe.callbackTrampoline (node:internal/async_hooks:132:14) { 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR code: 259, 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR sqlState: 'HY000', 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR query: 'SELECT ID AS "ID", name AS "name" FROM localized_CatalogService_Authors ALIAS_1 ORDER BY ID ASC LIMIT 11', 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR id: '1143733', 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR timestamp: 1623404059421 2021-06-11T15:04:19.42+0530 [APP/PROC/WEB/0] ERR } 2021-06-11T15:04:19.42+0530 [RTR/9] OUT my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com - [2021-06-11T09:34:19.400585896Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 500 0 162 "https://my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" "-" "10.32.3.21:61163" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"2104a858-90a8-4460-7d4d-5bb02ff8f19b" response_time:0.023073 gorouter_time:0.000065 app_id:"42c315a7-040d-4c69-8772-04605c103c8b" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"08d0479f-4623-4494-b089-48965ba5680f-60C32E1B-49475B" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"4d354d03a82e6ef2" x_b3_spanid:"4d354d03a82e6ef2" x_b3_parentspanid:"-" b3:"4d354d03a82e6ef2-4d354d03a82e6ef2" 2021-06-11T15:04:19.42+0530 [RTR/9] OUT 2021-06-11T15:04:50.93+0530 [APP/PROC/WEB/0] OUT [cds] - GET /catalog/Authors?$top=11 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR [cds] - Error: invalid table name: Could not find table/view LOCALIZED_CATALOGSERVICE_AUTHORS in schema USR_7ED1ZLGZEK48WOLHFYGVR6V02: line 1 col 40 (at pos 39) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at Socket. (/home/vcap/deps/0/node_modules/@sap/hana-client/lib/index.js:52:13) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at Socket.emit (node:events:369:20) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at addChunk (node:internal/streams/readable:313:12) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at readableAddChunk (node:internal/streams/readable:288:9) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at Socket.Readable.push (node:internal/streams/readable:227:10) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at Pipe.onStreamRead (node:internal/stream_base_commons:190:23) 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR at Pipe.callbackTrampoline (node:internal/async_hooks:132:14) { 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR code: 259, 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR sqlState: 'HY000', 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR query: 'SELECT ID AS "ID", name AS "name" FROM localized_CatalogService_Authors ALIAS_1 ORDER BY ID ASC LIMIT 11', 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR id: '1143733', 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR timestamp: 1623404090945 2021-06-11T15:04:50.94+0530 [APP/PROC/WEB/0] ERR } 2021-06-11T15:04:50.94+0530 [RTR/12] OUT my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com - [2021-06-11T09:34:50.921408352Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 500 0 162 "https://my-bookshop-srv-happy-elephant-av.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" "-" "10.32.3.21:61163" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"4bd6a4a7-06ac-40fb-53b8-a0bae99953c7" response_time:0.025322 gorouter_time:0.000075 app_id:"42c315a7-040d-4c69-8772-04605c103c8b" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"08d0479f-4623-4494-b089-48965ba5680f-60C32E3A-4976D6" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"995f0325fb13e9bf" x_b3_spanid:"995f0325fb13e9bf" x_b3_parentspanid:"-" b3:"995f0325fb13e9bf-995f0325fb13e9bf" 2021-06-11T15:04:50.94+0530 [RTR/12] OUT

Labels: Landscape Labels: trail1, trail2 Scenario Label: SCPTest-banode Priority: High Sprint Label: SCPTest-2106A

iwonahahn commented 3 years ago

Hi @Askullu, as mentioned here it is not working anymore. I need to test it and will get back to you asap.

iwonahahn commented 3 years ago

Hi @Askullu,

We have updated the tutorial using SAP HANA Cloud service now. Please see the prereqs for SAP HANA Cloud service and updated steps (especially 3.1) in the tutorial.

Best regards, Iwona

Askullu commented 3 years ago

Hi @iwonahahn Still having issues getting the data displayed. image Logs C:\Users\C5309305\my-bookshop>cf logs my-bookshop-srv Retrieving logs for app my-bookshop-srv in org 266b2262trial / space dev as akanksha.sherrie.kullu@sap.com...

2021-07-10T00:23:38.02+0530 [STG/0] OUT added 193 packages from 176 contributors and audited 303 packages in 5.614s 2021-07-10T00:23:38.10+0530 [STG/0] OUT 33 packages are looking for funding 2021-07-10T00:23:38.10+0530 [STG/0] OUT run npm fund for details 2021-07-10T00:23:38.10+0530 [STG/0] OUT found 0 vulnerabilities 2021-07-10T00:23:38.76+0530 [STG/0] OUT WARNING Unmet dependencies don't fail npm install but may cause runtime issues 2021-07-10T00:23:38.76+0530 [STG/0] OUT See: https://github.com/npm/npm/issues/7494 2021-07-10T00:23:38.77+0530 [STG/0] OUT Contrast Security no credentials found. Will not write environment files. 2021-07-10T00:23:49.52+0530 [CELL/0] OUT Cell 691f3d6c-4298-4774-a585-726ea8a3dd7a destroying container for instance 52ba96b8-0044-41c4-5cc1-5aa9 2021-07-10T00:23:49.78+0530 [PROXY/0] OUT Exit status 137 2021-07-10T00:23:50.83+0530 [CELL/0] OUT Cell 691f3d6c-4298-4774-a585-726ea8a3dd7a successfully destroyed container for instance 52ba96b8-0044-41c4-5cc1-5aa9 2021-07-10T00:23:51.78+0530 [STG/0] OUT Exit status 0 2021-07-10T00:23:51.78+0530 [STG/0] OUT Uploading droplet, build artifacts cache... 2021-07-10T00:23:51.78+0530 [STG/0] OUT Uploading droplet... 2021-07-10T00:23:51.78+0530 [STG/0] OUT Uploading build artifacts cache... 2021-07-10T00:23:52.52+0530 [STG/0] OUT Uploaded build artifacts cache (57.8M) 2021-07-10T00:23:52.55+0530 [API/143] OUT Creating droplet for app with guid fce92d6d-fa02-424f-abb2-d8771ab96bf4 2021-07-10T00:23:56.71+0530 [STG/0] OUT Uploaded droplet (71.5M) 2021-07-10T00:23:56.72+0530 [STG/0] OUT Uploading complete 2021-07-10T00:23:56.86+0530 [STG/0] OUT Cell 5a7dc230-2ecf-479a-8bf0-30dd09dda7ac stopping instance 2c59f363-e604-4d93-8d59-e698fa104ff0 2021-07-10T00:23:56.86+0530 [STG/0] OUT Cell 5a7dc230-2ecf-479a-8bf0-30dd09dda7ac destroying container for instance 2c59f363-e604-4d93-8d59-e698fa104ff0 2021-07-10T00:23:57.22+0530 [CELL/0] OUT Cell a947a580-9226-491d-8034-de31667312c9 creating container for instance 19ec871a-2b44-4926-49e7-685f 2021-07-10T00:23:57.53+0530 [STG/0] OUT Cell 5a7dc230-2ecf-479a-8bf0-30dd09dda7ac successfully destroyed container for instance 2c59f363-e604-4d93-8d59-e698fa104ff0 2021-07-10T00:23:58.00+0530 [CELL/0] OUT Cell a947a580-9226-491d-8034-de31667312c9 successfully created container for instance 19ec871a-2b44-4926-49e7-685f 2021-07-10T00:23:58.39+0530 [CELL/0] OUT Downloading droplet... 2021-07-10T00:24:02.78+0530 [CELL/0] OUT Downloaded droplet (71.5M) 2021-07-10T00:24:02.78+0530 [CELL/0] OUT Starting health monitoring of container 2021-07-10T00:24:03.62+0530 [APP/PROC/WEB/0] OUT > my-bookshop@1.0.0 start /home/vcap/app 2021-07-10T00:24:03.62+0530 [APP/PROC/WEB/0] OUT > npx cds run 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT [cds] - model loaded from 1 file(s): 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT srv/csn.json 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT [cds] - connect to db > hana { host: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT '3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT port: '443', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT driver: 'com.sap.db.jdbc.Driver', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT url: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT 'jdbc:sap://3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com:443?encrypt=true&validateCertificate=true&currentschema=ECB8B9F8624A4FCA8968B108383F1368', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT schema: 'ECB8B9F8624A4FCA8968B108383F1368', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT hdi_user: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT 'ECB8B9F8624A4FCA8968B108383F1368_8UQWTEFNE2YMURGFA6CF2TXXO_DT', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT hdi_password: '...', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT user: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT 'ECB8B9F8624A4FCA8968B108383F1368_8UQWTEFNE2YMURGFA6CF2TXXO_RT', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT password: '...', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT certificate: '...' } 2021-07-10T00:24:04.75+0530 [APP/PROC/WEB/0] OUT [cds] - serving CatalogService { at: '/catalog', impl: 'srv/cat-service.js' } 2021-07-10T00:24:04.76+0530 [APP/PROC/WEB/0] OUT [cds] - launched in: 769.440ms 2021-07-10T00:24:04.76+0530 [APP/PROC/WEB/0] OUT [cds] - server listening on { url: 'http://localhost:8080' } 2021-07-10T00:24:06.03+0530 [CELL/0] OUT Container became healthy 2021-07-10T00:24:37.13+0530 [RTR/19] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:54:37.053307552Z] "GET / HTTP/1.1" 200 0 2955 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"6d386aaa-38a4-40ef-648f-0aaa0b65b974" response_time:0.080704 gorouter_time:0.000097 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"5187493b-23df-4861-b35f-c5cc583d6385-60E89B6B-26A2FD" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"a4524bde9266b8c9" x_b3_spanid:"a4524bde9266b8c9" x_b3_parentspanid:"-" b3:"a4524bde9266b8c9-a4524bde9266b8c9" 2021-07-10T00:24:37.13+0530 [RTR/19] OUT 2021-07-10T00:24:37.60+0530 [RTR/21] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:54:37.572149850Z] "GET /favicon.ico HTTP/1.1" 200 0 15086 "https://my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"f1abe508-83e5-4c14-4ad2-a37ad170de73" response_time:0.030294 gorouter_time:0.000051 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"5187493b-23df-4861-b35f-c5cc583d6385-60E89B6D-26A377" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"050240d8819acf9b" x_b3_spanid:"050240d8819acf9b" x_b3_parentspanid:"-" b3:"050240d8819acf9b-050240d8819acf9b" 2021-07-10T00:24:37.60+0530 [RTR/21] OUT 2021-07-10T00:24:40.73+0530 [APP/PROC/WEB/0] ERR [cds] - GET /catalog/Authors?$top=11 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR [cds.hana] - effective pool configuration: { min: 0, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR max: 100, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR testOnBorrow: true, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR acquireTimeoutMillis: 1000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR softIdleTimeoutMillis: 30000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR idleTimeoutMillis: 30000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR evictionRunIntervalMillis: 60000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR numTestsPerEvictionRun: 34 } 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR [cds.hana] - { Error: Could not establish connection for tenant "anonymous" due to error: Could not connect to any host: [ 3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ] 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at couldNotOpenConnectionError (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:115:13) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at tryConnect (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:35:17) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at /home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:42:9 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at TLSSocket.onerror (/home/vcap/deps/0/node_modules/hdb/lib/protocol/Connection.js:175:5) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at Object.onceWrapper (events.js:286:20) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at TLSSocket.emit (events.js:198:13) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at emitErrorNT (internal/streams/destroy.js:91:8) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at process._tickCallback (internal/process/next_tick.js:63:19) code: 'EHDBOPENCONN' } 2021-07-10T00:24:41.14+0530 [APP/PROC/WEB/0] ERR [cds.hana] - Could not establish connection for tenant "anonymous". Existing pool will be drained. 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR [cds] - { TimeoutError: Acquiring client from pool timed out. Please review your system setup, transaction handling, and pool configuration. 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at ResourceRequest._fireTimeout (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:62:17) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at Timeout.bound (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:8:15) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at ontimeout (timers.js:436:11) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at tryOnTimeout (timers.js:300:5) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at listOnTimeout (timers.js:263:5) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at Timer.processTimers (timers.js:223:10) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR name: 'TimeoutError', 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR statusCode: 503, 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR id: '1615004', 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR timestamp: 1625856882008 } 2021-07-10T00:24:42.06+0530 [RTR/23] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:54:40.654694145Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 503 0 160 "https://my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"e1f6d9e7-09a6-4420-4be6-2c609edb7af4" response_time:1.408848 gorouter_time:0.034545 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"5187493b-23df-4861-b35f-c5cc583d6385-60E89B70-26A569" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"cb5915366e5e8494" x_b3_spanid:"cb5915366e5e8494" x_b3_parentspanid:"-" b3:"cb5915366e5e8494-cb5915366e5e8494" 2021-07-10T00:24:42.06+0530 [RTR/23] OUT 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR [cds] - GET /catalog/Authors?$top=11 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR [cds.hana] - effective pool configuration: { min: 0, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR max: 100, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR testOnBorrow: true, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR acquireTimeoutMillis: 1000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR softIdleTimeoutMillis: 30000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR idleTimeoutMillis: 30000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR evictionRunIntervalMillis: 60000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR numTestsPerEvictionRun: 34 } 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR [cds.hana] - { Error: Could not establish connection for tenant "anonymous" due to error: Could not connect to any host: [ 3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ] 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at couldNotOpenConnectionError (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:115:13) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at tryConnect (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:35:17) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at /home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:42:9 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at TLSSocket.onerror (/home/vcap/deps/0/node_modules/hdb/lib/protocol/Connection.js:175:5) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at Object.onceWrapper (events.js:286:20) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at TLSSocket.emit (events.js:198:13) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at emitErrorNT (internal/streams/destroy.js:91:8) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at process._tickCallback (internal/process/next_tick.js:63:19) code: 'EHDBOPENCONN' } 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR [cds.hana] - Could not establish connection for tenant "anonymous". Existing pool will be drained. 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR [cds] - { TimeoutError: Acquiring client from pool timed out. Please review your system setup, transaction handling, and pool configuration. 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at ResourceRequest._fireTimeout (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:62:17) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at Timeout.bound (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:8:15) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at ontimeout (timers.js:436:11) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at tryOnTimeout (timers.js:300:5) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at listOnTimeout (timers.js:263:5) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at Timer.processTimers (timers.js:223:10) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR name: 'TimeoutError', 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR statusCode: 503, 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR id: '1615004', 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR timestamp: 1625857058498 } 2021-07-10T00:27:38.50+0530 [RTR/3] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:57:37.481601564Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 503 0 160 "https://my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"61ca4c9a-49d9-44a5-63f0-ab2ee6ae74a3" response_time:1.018562 gorouter_time:0.000121 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"cc8edb65-9eec-4d68-98fa-557f8273055c-60E89C20-2F96E5" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"48d3964a2b33c337" x_b3_spanid:"48d3964a2b33c337" x_b3_parentspanid:"-" b3:"48d3964a2b33c337-48d3964a2b33c337" 2021-07-10T00:27:38.50+0530 [RTR/3] OUT

Labels: Landscape Labels: trail1, trail2 Scenario Label: SCPTest-banode Priority: High Sprint Label: SCPTest-2107A

iwonahahn commented 3 years ago

Hi @Askullu,

Your SAP HANA Cloud instance is up and running? I will try the tutorial with the latest CAP release and will get back to you asap.

Best regards, Iwona

RufatGadirov commented 2 years ago

Hi @iwonahahn

we have the exact same issue...we first developed locally with hana-cli "@sap/hana-client": "^2.9.28", but after deployment to CF, we got that timeout error mentioned above. It seems that the latest hana-cli version used on CF is responsible and leads to these side effects. I could reproduce this issue locally when trying hana-cli "@sap/hana-client": "^2.10.13",...Do you have any idea how to solve this issue?

Message even during cds watch: hana] - Could not establish connection for tenant "anonymous". Existing pool will be drained. [cds] - TimeoutError: Acquiring client from pool timed out. Please review your system setup, transaction handling, and pool configuration.

Thank you.

BR Rufat

luizcarlospedrosogomes commented 2 years ago

I have the same problem

RufatGadirov commented 2 years ago

@luizcarlospedrosogomes I fixed it by removing the db.db in hana section from package.json in root file. It seems that with newer versions, it is deprecated. Thus, just remove it.

luizcarlospedrosogomes commented 2 years ago

@RufatGadirov tanks

but my package.json not have db.db in hana section

{
  "name": "sprolims_labserv_api",
  "version": "1.0.0",
  "description": "Generated by cds init",
  "repository": "<Add your repository here>",
  "license": "ISC",
  "files": [
    "db",
    "srv"
  ],
  "dependencies": {
    "@dynatrace/oneagent-sdk": "^1.4.1",
    "@sap/audit-logging": "^3.2.0",
    "@sap/cds": "^4.4",
    "@sap/cds-compiler": "^2.1.6",
    "@sap/cds-odata-v2-adapter-proxy": "^1.7.6",
    "@sap/hana-client": "^2.10.13",
    "@sap/hdbext": "^7.1.1",
    "@sap/logging": "^5.0.2",
    "@sap/xsenv": "^3.1.1",
    "@sap/xsjs": "^6",
    "@sap/xssec": "^2.2.5",
    "cors": "^2.8.5",
    "dotenv": "^8.2.0",
    "express": "^4",
    "express-basic-auth": "^1.2.0",
    "express-status-monitor": "^1.3.3",
    "helmet": "^3.21.3",
    "http-auth": "^3.2.4",
    "odata2openapi": "^1.3.2",
    "passport": "^0.4.1",
    "require-dir": "^1.2.0",
    "swagger-jsdoc": "^4.0.0",
    "swagger-ui-express": "^4.1.4"
  },
  "scripts": {
    "start": "cds run",
    "dev": "cds watch",
    "deploy": "cds deploy",
    "build": "cds build/all --clean",
    "build:cf": "mbt build -p=cf"
  },
  "cds": {
    "requires": {
      "auth": {
        "impl": "./srv/auth.js"
      },
      "db": {
        "kind": "hana"
      },
      "uaa": {
        "kind": "xsuaa"
      }
    },
    "hana": {
      "deploy-format": "hdbtable"
    },
    "build": {
      "target": ".",
      "tasks": [
        {
          "src": "db",
          "for": "hana",
          "options": {
            "model": [
              "db",
              "srv"
            ]
          }
        },
        {
          "src": "srv",
          "for": "node-cf",
          "options": {
            "model": [
              "db",
              "srv"
            ]
          }
        }
      ]
    }
  },
  "devDependencies": {
    "cds-swagger-ui-express": "^0.2.0",
    "nodemon": "^1.19.3",
    "sqlite3": "5.0.0"
  }
}

image image

luizcarlospedrosogomes commented 2 years ago

Do you have any idea how to solve this issue?

luizcarlospedrosogomes commented 2 years ago

workin after command 'npm install hdb' in path root of project​

maxstreifeneder commented 2 years ago

hey folks, any update on this? @NidhiMurkute @iwonahahn

iwonahahn commented 2 years ago

Hi @maxstreifeneder,

The tutorial works as it is, also tested twice by us and the testing team. Nevertheless, we plan to update the tutorial using the Cloud MTA Build Tool as described in the CAP documentation.

Best regards, Iwona

shishirp05 commented 8 months ago

Hi @iwonahahn Still having issues getting the data displayed. image Logs C:\Users\C5309305\my-bookshop>cf logs my-bookshop-srv Retrieving logs for app my-bookshop-srv in org 266b2262trial / space dev as akanksha.sherrie.kullu@sap.com...

2021-07-10T00:23:38.02+0530 [STG/0] OUT added 193 packages from 176 contributors and audited 303 packages in 5.614s 2021-07-10T00:23:38.10+0530 [STG/0] OUT 33 packages are looking for funding 2021-07-10T00:23:38.10+0530 [STG/0] OUT run npm fund for details 2021-07-10T00:23:38.10+0530 [STG/0] OUT found 0 vulnerabilities 2021-07-10T00:23:38.76+0530 [STG/0] OUT WARNING Unmet dependencies don't fail npm install but may cause runtime issues 2021-07-10T00:23:38.76+0530 [STG/0] OUT See: npm/npm#7494 2021-07-10T00:23:38.77+0530 [STG/0] OUT Contrast Security no credentials found. Will not write environment files. 2021-07-10T00:23:49.52+0530 [CELL/0] OUT Cell 691f3d6c-4298-4774-a585-726ea8a3dd7a destroying container for instance 52ba96b8-0044-41c4-5cc1-5aa9 2021-07-10T00:23:49.78+0530 [PROXY/0] OUT Exit status 137 2021-07-10T00:23:50.83+0530 [CELL/0] OUT Cell 691f3d6c-4298-4774-a585-726ea8a3dd7a successfully destroyed container for instance 52ba96b8-0044-41c4-5cc1-5aa9 2021-07-10T00:23:51.78+0530 [STG/0] OUT Exit status 0 2021-07-10T00:23:51.78+0530 [STG/0] OUT Uploading droplet, build artifacts cache... 2021-07-10T00:23:51.78+0530 [STG/0] OUT Uploading droplet... 2021-07-10T00:23:51.78+0530 [STG/0] OUT Uploading build artifacts cache... 2021-07-10T00:23:52.52+0530 [STG/0] OUT Uploaded build artifacts cache (57.8M) 2021-07-10T00:23:52.55+0530 [API/143] OUT Creating droplet for app with guid fce92d6d-fa02-424f-abb2-d8771ab96bf4 2021-07-10T00:23:56.71+0530 [STG/0] OUT Uploaded droplet (71.5M) 2021-07-10T00:23:56.72+0530 [STG/0] OUT Uploading complete 2021-07-10T00:23:56.86+0530 [STG/0] OUT Cell 5a7dc230-2ecf-479a-8bf0-30dd09dda7ac stopping instance 2c59f363-e604-4d93-8d59-e698fa104ff0 2021-07-10T00:23:56.86+0530 [STG/0] OUT Cell 5a7dc230-2ecf-479a-8bf0-30dd09dda7ac destroying container for instance 2c59f363-e604-4d93-8d59-e698fa104ff0 2021-07-10T00:23:57.22+0530 [CELL/0] OUT Cell a947a580-9226-491d-8034-de31667312c9 creating container for instance 19ec871a-2b44-4926-49e7-685f 2021-07-10T00:23:57.53+0530 [STG/0] OUT Cell 5a7dc230-2ecf-479a-8bf0-30dd09dda7ac successfully destroyed container for instance 2c59f363-e604-4d93-8d59-e698fa104ff0 2021-07-10T00:23:58.00+0530 [CELL/0] OUT Cell a947a580-9226-491d-8034-de31667312c9 successfully created container for instance 19ec871a-2b44-4926-49e7-685f 2021-07-10T00:23:58.39+0530 [CELL/0] OUT Downloading droplet... 2021-07-10T00:24:02.78+0530 [CELL/0] OUT Downloaded droplet (71.5M) 2021-07-10T00:24:02.78+0530 [CELL/0] OUT Starting health monitoring of container 2021-07-10T00:24:03.62+0530 [APP/PROC/WEB/0] OUT > my-bookshop@1.0.0 start /home/vcap/app 2021-07-10T00:24:03.62+0530 [APP/PROC/WEB/0] OUT > npx cds run 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT [cds] - model loaded from 1 file(s): 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT srv/csn.json 2021-07-10T00:24:04.20+0530 [APP/PROC/WEB/0] OUT 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT [cds] - connect to db > hana { host: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT '3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT port: '443', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT driver: 'com.sap.db.jdbc.Driver', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT url: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT 'jdbc:sap://3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com:443?encrypt=true&validateCertificate=true&currentschema=ECB8B9F8624A4FCA8968B108383F1368', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT schema: 'ECB8B9F8624A4FCA8968B108383F1368', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT hdi_user: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT 'ECB8B9F8624A4FCA8968B108383F1368_8UQWTEFNE2YMURGFA6CF2TXXO_DT', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT hdi_password: '...', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT user: 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT 'ECB8B9F8624A4FCA8968B108383F1368_8UQWTEFNE2YMURGFA6CF2TXXO_RT', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT password: '...', 2021-07-10T00:24:04.66+0530 [APP/PROC/WEB/0] OUT certificate: '...' } 2021-07-10T00:24:04.75+0530 [APP/PROC/WEB/0] OUT [cds] - serving CatalogService { at: '/catalog', impl: 'srv/cat-service.js' } 2021-07-10T00:24:04.76+0530 [APP/PROC/WEB/0] OUT [cds] - launched in: 769.440ms 2021-07-10T00:24:04.76+0530 [APP/PROC/WEB/0] OUT [cds] - server listening on { url: 'http://localhost:8080' } 2021-07-10T00:24:06.03+0530 [CELL/0] OUT Container became healthy 2021-07-10T00:24:37.13+0530 [RTR/19] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:54:37.053307552Z] "GET / HTTP/1.1" 200 0 2955 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"6d386aaa-38a4-40ef-648f-0aaa0b65b974" response_time:0.080704 gorouter_time:0.000097 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"5187493b-23df-4861-b35f-c5cc583d6385-60E89B6B-26A2FD" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"a4524bde9266b8c9" x_b3_spanid:"a4524bde9266b8c9" x_b3_parentspanid:"-" b3:"a4524bde9266b8c9-a4524bde9266b8c9" 2021-07-10T00:24:37.13+0530 [RTR/19] OUT 2021-07-10T00:24:37.60+0530 [RTR/21] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:54:37.572149850Z] "GET /favicon.ico HTTP/1.1" 200 0 15086 "https://my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"f1abe508-83e5-4c14-4ad2-a37ad170de73" response_time:0.030294 gorouter_time:0.000051 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"5187493b-23df-4861-b35f-c5cc583d6385-60E89B6D-26A377" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"050240d8819acf9b" x_b3_spanid:"050240d8819acf9b" x_b3_parentspanid:"-" b3:"050240d8819acf9b-050240d8819acf9b" 2021-07-10T00:24:37.60+0530 [RTR/21] OUT 2021-07-10T00:24:40.73+0530 [APP/PROC/WEB/0] ERR [cds] - GET /catalog/Authors?$top=11 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR [cds.hana] - effective pool configuration: { min: 0, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR max: 100, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR testOnBorrow: true, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR acquireTimeoutMillis: 1000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR softIdleTimeoutMillis: 30000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR idleTimeoutMillis: 30000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR evictionRunIntervalMillis: 60000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR numTestsPerEvictionRun: 34 } 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR [cds.hana] - { Error: Could not establish connection for tenant "anonymous" due to error: Could not connect to any host: [ 3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ] 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at couldNotOpenConnectionError (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:115:13) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at tryConnect (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:35:17) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at /home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:42:9 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at TLSSocket.onerror (/home/vcap/deps/0/node_modules/hdb/lib/protocol/Connection.js:175:5) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at Object.onceWrapper (events.js:286:20) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at TLSSocket.emit (events.js:198:13) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at emitErrorNT (internal/streams/destroy.js:91:8) 2021-07-10T00:24:41.11+0530 [APP/PROC/WEB/0] ERR at process._tickCallback (internal/process/next_tick.js:63:19) code: 'EHDBOPENCONN' } 2021-07-10T00:24:41.14+0530 [APP/PROC/WEB/0] ERR [cds.hana] - Could not establish connection for tenant "anonymous". Existing pool will be drained. 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR [cds] - { TimeoutError: Acquiring client from pool timed out. Please review your system setup, transaction handling, and pool configuration. 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at ResourceRequest._fireTimeout (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:62:17) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at Timeout.bound (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:8:15) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at ontimeout (timers.js:436:11) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at tryOnTimeout (timers.js:300:5) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at listOnTimeout (timers.js:263:5) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR at Timer.processTimers (timers.js:223:10) 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR name: 'TimeoutError', 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR statusCode: 503, 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR id: '1615004', 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-07-10T00:24:42.00+0530 [APP/PROC/WEB/0] ERR timestamp: 1625856882008 } 2021-07-10T00:24:42.06+0530 [RTR/23] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:54:40.654694145Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 503 0 160 "https://my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"e1f6d9e7-09a6-4420-4be6-2c609edb7af4" response_time:1.408848 gorouter_time:0.034545 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"5187493b-23df-4861-b35f-c5cc583d6385-60E89B70-26A569" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"cb5915366e5e8494" x_b3_spanid:"cb5915366e5e8494" x_b3_parentspanid:"-" b3:"cb5915366e5e8494-cb5915366e5e8494" 2021-07-10T00:24:42.06+0530 [RTR/23] OUT 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR [cds] - GET /catalog/Authors?$top=11 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR [cds.hana] - effective pool configuration: { min: 0, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR max: 100, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR testOnBorrow: true, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR acquireTimeoutMillis: 1000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR softIdleTimeoutMillis: 30000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR idleTimeoutMillis: 30000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR evictionRunIntervalMillis: 60000, 2021-07-10T00:27:37.49+0530 [APP/PROC/WEB/0] ERR numTestsPerEvictionRun: 34 } 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR [cds.hana] - { Error: Could not establish connection for tenant "anonymous" due to error: Could not connect to any host: [ 3c31055d-23d6-460c-a439-ca3c9bea5e8e.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ] 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at couldNotOpenConnectionError (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:115:13) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at tryConnect (/home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:35:17) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at /home/vcap/deps/0/node_modules/hdb/lib/protocol/ConnectionManager.js:42:9 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at TLSSocket.onerror (/home/vcap/deps/0/node_modules/hdb/lib/protocol/Connection.js:175:5) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at Object.onceWrapper (events.js:286:20) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at TLSSocket.emit (events.js:198:13) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at emitErrorNT (internal/streams/destroy.js:91:8) 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR at process._tickCallback (internal/process/next_tick.js:63:19) code: 'EHDBOPENCONN' } 2021-07-10T00:27:37.50+0530 [APP/PROC/WEB/0] ERR [cds.hana] - Could not establish connection for tenant "anonymous". Existing pool will be drained. 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR [cds] - { TimeoutError: Acquiring client from pool timed out. Please review your system setup, transaction handling, and pool configuration. 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at ResourceRequest._fireTimeout (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:62:17) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at Timeout.bound (/home/vcap/deps/0/node_modules/@sap/cds-foss/node_modules/generic-pool/lib/ResourceRequest.js:8:15) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at ontimeout (timers.js:436:11) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at tryOnTimeout (timers.js:300:5) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at listOnTimeout (timers.js:263:5) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR at Timer.processTimers (timers.js:223:10) 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR name: 'TimeoutError', 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR statusCode: 503, 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR id: '1615004', 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR level: 'ERROR', 2021-07-10T00:27:38.49+0530 [APP/PROC/WEB/0] ERR timestamp: 1625857058498 } 2021-07-10T00:27:38.50+0530 [RTR/3] OUT my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com - [2021-07-09T18:57:37.481601564Z] "GET /catalog/Authors?$top=11 HTTP/1.1" 503 0 160 "https://my-bookshop-srv-busy-hyena-ku.cfapps.eu10.hana.ondemand.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36" "-" "10.32.1.13:61033" x_forwarded_for:"-" x_forwarded_proto:"https" vcap_request_id:"61ca4c9a-49d9-44a5-63f0-ab2ee6ae74a3" response_time:1.018562 gorouter_time:0.000121 app_id:"fce92d6d-fa02-424f-abb2-d8771ab96bf4" app_index:"0" x_cf_routererror:"-" x_correlationid:"-" tenantid:"-" sap_passport:"-" x_scp_request_id:"cc8edb65-9eec-4d68-98fa-557f8273055c-60E89C20-2F96E5" x_cf_app_instance:"-" x_forwarded_host:"-" x_custom_host:"-" x_b3_traceid:"48d3964a2b33c337" x_b3_spanid:"48d3964a2b33c337" x_b3_parentspanid:"-" b3:"48d3964a2b33c337-48d3964a2b33c337" 2021-07-10T00:27:38.50+0530 [RTR/3] OUT

Labels: Landscape Labels: trail1, trail2 Scenario Label: SCPTest-banode Priority: High Sprint Label: SCPTest-2107A

@Askullu did you manage to resolve this issue? If yes, could you please let me know as to how?

shishir.paltanwale@alight.com

iwonahahn commented 8 months ago

@smahati can you please have a look here?

@shishirp05 I hope @smahati can help you here.

smahati commented 8 months ago

Hi,

It seems like there is an issue with the database connectivity as per the logs

effective pool configuration: { min: 0, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR max: 100, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR testOnBorrow: true, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR acquireTimeoutMillis: 1000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR softIdleTimeoutMillis: 30000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR idleTimeoutMillis: 30000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR evictionRunIntervalMillis: 60000, 2021-07-10T00:24:41.00+0530 [APP/PROC/WEB/0] ERR numTestsPerEvictionRun: 34 }

I will check with the topic owners to get their input and add it here.

Best regards, Mahati