Error during build - CUPS - TEST Service

[gunasekhar_nalla_reddy]

@sap/hdi-deploy, version 3.5.1 (mode default), server version 2.00.030.00.1522210459 (2.0.30.0), node version 8.9.3

Using service replacements from environment variable "SERVICE_REPLACEMENTS" with 1 replacements
Collecting files...
Collecting files... ok (0s 2ms)
5 directories collected
11 files collected
0 reusable modules collected
Processing grants files...
Processing "cfg/sflight.hdbgrants"...
Using service "hdi-sflight-service" of type "sql"
Error: Error executing: GRANT "SELECT","SELECT METADATA" ON SCHEMA "SFLIGHT" TO "OPENSAP_HANA6_00_2#OO" WITH GRANT OPTION;
(nested message: invalid user name: OPENSAP_HANA6_00_2#OO: line 1 col 57 (at pos 56))
grantor service: "hdi-sflight-service", type: "sql", user: "SYSTEM"
file name: /hana/shared/HXE/xs/app_working/hxehost/executionroot/2abb4421-4ec6-40c5-8240-ae879193d177/app/META-INF/.sap_java_buildpack/tomcat/temp/builder/hdi-builder/builds/build-5204564807477360756/core_db/cfg/sflight.hdbgrants
(0s 174ms)

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! /hana/shared/HXE/xs/app_working/hxehost/executionroot/2abb4421-4ec6-40c5-8240-ae879193d177/app/META-INF/cache/node8.9/.npm/_logs/2018-07-03T04_42_41_225Z-debug.log

[thomas_jung · Accepted solution]

>(nested message: invalid user name: OPENSAP_HANA6_00_2#OO

This error means that your space which you are building the container within is pointing to a different MDC tenant than the connection information of your User Provided Service. This is why when the User Provided Service connects to the database it doesn't see the user (OPENSAP_HANA6_00_2) which was created to be the container technical user. Most likely you need to adjust the port of the User Provided Service to point to the connect tenant.

[gunasekhar_nalla_reddy · Accepted solution]

Hello Thomas, Thank you. Changed the port and I am left with the below error. Couldn't make much out of it.

> node node_modules/@sap/hdi-deploy/deploy.js

@sap/hdi-deploy, version 3.3.0 (mode default), server version 2.00.030.00.1522210459 (2.0.30.0), node version 8.9.3
Using service replacements from environment variable "SERVICE_REPLACEMENTS" with 3 replacements
Collecting files...
Collecting files... ok (0s 7ms)
20 directories collected
230 files collected
1 reusable modules collected
Processing grants files...
Processing "cfg/central.hdbgrants"...
Processing "cfg/central.hdbgrants"... ok
Processing "cfg/sflight.hdbgrants"...

2:19:49 PM (DIBuild) grantor service: hdi-sflight-service, granting user: SYSTEM
file name: /hana/shared/HXE/xs/app_working/hxehost/executionroot/2abb4421-4ec6-40c5-8240-ae879193d177/app/META-INF/.sap_java_buildpack/tomcat/temp/builder/hdi-builder/builds/build-8141572716874832469/core_db/cfg/sflight.hdbgrants
(5s 779ms)

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! /hana/shared/HXE/xs/app_working/hxehost/executionroot/2abb4421-4ec6-40c5-8240-ae879193d177/app/META-INF/cache/node8.9/.npm/_logs/2018-07-03T18_19_52_074Z-debug.log

[thomas_jung · Accepted solution]

Are you sure you cut and pasted the complete error from the console. You seem to be missing some details.

[gunasekhar_nalla_reddy · Accepted solution]

Yes, this time I am using your code from GIT (SPS2) and it has the same issue. The entire log is as below.

10:17:36 PM (Builder) Build of /com.sap.openSAP.hana5.example/core_db started. 10:17:39 PM (DIBuild) Build of /com.sap.openSAP.hana5.example/core_db in progress 10:17:39 PM (DIBuild) [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.

10:17:42 PM (DIBuild)
> deploy@ start /hana/shared/HXE/xs/app_working/hxehost/executionroot/ce6ac59e-7150-4a41-a478-ae6733e03961/app/META-INF/.sap_java_buildpack/tomcat/temp/builder/hdi-builder/builds/build-3891085682965018576/core_db
> node node_modules/@sap/hdi-deploy/deploy.js

@sap/hdi-deploy, version 3.3.0 (mode default), server version 2.00.030.00.1522210459 (2.0.30.0), node version 8.9.3
Using service replacements from environment variable "SERVICE_REPLACEMENTS" with 3 replacements
Collecting files...
Collecting files... ok (0s 7ms)
20 directories collected
230 files collected
1 reusable modules collected
Processing grants files...
Processing "cfg/central.hdbgrants"...
Processing "cfg/central.hdbgrants"... ok
Processing "cfg/sflight.hdbgrants"...10:17:46 PM (DIBuild) grantor service: hdi-sflight-service, granting user: SYSTEM
file name: /hana/shared/HXE/xs/app_working/hxehost/executionroot/ce6ac59e-7150-4a41-a478-ae6733e03961/app/META-INF/.sap_java_buildpack/tomcat/temp/builder/hdi-builder/builds/build-3891085682965018576/core_db/cfg/sflight.hdbgrants
(5s 554ms)

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! /hana/shared/HXE/xs/app_working/hxehost/executionroot/ce6ac59e-7150-4a41-a478-ae6733e03961/app/META-INF/cache/node8.9/.npm/_logs/2018-07-04T02_17_46_605Z-debug.log10:17:49 PM (Builder) Build of /com.sap.openSAP.hana5.example/core_db failed.

[thomas_jung · Accepted solution]

There is no error displayed but something seems to be wrong with around the SFLIGHT grant. I would suggest looking at the referenced log at the end of this display. Also double check the requirements of this step. Do you have SFLIGHT installed in the tenant which you are deploying? Do you have the necessary roles set on the user SYSTEM?

[gunasekhar_nalla_reddy · Accepted solution]

The issue seems to be with the user not found. I am able to work through the UPS from different project or container with no issues.

I would like to see this CUPS working as I know how much useful this will be to pull the ERP Data. Let me know where to look for help.

Thanks.

The error log on Build.

11:24:36 PM (Builder) Build of /openSAPHANA6/core_db started. 11:24:39 PM (DIBuild) Build of /openSAPHANA6/core_db in progress 11:24:40 PM (DIBuild) [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.

11:24:42 PM (DIBuild)
> deploy@ start /hana/shared/HXE/xs/app_working/hxehost/executionroot/fa24140f-7f1f-4780-b303-3f4e427cb625/app/META-INF/.sap_java_buildpack/tomcat/temp/builder/hdi-builder/builds/build-128954614436764881/core_db
> node node_modules/@sap/hdi-deploy/deploy.js

@sap/hdi-deploy, version 3.5.1 (mode default), server version 2.00.030.00.1522210459 (2.0.30.0), node version 8.9.3
Using service replacements from environment variable "SERVICE_REPLACEMENTS" with 2 replacements
Collecting files...
File src/synonyms/user.hdbsynonymtemplate is using old-style .hdbsynonymtemplate. Please switch to .hdbsynonymconfig
Collecting files... ok (0s 2ms)
6 directories collected
15 files collected
0 reusable modules collected
Processing grants files...
Processing "cfg/sflight.hdbgrants"...
Using service "hdi-sflight-service" of type "sql"
Error: Error executing: GRANT "SELECT","SELECT METADATA" ON SCHEMA "SFLIGHT" TO "OPENSAP_HANA6_00_2#OO" WITH GRANT OPTION;(nested message: invalid user name: OPENSAP_HANA6_00_2#OO: line 1 col 57 (at pos 56))
grantor service: "hdi-sflight-service", type: "sql", user: "GUNREDDY"
file name: /hana/shared/HXE/xs/app_working/hxehost/executionroot/fa24140f-7f1f-4780-b303-3f4e427cb625/app/META-INF/.sap_java_buildpack/tomcat/temp/builder/hdi-builder/builds/build-128954614436764881/core_db/cfg/sflight.hdbgrants
(0s 173ms)

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! /hana/shared/HXE/xs/app_working/hxehost/executionroot/fa24140f-7f1f-4780-b303-3f4e427cb625/app/META-INF/cache/node8.9/.npm/_logs/2018-07-06T03_24_43_287Z-debug.log11:24:42 PM (Builder) Build of /openSAPHANA6/core_db failed.

[thomas_jung · Accepted solution]

The answer remains the same: This error means that your space which you are building the container within is pointing to a different MDC tenant than the connection information of your User Provided Service.

Your CUPS is pointing to port *15 which is is your first tenant. However from this error, it would appear you are building in a space which must be pointing to the SYSTEMDB (or you created another tenant). You have SFLIGHT installed into the tenant, but it would seem that your project is pointing to SYSTEMDB. You need to make sure your project and CUPS are pointing to the same tenant. Otherwise this won't work.

[gunasekhar_nalla_reddy · Accepted solution]

Thank you. It worked. I moved away from the SYSTEMDB and mapped the space development to my TENANTDB, imported the sflight to the tenant and rebuilt the services. That was a very timely help. Regards.