Jan 08, 2019 at 07:33 AM

Unable to create Database module as per the sap Teched 2018 DAT374 session

353 Views Last edit May 21, 2020 at 06:21 PM 2 rev

Hi experts,

Im trying to replicate the DAT374 session in webide.

where im not able to build the db module as it says service instance "TechEd2018CentralDB.teched-2018-cc" does not exist and failed to build the database module.

so i created a new service instance and provided that in the mta.yaml file for the centralDB with type "org.cloudfoundry.user-provided-service" and parametes {service-name - newly created service instance}.

now i got a different error and again failed to build the database module.

-------------------------------------------------------------------------------------------------------------

error log :-

12:36:04 PM (Builder) Build of "/dat374/db" started. 12:36:16 PM (DIBuild) Build of "/dat374/db" in progress. 12:36:19 PM (DIBuild) Service provisioning for module: '/db'
Creating a service instance for the 'CentralDB' resource type is currently not supported.
Service instance 'dat374-hdidb-P1942725372-workspaceuOKUB3hML8WY9zpk' for resource 'dat374-hdidb-P1942725372-workspaceuOKUB3hML8WY9zpk' already exists, no operation will be performed.
[INFO] Injecting source code into builder...
[INFO] Source code injection finished
[INFO] ------------------------------------------------------------------------
Your module contains a package.json file, it will be used for the build.

12:36:24 PM (DIBuild) added 37 packages from 79 contributors in 1.348s

> deploy@ start /home/vcap/app/.java-buildpack/tomcat/temp/builder/hdi-builder/builds/build-7285260780734966006/db
> node node_modules/@sap/hdi-deploy/deploy.js

@sap/hdi-deploy, version 3.7.0 (mode default), server version 2.00.002.00.1490188421 (2.0.2.0), node version 8.9.1
Using service replacements from environment variable "SERVICE_REPLACEMENTS" with 1 replacements
No ignore file at /home/vcap/app/.java-buildpack/tomcat/temp/builder/hdi-builder/builds/build-7285260780734966006/db/.hdiignore.
Collecting files...
Collecting files... ok (0s 2ms)
3 directories collected
5 files collected
0 reusable modules collected
Target service: dat374-hdidb-P1942725372-workspaceuOKUB3hML8WY9zpk
Processing grants files...
Processing "cfg/central.hdbgrants"...
Using service "central-db-service" of type "hdi"
Granting schema roles in the container "D3B756F995E24352B168DAF16CAB485C" and the parameters "[]"...
Granting the schema role "admin" to the principal "DAT374_3#OO" in the schema "" with grant option = "0"
Error: Granting schema roles in the container "D3B756F995E24352B168DAF16CAB485C" and the parameters "[]"... failed [8214221]
Error: Database error 389: : invalid role name: admin: line 1 col 7 (at pos 6) [8201003]
Error: Error executing: CALL "D3B756F995E24352B168DAF16CAB485C#DI".GRANT_CONTAINER_SCHEMA_ROLES(#CONTAINER_ROLES, #CONTAINER_ROLES_PARAMETERS, ?, ?, ?);
(nested message: HDI call failed)
grantor service: "central-db-service", type: "hdi", user: "SBSS_61800447415722129476806434534579288070551592183866235085443790172" (hdi_user)
file name: /home/vcap/app/.java-buildpack/tomcat/temp/builder/hdi-builder/builds/build-7285260780734966006/db/cfg/central.hdbgrants
(0s 253ms)

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! deploy@ start: `node node_modules/@sap/hdi-deploy/deploy.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the deploy@ start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /home/vcap/app/META-INF/cache/8.9.1/.npm/_logs/2019-01-08T07_06_25_542Z-debug.log
12:36:24 PM (Builder) Build of /dat374/db failed.

------------------------------------------------------------------------------------------------------------------------------------------------

what might be the possible error and how it can be solved..

thanks and regards

Rahul.a