Skip to Content
Author's profile photo Frank Schuler

Make the new standalone HANA 2 Cockpit work for you

After installing my first HANA 2 system, I realized that the HANA Cockpit is no longer an integral part of the database instance as it was with HANA 1, as is clearly stated in the HANA Cockpit Installation and Update Guide:

Also it cannot be deployed as an XS Advanced application on an existing SAP HANA instance, as again clearly stated in the HANA Cockpit Installation and Update Guide:

Therefore, I installed it on a small virtual machine similar in size to the one that is used by the HXE team to run their HANA, express edition.

The installation itself is straight forward with only one Action (however, I had to add the option –ignore=check_signature_file to make it work):

Also there is not much information to be provided to kick off the installation:

That can take a while but eventually finishes successfully and displays me the URLs for my HANA cockpit and HANA cockpit manager:

When I log into the HANA cockpit manager for the first time, I get assigned the required roles:

So that I can Register my HANA Cockpit installation as a Resource:

And monitor it in the HANA Cockpit:

Interestingly, the HANA Cockpit runs on HANA 2 itself.

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Great block, Frank! Thanks.

      I’m trying to do same staff except I’m using web-interface.

      I have an error while installation:

      Setting database properties for SAPHostControl
      01:27:59.733 – INFO: Starting external program /usr/sap/hostctrl/exe/saphostexec
      01:27:59.733 – INFO: Command line is: /usr/sap/hostctrl/exe/saphostexec -status
      01:27:59.955 – INFO: Output line 1: saphostexec running (pid = 12541)
      01:27:59.955 – INFO: Output line 2: sapstartsrv running (pid = 12546)
      01:28:00.036 – INFO: Output line 3: saposcol running (pid = 12600)
      01:28:00.036 – INFO: Program terminated with exit code 0
      01:28:00.737 – INFO: Calling web service method ‘SAPHostControl::SetDatabaseProperty’ on local host (url: ‘http:/tmp/.sapstream1128’, timeout: -1)
      01:28:00.737 – INFO: Arguments
      01:28:00.737 – INFO: Database/Host: ‘hxehost’
      01:28:00.737 – INFO: Database/InstanceName: ‘HDB90’
      01:28:00.737 – INFO: Database/Name: ‘HXE’
      01:28:00.738 – INFO: Database/Password: ‘***’
      01:28:00.738 – INFO: Database/PropertyName: ‘DBCredentials’
      01:28:00.738 – INFO: Database/PropertyValue: ‘SET’
      01:28:00.738 – INFO: Database/Type: ‘HDB’
      01:28:00.738 – INFO: Database/Username: ‘SYSTEM’
      01:28:00.738 – INFO: Password: ‘***’
      01:28:01.337 – INFO: Web service result
      01:28:01.337 – INFO: Executing SetDatabaseProperty
      01:28:01.337 – INFO: Hana Client software isn’t installed.
      01:28:01.337 – INFO: SetDatabaseProperty failed (sapdbctrl exit code = 1)
      01:28:01.337 – WRN : SAPHostControl::SetDatabaseProperty() failed: Command execution failed. : Hana Client software isn’t installed.
      01:28:01.338 – INFO: Removing status file
      01:28:01.339 – INFO: Status file ‘/hana/shared/HXE/HXE.hdbinstall’ removed

      It seems that the problem is in http:/tmp/.sapstream1128 request.

      Could you please advise which settings have you implemented for XSA runtime to make it work?

      Thanks!

      Petr

      Author's profile photo Former Member
      Former Member

      I read more carefully your blog and figured out - I do completely different thing.

      What you did - you installed a new system inside H4C inside HXE, right?

      Haven't you tried to update install Hana Cockpit into HXE directly as a component or it's not supposed to be done like this?

      Thanks!

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog Post Author

      Hello Petr,

      the HANA Cockpit is a stand alone installation that does not run on an existing XSA installation nor does it allow other XSA applications to run on it either. Of course you could add it as a second instance to an existing HANA installation, if your underlying machine had enough resources.

      Very best regards

      Author's profile photo Ayman Salem
      Ayman Salem

      Hallo Frank,

      In the HANA Express 2.0, the new HANA Cockpit is accessible under port 51037.

      Author's profile photo Former Member
      Former Member

      Hello Frank,

       

      Thank you very much for the blog, I tried to do the same installation, but the setup failed at the step of deployment, can you help me to know where could be the problem? Thanks!

      10:20:33.870 - INFO:     Output line 42:   Uploading the TomEE 1.7 runtime
      10:20:33.958 - INFO:     Output line 43:   Uploading the Tomcat 8 runtime
      10:20:34.005 - INFO:     Output line 44:   Uploading the SAP JVM 8 runtime
      10:20:34.027 - INFO:     Output line 45:   Uploading the SAP JVM 8 JRE runtime
      10:20:34.047 - INFO:     Output line 46:   Uploading the HANA JDBC driver runtime 2.x
      10:20:34.070 - INFO:     Output line 47:   Uploading the HANA JDBC driver runtime 1.X
      10:20:34.153 - INFO:     Output line 48:   Uploading Java buildpack
      10:21:09.348 - INFO:     Output line 49:   Creating application auditlog-db
      10:21:09.348 - INFO:     Output line 50:   Creating service auditlog-db-container
      10:21:16.398 - INFO:     Output line 51:   Uploading files for application auditlog-db
      10:21:16.878 - INFO:     Output line 52:   Staging application auditlog-db
      10:21:28.761 - INFO:     Output line 53:   Creating application auditlog-server
      10:21:28.761 - INFO:     Output line 54:   Creating service auditlog-sbss
      10:21:30.390 - INFO:     Output line 55:   Uploading files for application auditlog-server
      10:21:30.848 - INFO:     Output line 56:   Staging application auditlog-server
      10:21:42.996 - INFO:     Output line 57:   Creating application auditlog-broker
      10:21:44.256 - INFO:     Output line 58:   Uploading files for application auditlog-broker
      10:21:45.442 - INFO:     Output line 59:   Staging application auditlog-broker
      10:21:51.975 - INFO:     Output line 60:   Creating audit-log Hana-Service-Broker
      10:21:52.279 - INFO:     Output line 61:   Creating application deploy-service
      10:21:52.279 - INFO:     Output line 62:   Creating  service deploy-service-auditlog
      10:21:52.408 - INFO:     Output line 63:   Creating service deploy-service-ss
      10:21:52.649 - INFO:     Output line 64:   Creating service deploy-service-database
      10:21:52.834 - INFO:     Output line 65:   Creating service deploy-service-uaa
      10:21:54.482 - INFO:     Output line 66:   Uploading files for application deploy-service
      10:21:57.056 - INFO:     Output line 67:   Staging application deploy-service
      10:22:03.379 - INFO:     Output line 68:   Starting application deploy-service
      10:22:28.432 - INFO:     Output line 69:   Using service URL 'https://new-host-2.home:51004' for registration of deploy-service
      10:22:31.282 - INFO:     Output line 70:   Checking for existing service lcm-view-grantor
      10:22:31.323 - INFO:     Output line 71:   Creating service lcm-view-grantor
      10:22:32.230 - INFO:     Output line 72:   Uploading 1 files:
      10:22:32.284 - INFO:     Output line 73:   Uploading 1 files:
      10:22:33.155 - INFO:     Output line 74:   Starting process xs2-deploy...
      10:22:33.162 - INFO:     Output line 75:   Starting process xs2-deploy...
      10:22:33.591 - INFO:     Output line 76: Reconfiguring SAP HANA system failed!
      10:22:33.591 - INFO:     Output line 77:   Add local host roles:
      10:22:33.592 - INFO:     Output line 78:     Loading initial content of XS Advanced Runtime failed
      10:22:33.592 - INFO:     Output line 79:       Switching to user id 1001 and group id 79.
      10:22:33.592 - INFO:     Output line 80:       Starting external program /hana/shared/H4C/xs/installation-scripts/installation/load-initial-content
      10:22:33.592 - INFO:     Output line 81:         Command line is: /hana/shared/H4C/xs/installation-scripts/installation/load-initial-content SYSTEM_DB_USER=SYSTEM SYSTEM_DB_USER_PWD=__STDIN__ ORG_MANAGER_USER=COCKPIT_ADMIN ORG_MANAGER_PWD=__STDIN__
      10:22:33.592 - INFO:     Output line 82:         Output line 1: Step filter
      10:22:33.593 - INFO:     Output line 83:         Output line 2: Got parameter with name 'SYSTEM_DB_USER_PWD' via stdin
      10:22:33.593 - INFO:     Output line 84:         Output line 3: Got parameter with name 'ORG_MANAGER_PWD' via stdin
      10:22:33.593 - INFO:     Output line 85:         Output line 4: ###############################################
      10:22:33.593 - INFO:     Output line 86:         Output line 5: STARTING INSTALLATION FROM BASE VERSION 0.0.0.0
      10:22:33.593 - INFO:     Output line 87:         Output line 6: ###############################################
      10:22:33.593 - INFO:     Output line 88:         Output line 7: ##########
      10:22:33.593 - INFO:     Output line 89:         Output line 8: Installing step: Check the cpp runtime version
      10:22:33.594 - INFO:     Output line 90:         Output line 9: Check CPP environment..
      10:22:33.594 - INFO:     Output line 91:         Output line 10:  Node version check as user '<sidadm>' returned version: [v4.6.1]
      10:22:33.594 - INFO:     Output line 92:         Output line 11: Check CPP environment..
      10:22:33.594 - INFO:     Output line 93:         Output line 12:  Node version check as user '<sidadm>' returned version: [v4.6.1]
      10:22:33.594 - INFO:     Output line 94:         Output line 13: Check CPP environment..
      10:22:33.594 - INFO:     Output line 95:         Output line 14:  Node version check as user '<sidadm>' returned version: [v4.6.1]
      10:22:33.594 - INFO:     Output line 96:         Output line 15: ##########
      10:22:33.594 - INFO:     Output line 97:         Output line 16: ##########
      10:22:33.595 - INFO:     Output line 98:         Output line 17: Installing step: Wait at least 5 minutes for a database connection
      10:22:33.595 - INFO:     Output line 99:         Output line 18: ##########
      10:22:33.595 - INFO:     Output line 100:         Output line 19: ##########
      10:22:33.595 - INFO:     Output line 101:         Output line 20: Installing step: Hana-Service-Broker configuration|UAA broker configuration|Configure UAA SAML Trust
      10:22:33.595 - INFO:     Output line 102:         Output line 21: ##########
      10:22:33.595 - INFO:     Output line 103:         Output line 22: ##########
      10:22:33.596 - INFO:     Output line 104:         Output line 23: Installing step: UAA broker configuration
      10:22:33.596 - INFO:     Output line 105:         Output line 24: Installing step: Hana-Service-Broker configuration
      10:22:33.596 - INFO:     Output line 106:         Output line 25: ##########
      10:22:33.596 - INFO:     Output line 107:         Output line 26: Installing step: Configure UAA SAML Trust
      10:22:33.597 - INFO:     Output line 108:         Output line 27: Using UAA url https://new-host-2.home:39632/uaa-security
      10:22:33.597 - INFO:     Output line 109:         Output line 28: Changing default password for UAA xs client
      10:22:33.597 - INFO:     Output line 110:         Output line 29: Using HDI broker URL https://new-host-2.home:39632/hdi-broker
      10:22:33.597 - INFO:     Output line 111:         Output line 30: hdiDbId     :5886ee18-1e60-0cac-e100-0000c0a801bc
      10:22:33.597 - INFO:     Output line 112:         Output line 31: serviceGuid1:f646d9c3-7b0b-4dae-94bb-e47b2fdb7926
      10:22:33.597 - INFO:     Output line 113:         Output line 32: planGuid1   :fbc062a4-90a4-4c17-8209-83e76b806f4d
      10:22:33.597 - INFO:     Output line 114:         Output line 33: planGuid2   :070665a0-2a92-404b-84ee-7d9080c64366
      10:22:33.597 - INFO:     Output line 115:         Output line 34: planGuid3   :3148fd5c-79fc-4cce-addb-4faf81677633
      10:22:33.597 - INFO:     Output line 116:         Output line 35: planGuid4   :6deaffa3-beca-467f-ac4c-f1cb2b96ba2f
      10:22:33.598 - INFO:     Output line 117:         Output line 36: Configuring SAML trust for UAA located at 'https://new-host-2.home:39632/uaa-security'
      10:22:33.598 - INFO:     Output line 118:         Output line 37: Obtaining OAuth Token from UAA
      10:22:33.598 - INFO:     Output line 119:         Output line 38: serviceGuid1:f646d9c3-7b0b-4dae-94bb-e47b2fdb7926
      10:22:33.598 - INFO:     Output line 120:         Output line 39: planGuid1   :fbc062a4-90a4-4c17-8209-83e76b806f4d
      10:22:33.598 - INFO:     Output line 121:         Output line 40: planGuid2   :070665a0-2a92-404b-84ee-7d9080c64366
      10:22:33.598 - INFO:     Output line 122:         Output line 41: planGuid3   :3148fd5c-79fc-4cce-addb-4faf81677633
      10:22:33.598 - INFO:     Output line 123:         Output line 42: planGuid4   :6deaffa3-beca-467f-ac4c-f1cb2b96ba2f
      10:22:33.599 - INFO:     Output line 124:         Output line 43: Reading catalog templates from path '/hana/shared/H4C/xs/installation-scripts/installation/../../installation-scripts/installation/hdi'
      10:22:33.599 - INFO:     Output line 125:         Output line 44: Loading serivce broker catalog
      10:22:33.599 - INFO:     Output line 126:         Output line 45: Server response: 200 OK
      10:22:33.599 - INFO:     Output line 127:         Output line 46: Loading Hana-Service-Broker configuration
      10:22:33.599 - INFO:     Output line 128:         Output line 47: Server response: 200 OK
      10:22:33.600 - INFO:     Output line 129:         Output line 48: Loading Hana-Service-Broker credentials. DBID :5886ee18-1e60-0cac-e100-0000c0a801bc
      10:22:33.600 - INFO:     Output line 130:         Output line 49: Insecure HANA JDBC connection for HANA Broker Rename is configured!
      10:22:33.600 - INFO:     Output line 131:         Output line 50: Add database mapping
      10:22:33.600 - INFO:     Output line 132:         Output line 51: Configuring SAML trust
      10:22:33.601 - INFO:     Output line 133:         Output line 52: Changing default password for UAA service broker user
      10:22:33.601 - INFO:     Output line 134:         Output line 53: Server response: 201 Created
      10:22:33.601 - INFO:     Output line 135:         Output line 54: ##########
      10:22:33.601 - INFO:     Output line 136:         Output line 55: ##########
      10:22:33.601 - INFO:     Output line 137:         Output line 56: ##########
      10:22:33.601 - INFO:     Output line 138:         Output line 57: ##########
      10:22:33.601 - INFO:     Output line 139:         Output line 58: ##########
      10:22:33.601 - INFO:     Output line 140:         Output line 59: Installing step: Organizations and spaces
      10:22:33.602 - INFO:     Output line 141:         Output line 60: Creating organization 'HANACockpit'
      10:22:33.602 - INFO:     Output line 142:         Output line 61: Creating space 'cockpit'
      10:22:33.602 - INFO:     Output line 143:         Output line 62: Creating space 'SAP'
      10:22:33.602 - INFO:     Output line 144:         Output line 63: ##########
      10:22:33.603 - INFO:     Output line 145:         Output line 64: ##########
      10:22:33.603 - INFO:     Output line 146:         Output line 65: Installing step: Java Buildpack|Node.js Buildpack|JDBC Driver 1.X|JDBC Driver 2.x|Node.js 4|Node.js 6|SAP JVM 8 JRE|SAP JVM 8|Tomcat8|TomEE 1.7|Hana-Service-Broker|UAA service broker user
      10:22:33.603 - INFO:     Output line 147:         Output line 66: ##########
      10:22:33.603 - INFO:     Output line 148:         Output line 67: ##########
      10:22:33.603 - INFO:     Output line 149:         Output line 68: Installing step: Java Buildpack
      10:22:33.604 - INFO:     Output line 150:         Output line 69: Installing step: Node.js Buildpack
      10:22:33.604 - INFO:     Output line 151:         Output line 70: ##########
      10:22:33.604 - INFO:     Output line 152:         Output line 71: ##########
      10:22:33.604 - INFO:     Output line 153:         Output line 72: Installing step: JDBC Driver 1.X
      10:22:33.605 - INFO:     Output line 154:         Output line 73: Installing step: JDBC Driver 2.x
      10:22:33.605 - INFO:     Output line 155:         Output line 74: ##########
      10:22:33.605 - INFO:     Output line 156:         Output line 75: Installing step: Node.js 4
      10:22:33.605 - INFO:     Output line 157:         Output line 76: ##########
      10:22:33.605 - INFO:     Output line 158:         Output line 77: ##########
      10:22:33.606 - INFO:     Output line 159:         Output line 78: Installing step: Node.js 6
      10:22:33.606 - INFO:     Output line 160:         Output line 79: Installing step: SAP JVM 8 JRE
      10:22:33.606 - INFO:     Output line 161:         Output line 80: ##########
      10:22:33.606 - INFO:     Output line 162:         Output line 81: Installing step: SAP JVM 8
      10:22:33.606 - INFO:     Output line 163:         Output line 82: ##########
      10:22:33.607 - INFO:     Output line 164:         Output line 83: Installing step: Tomcat8
      10:22:33.607 - INFO:     Output line 165:         Output line 84: ##########
      10:22:33.607 - INFO:     Output line 166:         Output line 85: Installing step: TomEE 1.7
      10:22:33.607 - INFO:     Output line 167:         Output line 86: ##########
      10:22:33.607 - INFO:     Output line 168:         Output line 87: Installing step: Hana-Service-Broker
      10:22:33.608 - INFO:     Output line 169:         Output line 88: ##########
      10:22:33.608 - INFO:     Output line 170:         Output line 89: Installing step: UAA service broker user
      10:22:33.608 - INFO:     Output line 171:         Output line 90: Uploading Node.js buildpack
      10:22:33.608 - INFO:     Output line 172:         Output line 91: Creating UAA security Hana-Service-Broker
      10:22:33.609 - INFO:     Output line 173:         Output line 92: Uploading the Node.js 6 runtime
      10:22:33.609 - INFO:     Output line 174:         Output line 93: Creating Hana-Service-Broker
      10:22:33.609 - INFO:     Output line 175:         Output line 94: Uploading the Node.js 4 runtime
      10:22:33.610 - INFO:     Output line 176:         Output line 95: Uploading the TomEE 1.7 runtime
      10:22:33.610 - INFO:     Output line 177:         Output line 96: Uploading the Tomcat 8 runtime
      10:22:33.610 - INFO:     Output line 178:         Output line 97: Uploading the SAP JVM 8 runtime
      10:22:33.611 - INFO:     Output line 179:         Output line 98: Uploading the SAP JVM 8 JRE runtime
      10:22:33.611 - INFO:     Output line 180:         Output line 99: Uploading the HANA JDBC driver runtime 2.x
      10:22:33.611 - INFO:     Output line 181:         Output line 100: Uploading the HANA JDBC driver runtime 1.X
      10:22:33.612 - INFO:     Output line 182:         Output line 101: Uploading Java buildpack
      10:22:33.612 - INFO:     Output line 183:         Output line 102: ##########
      10:22:33.612 - INFO:     Output line 184:         Output line 103: ##########
      10:22:33.612 - INFO:     Output line 185:         Output line 104: ##########
      10:22:33.612 - INFO:     Output line 186:         Output line 105: ##########
      10:22:33.612 - INFO:     Output line 187:         Output line 106: ##########
      10:22:33.612 - INFO:     Output line 188:         Output line 107: ##########
      10:22:33.612 - INFO:     Output line 189:         Output line 108: ##########
      10:22:33.612 - INFO:     Output line 190:         Output line 109: ##########
      10:22:33.613 - INFO:     Output line 191:         Output line 110: ##########
      10:22:33.613 - INFO:     Output line 192:         Output line 111: ##########
      10:22:33.613 - INFO:     Output line 193:         Output line 112: ##########
      10:22:33.613 - INFO:     Output line 194:         Output line 113: ##########
      10:22:33.613 - INFO:     Output line 195:         Output line 114: ##########
      10:22:33.613 - INFO:     Output line 196:         Output line 115: ##########
      10:22:33.613 - INFO:     Output line 197:         Output line 116: Installing step: Wait for at least one Execution Agent
      10:22:33.613 - INFO:     Output line 198:         Output line 117: ##########
      10:22:33.614 - INFO:     Output line 199:         Output line 118: ##########
      10:22:33.614 - INFO:     Output line 200:         Output line 119: Installing step: Audit-Log Service (DB)
      10:22:33.614 - INFO:     Output line 201:         Output line 120: Creating application auditlog-db
      10:22:33.614 - INFO:     Output line 202:         Output line 121: Creating service auditlog-db-container
      10:22:33.615 - INFO:     Output line 203:         Output line 122: Uploading files for application auditlog-db
      10:22:33.615 - INFO:     Output line 204:         Output line 123: Staging application auditlog-db
      10:22:33.615 - INFO:     Output line 205:         Output line 124:   1/23/17 10:21:17.997 AM [STG/1] OUT   Node.js
      10:22:33.615 - INFO:     Output line 206:         Output line 125:   1/23/17 10:21:18.455 AM [STG/1] OUT   Node.js buildpack version 3.2.3
      10:22:33.615 - INFO:     Output line 207:         Output line 126:   1/23/17 10:21:18.459 AM [STG/1] OUT   Available Node.js runtimes: node6.9,node4.6
      10:22:33.615 - INFO:     Output line 208:         Output line 127:   1/23/17 10:21:20.430 AM [STG/1] OUT   Npm install not needed - attempting partial runtime download
      10:22:33.616 - INFO:     Output line 209:         Output line 128:   1/23/17 10:21:20.430 AM [STG/1] OUT   Downloading Node.js...
      10:22:33.616 - INFO:     Output line 210:         Output line 129:   1/23/17 10:21:20.629 AM [STG/1] OUT   Unpacking Node.js archive...
      10:22:33.616 - INFO:     Output line 211:         Output line 130:   1/23/17 10:21:20.641 AM [STG/1] OUT   Omitting npm install: node_modules directory is already present
      10:22:33.616 - INFO:     Output line 212:         Output line 131:   1/23/17 10:21:20.641 AM [STG/1] OUT   Copying SSL CA certificates...
      10:22:33.616 - INFO:     Output line 213:         Output line 132: ##########
      10:22:33.617 - INFO:     Output line 214:         Output line 133: ##########
      10:22:33.617 - INFO:     Output line 215:         Output line 134: Installing step: Audit-Log Service (Server)
      10:22:33.617 - INFO:     Output line 216:         Output line 135: Creating application auditlog-server
      10:22:33.617 - INFO:     Output line 217:         Output line 136: Creating service auditlog-sbss
      10:22:33.618 - INFO:     Output line 218:         Output line 137: Uploading files for application auditlog-server
      10:22:33.618 - INFO:     Output line 219:         Output line 138: Staging application auditlog-server
      10:22:33.618 - INFO:     Output line 220:         Output line 139:   1/23/17 10:21:31.831 AM [STG/1] OUT   Detected Java application
      10:22:33.618 - INFO:     Output line 221:         Output line 140:   1/23/17 10:21:31.935 AM [STG/1] OUT   Compiling Java application...
      10:22:33.618 - INFO:     Output line 222:         Output line 141:   1/23/17 10:21:32.867 AM [STG/1] OUT   Java XS Buildpack Version: 1.4.1
      10:22:33.618 - INFO:     Output line 223:         Output line 142:   1/23/17 10:21:33.421 AM [STG/1] OUT   Downloaded 'SAP JVM JRE', version '8.1.25' in 0.549 s.
      10:22:33.618 - INFO:     Output line 224:         Output line 143:   1/23/17 10:21:33.731 AM [STG/1] OUT   Downloaded 'Tomcat Runtime', version '8.0.36' in 0.240 s.
      10:22:33.618 - INFO:     Output line 225:         Output line 144:   1/23/17 10:21:33.892 AM [STG/1] OUT   Downloaded 'XS Authenticator', version '1.4.1' in 0.1 s.
      10:22:33.619 - INFO:     Output line 226:         Output line 145:   1/23/17 10:21:34.687 AM [STG/1] OUT   Downloaded 'XS JDBC DataSource Factory', version '1.4.1' in 0.0 s.
      10:22:33.619 - INFO:     Output line 227:         Output line 146:   1/23/17 10:21:34.690 AM [STG/1] OUT   Downloaded 'SAPSSOEXT', version '15.1.0' in 0.1 s.
      10:22:33.619 - INFO:     Output line 228:         Output line 147:   1/23/17 10:21:34.783 AM [STG/1] OUT   Downloaded 'SAP HANA JDBC Driver', version '2.0.0' in 0.84 s.
      10:22:33.619 - INFO:     Output line 229:         Output line 148:   1/23/17 10:21:34.786 AM [STG/1] OUT   Downloaded 'SAP JVM Memory Calculator', version '1.4.1' in 0.1 s.
      10:22:33.619 - INFO:     Output line 230:         Output line 149: ##########
      10:22:33.619 - INFO:     Output line 231:         Output line 150: ##########
      10:22:33.619 - INFO:     Output line 232:         Output line 151: Installing step: Audit-Log Service (Broker)
      10:22:33.620 - INFO:     Output line 233:         Output line 152: Creating application auditlog-broker
      10:22:33.620 - INFO:     Output line 234:         Output line 153: Uploading files for application auditlog-broker
      10:22:33.620 - INFO:     Output line 235:         Output line 154: Staging application auditlog-broker
      10:22:33.620 - INFO:     Output line 236:         Output line 155:   1/23/17 10:21:46.778 AM [STG/1] OUT   Node.js
      10:22:33.620 - INFO:     Output line 237:         Output line 156:   1/23/17 10:21:47.230 AM [STG/1] OUT   Node.js buildpack version 3.2.3
      10:22:33.620 - INFO:     Output line 238:         Output line 157:   1/23/17 10:21:47.234 AM [STG/1] OUT   Available Node.js runtimes: node6.9,node4.6
      10:22:33.621 - INFO:     Output line 239:         Output line 158:   1/23/17 10:21:47.825 AM [STG/1] OUT   Npm install not needed - attempting partial runtime download
      10:22:33.621 - INFO:     Output line 240:         Output line 159:   1/23/17 10:21:47.825 AM [STG/1] OUT   Downloading Node.js...
      10:22:33.621 - INFO:     Output line 241:         Output line 160:   1/23/17 10:21:47.944 AM [STG/1] OUT   Unpacking Node.js archive...
      10:22:33.621 - INFO:     Output line 242:         Output line 161:   1/23/17 10:21:47.955 AM [STG/1] OUT   Omitting npm install: node_modules directory is already present
      10:22:33.622 - INFO:     Output line 243:         Output line 162:   1/23/17 10:21:47.955 AM [STG/1] OUT   Copying SSL CA certificates...
      10:22:33.622 - INFO:     Output line 244:         Output line 163: Creating audit-log Hana-Service-Broker
      10:22:33.622 - INFO:     Output line 245:         Output line 164: ##########
      10:22:33.622 - INFO:     Output line 246:         Output line 165: ##########
      10:22:33.622 - INFO:     Output line 247:         Output line 166: Installing step: Deploy Service
      10:22:33.623 - INFO:     Output line 248:         Output line 167: Creating application deploy-service
      10:22:33.623 - INFO:     Output line 249:         Output line 168: Creating  service deploy-service-auditlog
      10:22:33.623 - INFO:     Output line 250:         Output line 169: Creating service deploy-service-ss
      10:22:33.624 - INFO:     Output line 251:         Output line 170: Creating service deploy-service-database
      10:22:33.624 - INFO:     Output line 252:         Output line 171: Creating service deploy-service-uaa
      10:22:33.624 - INFO:     Output line 253:         Output line 172: Uploading files for application deploy-service
      10:22:33.624 - INFO:     Output line 254:         Output line 173: Staging application deploy-service
      10:22:33.625 - INFO:     Output line 255:         Output line 174:   1/23/17 10:21:58.676 AM [STG/1] OUT   Detected Java application
      10:22:33.625 - INFO:     Output line 256:         Output line 175:   1/23/17 10:21:58.801 AM [STG/1] OUT   Compiling Java application...
      10:22:33.625 - INFO:     Output line 257:         Output line 176:   1/23/17 10:21:59.670 AM [STG/1] OUT   Java XS Buildpack Version: 1.4.1
      10:22:33.625 - INFO:     Output line 258:         Output line 177:   1/23/17 10:22:00.215 AM [STG/1] OUT   Downloaded 'SAP JVM JRE', version '8.1.25' in 0.538 s.
      10:22:33.625 - INFO:     Output line 259:         Output line 178:   1/23/17 10:22:00.499 AM [STG/1] OUT   Downloaded 'Tomcat Runtime', version '8.0.36' in 0.210 s.
      10:22:33.625 - INFO:     Output line 260:         Output line 179:   1/23/17 10:22:00.666 AM [STG/1] OUT   Downloaded 'XS Authenticator', version '1.4.1' in 0.1 s.
      10:22:33.625 - INFO:     Output line 261:         Output line 180:   1/23/17 10:22:01.461 AM [STG/1] OUT   Downloaded 'XS JDBC DataSource Factory', version '1.4.1' in 0.0 s.
      10:22:33.625 - INFO:     Output line 262:         Output line 181:   1/23/17 10:22:01.464 AM [STG/1] OUT   Downloaded 'SAPSSOEXT', version '15.1.0' in 0.0 s.
      10:22:33.625 - INFO:     Output line 263:         Output line 182:   1/23/17 10:22:01.559 AM [STG/1] OUT   Downloaded 'SAP HANA JDBC Driver', version '2.0.0' in 0.86 s.
      10:22:33.625 - INFO:     Output line 264:         Output line 183:   1/23/17 10:22:01.562 AM [STG/1] OUT   Downloaded 'SAP JVM Memory Calculator', version '1.4.1' in 0.0 s.
      10:22:33.626 - INFO:     Output line 265:         Output line 184: Starting application deploy-service
      10:22:33.626 - INFO:     Output line 266:         Output line 185: Using service URL 'https://new-host-2.home:51004' for registration of deploy-service
      10:22:33.626 - INFO:     Output line 267:         Output line 186: ##########
      10:22:33.626 - INFO:     Output line 268:         Output line 187: ##########
      10:22:33.626 - INFO:     Output line 269:         Output line 188: Installing step: Product Installer|Audit Log UI
      10:22:33.627 - INFO:     Output line 270:         Output line 189: ##########
      10:22:33.627 - INFO:     Output line 271:         Output line 190: Installing step: Product Installer
      10:22:33.627 - INFO:     Output line 272:         Output line 191: ##########
      10:22:33.627 - INFO:     Output line 273:         Output line 192: Getting mtas
      10:22:33.627 - INFO:     Output line 274:         Output line 193: Installing step: Audit Log UI
      10:22:33.628 - INFO:     Output line 275:         Output line 194: Deploying application Audit Log UI
      10:22:33.628 - INFO:     Output line 276:         Output line 195: Getting multi-target apps in org "HANACockpit" / space "SAP" as COCKPIT_ADMIN...
      10:22:33.628 - INFO:     Output line 277:         Output line 196: No multi-target apps found
      10:22:33.628 - INFO:     Output line 278:         Output line 197:
      10:22:33.628 - INFO:     Output line 279:         Output line 198:
      10:22:33.628 - INFO:     Output line 280:         Output line 199: Checking for existing service lcm-view-grantor
      10:22:33.628 - INFO:     Output line 281:         Output line 200: Creating service lcm-view-grantor
      10:22:33.629 - INFO:     Output line 282:         Output line 201: Deploying application Product Installer
      10:22:33.629 - INFO:     Output line 283:         Output line 202:
      10:22:33.629 - INFO:     Output line 284:         Output line 203: Uploading 1 files:
      10:22:33.629 - INFO:     Output line 285:         Output line 204:  /hana/shared/H4C/xs/installdata/apps/auditlog/ui/auditlog-ui.mtar
      10:22:33.630 - INFO:     Output line 286:         Output line 205: Uploading 1 files:
      10:22:33.630 - INFO:     Output line 287:         Output line 206:  /hana/shared/H4C/xs/installdata/apps/product-installer/product-installer.mtar
      10:22:33.630 - INFO:     Output line 288:         Output line 207: ERR    Failed to upload files
      10:22:33.630 - INFO:     Output line 289:         Output line 208: ERR    Error occured during communication with HTTP server
      10:22:33.630 - INFO:     Output line 290:         Output line 209: ERR    errno: 32 (Broken pipe), error: Write failed (local port 42132 to address 192.168.1.188 (new-host-2.home), remote host unknown)
      10:22:33.630 - INFO:     Output line 291:         Output line 210: File upload finished
      10:22:33.630 - INFO:     Output line 292:         Output line 211:
      10:22:33.631 - INFO:     Output line 293:         Output line 212: Starting process xs2-deploy...
      10:22:33.631 - INFO:     Output line 294:         Output line 213: ERR    Failed to upload files
      10:22:33.631 - INFO:     Output line 295:         Output line 214: ERR    Error occured during communication with HTTP server
      10:22:33.631 - INFO:     Output line 296:         Output line 215: ERR    errno: 32 (Broken pipe), error: Write failed (local port 42814 to address 192.168.1.188 (new-host-2.home), remote host unknown)
      10:22:33.631 - INFO:     Output line 297:         Output line 216: File upload finished
      10:22:33.631 - INFO:     Output line 298:         Output line 217:
      10:22:33.631 - INFO:     Output line 299:         Output line 218: Starting process xs2-deploy...
      10:22:33.631 - INFO:     Output line 300:         Output line 219: ERR    Failed to start process
      10:22:33.632 - INFO:     Output line 301:         Output line 220: ERR    Forbidden
      10:22:33.632 - INFO:     Output line 302:         Output line 221: ERR    Failed to start process
      10:22:33.632 - INFO:     Output line 303:         Output line 222: ERR    Forbidden
      10:22:33.632 - INFO:     Output line 304:         Output line 223: Removing service lcm-view-grantor
      10:22:33.632 - INFO:     Output line 305:         Output line 224: Service binding lcm-view-grantor not found
      10:22:33.632 - INFO:     Output line 306:         Output line 225: ------------------------------------------------------------------------------------------------------------------
      10:22:33.632 - INFO:     Output line 307:         Output line 226: |Step                                                         | Started      |  Stopped       |  Difference      |
      10:22:33.632 - INFO:     Output line 308:         Output line 227: ------------------------------------------------------------------------------------------------------------------
      10:22:33.632 - INFO:     Output line 309:         Output line 228: |Check the cpp runtime version                                | 15:20:28.503 |  15:20:28.603  |         0.100 s  |
      10:22:33.632 - INFO:     Output line 310:         Output line 229: |Wait at least 5 minutes for a database connection            | 15:20:28.604 |  15:20:28.610  |         0.006 s  |
      10:22:33.632 - INFO:     Output line 311:         Output line 230: |   (p) Hana-Service-Broker configuration (2.816 s)           | 15:20:28.613 |  15:20:31.429  |                  |
      10:22:33.632 - INFO:     Output line 312:         Output line 231: |   (p) UAA broker configuration (3.227 s)                    | 15:20:28.613 |  15:20:31.840  |                  |
      10:22:33.633 - INFO:     Output line 313:         Output line 232: |   (p) Configure UAA SAML Trust (4.173 s)                    | 15:20:28.615 |  15:20:32.788  |                  |
      10:22:33.633 - INFO:     Output line 314:         Output line 233: |Organizations and spaces                                     | 15:20:32.789 |  15:20:33.663  |         0.874 s  |
      10:22:33.633 - INFO:     Output line 315:         Output line 234: |   (p) Java Buildpack (12.374 s)                             | 15:20:33.665 |  15:20:46.039  |                  |
      10:22:33.633 - INFO:     Output line 316:         Output line 235: |   (p) Node.js Buildpack (12.297 s)                          | 15:20:33.665 |  15:20:45.962  |                  |
      10:22:33.633 - INFO:     Output line 317:         Output line 236: |   (p) JDBC Driver 1.X (3.683 s)                             | 15:20:33.666 |  15:20:37.349  |                  |
      10:22:33.633 - INFO:     Output line 318:         Output line 237: |   (p) JDBC Driver 2.x (2.447 s)                             | 15:20:33.666 |  15:20:36.113  |                  |
      10:22:33.633 - INFO:     Output line 319:         Output line 238: |   (p) Node.js 4 (35.548 s)                                  | 15:20:33.667 |  15:21:09.215  |                  |
      10:22:33.633 - INFO:     Output line 320:         Output line 239: |   (p) Node.js 6 (35.603 s)                                  | 15:20:33.668 |  15:21:09.271  |                  |
      10:22:33.633 - INFO:     Output line 321:         Output line 240: |   (p) SAP JVM 8 JRE (18.294 s)                              | 15:20:33.668 |  15:20:51.962  |                  |
      10:22:33.633 - INFO:     Output line 322:         Output line 241: |   (p) SAP JVM 8 (20.739 s)                                  | 15:20:33.669 |  15:20:54.408  |                  |
      10:22:33.633 - INFO:     Output line 323:         Output line 242: |   (p) Tomcat8 (12.974 s)                                    | 15:20:33.669 |  15:20:46.643  |                  |
      10:22:33.633 - INFO:     Output line 324:         Output line 243: |   (p) TomEE 1.7 (12.743 s)                                  | 15:20:33.670 |  15:20:46.413  |                  |
      10:22:33.633 - INFO:     Output line 325:         Output line 244: |   (p) Hana-Service-Broker (11.802 s)                        | 15:20:33.670 |  15:20:45.472  |                  |
      10:22:33.633 - INFO:     Output line 326:         Output line 245: |   (p) UAA service broker user (10.274 s)                    | 15:20:33.671 |  15:20:43.945  |                  |
      10:22:33.633 - INFO:     Output line 327:         Output line 246: |Wait for at least one Execution Agent                        | 15:21:09.271 |  15:21:09.325  |         0.054 s  |
      10:22:33.634 - INFO:     Output line 328:         Output line 247: |Audit-Log Service (DB)                                       | 15:21:09.325 |  15:21:28.737  |        19.412 s  |
      10:22:33.634 - INFO:     Output line 329:         Output line 248: |Audit-Log Service (Server)                                   | 15:21:28.737 |  15:21:42.978  |        14.241 s  |
      10:22:33.634 - INFO:     Output line 330:         Output line 249: |Audit-Log Service (Broker)                                   | 15:21:42.978 |  15:21:52.262  |         9.284 s  |
      10:22:33.634 - INFO:     Output line 331:         Output line 250: |Deploy Service                                               | 15:21:52.263 |  15:22:28.700  |        36.437 s  |
      10:22:33.634 - INFO:     Output line 332:         Output line 251: |   (p) Product Installer (4.821 s)                           | 15:22:28.701 |  15:22:33.522  |                  |
      10:22:33.634 - INFO:     Output line 333:         Output line 252: |   (p) Audit Log UI (4.702 s)                                | 15:22:28.701 |  15:22:33.403  |                  |
      10:22:33.634 - INFO:     Output line 334:         Output line 253: |Clear the XSA Secure Store                                   | 00:00:00.000 |  00:00:00.000  |         0.000 s  |
      10:22:33.634 - INFO:     Output line 335:         Output line 254: |Setting version                                              | 00:00:00.000 |  00:00:00.000  |         0.000 s  |
      10:22:33.634 - INFO:     Output line 336:         Output line 255: ------------------------------------------------------------------------------------------------------------------
      10:22:33.634 - INFO:     Output line 337:         Output line 256: |Procedure time                                               |              |  overall       |     02:05.023 m  |
      10:22:33.634 - INFO:     Output line 338:         Output line 257: ------------------------------------------------------------------------------------------------------------------
      10:22:33.634 - INFO:     Output line 339:         Output line 258: ERROR: Fatal error occured during installation: 2 error(s) during parallel step execution
      10:22:33.634 - INFO:     Output line 340:         Output line 259: com.sap.xs2rt.installation.util.InstallationException: 2 error(s) during parallel step execution
      10:22:33.634 - INFO:     Output line 341:         Output line 260:     at com.sap.xs2rt.installation.impl.util.ParallellnstallationStep.install(ParallellnstallationStep.java:233)
      10:22:33.634 - INFO:     Output line 342:         Output line 261:     at com.sap.xs2rt.installation.impl.steps.InstallationStepWrapper.install(InstallationStepWrapper.java:82)
      10:22:33.635 - INFO:     Output line 343:         Output line 262:     at com.sap.xs2rt.installation.procedures.InstallationProcedure.executeStep(InstallationProcedure.java:125)
      10:22:33.635 - INFO:     Output line 344:         Output line 263:     at com.sap.xs2rt.installation.procedures.InstallationProcedure.perform(InstallationProcedure.java:205)
      10:22:33.635 - INFO:     Output line 345:         Output line 264:     at com.sap.xs2rt.installation.impl.hana.content.HanaContentInstallUpdateProcedure.main(HanaContentInstallUpdateProcedure.java:86)
      10:22:33.635 - INFO:     Output line 346:         Output line 265: Caused by: java.lang.Exception: ---------------------------
      10:22:33.635 - INFO:     Output line 347:         Output line 266: ##ERROR## step   :"Product Installer" reported: Installing the Product Installer application failed: Execution of command 'deploy /hana/shared/H4C/xs/installation-scripts/installation/../../installdata/apps/product-installer/product-installer.mtar' failed.
      10:22:33.635 - INFO:     Output line 348:         Output line 267: com.sap.xs2rt.installation.util.InstallationException: Installing the Product Installer application failed: Execution of command 'deploy /hana/shared/H4C/xs/installation-scripts/installation/../../installdata/apps/product-installer/product-installer.mtar' failed.
      10:22:33.635 - INFO:     Output line 349:         Output line 268:     at com.sap.xs2rt.installation.impl.hana.content.components.DeployInstallationStep.install(DeployInstallationStep.java:79)
      10:22:33.635 - INFO:     Output line 350:         Output line 269:     at com.sap.xs2rt.installation.impl.hana.content.components.ProductInstallerAdvanced.install(ProductInstallerAdvanced.java:107)
      10:22:33.635 - INFO:     Output line 351:         Output line 270:     at com.sap.xs2rt.installation.impl.steps.InstallationStepWrapper.install(InstallationStepWrapper.java:82)
      10:22:33.635 - INFO:     Output line 352:         Output line 271:     at com.sap.xs2rt.installation.procedures.InstallationProcedure.executeStep(InstallationProcedure.java:125)
      10:22:33.635 - INFO:     Output line 353:         Output line 272:     at com.sap.xs2rt.installation.impl.util.ParallellnstallationStep.lambda$install$2(ParallellnstallationStep.java:199)
      10:22:33.636 - INFO:     Output line 354:         Output line 273:     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      10:22:33.636 - INFO:     Output line 355:         Output line 274:     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      10:22:33.636 - INFO:     Output line 356:         Output line 275:     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      10:22:33.636 - INFO:     Output line 357:         Output line 276:     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      10:22:33.636 - INFO:     Output line 358:         Output line 277:     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      10:22:33.636 - INFO:     Output line 359:         Output line 278:     at java.lang.Thread.run(Thread.java:805)
      10:22:33.636 - INFO:     Output line 360:         Output line 279: Caused by: java.lang.RuntimeException: Execution of command 'deploy /hana/shared/H4C/xs/installation-scripts/installation/../../installdata/apps/product-installer/product-installer.mtar' failed.
      10:22:33.636 - INFO:     Output line 361:         Output line 280:     at com.sap.xs2rt.installation.impl.hana.content.components.DeployInstallationStep.install(DeployInstallationStep.java:76)
      10:22:33.636 - INFO:     Output line 362:         Output line 281:     ... 10 more
      10:22:33.636 - INFO:     Output line 363:         Output line 282: ---------------------------
      10:22:33.636 - INFO:     Output line 364:         Output line 283: ---------------------------
      10:22:33.636 - INFO:     Output line 365:         Output line 284: ##ERROR## step   :"Audit Log UI" reported: Installing the Audit Log UI application failed: Execution of command 'deploy /hana/shared/H4C/xs/installation-scripts/installation/../../installdata/apps/auditlog/ui/auditlog-ui.mtar' failed.
      10:22:33.637 - INFO:     Output line 366:         Output line 285: com.sap.xs2rt.installation.util.InstallationException: Installing the Audit Log UI application failed: Execution of command 'deploy /hana/shared/H4C/xs/installation-scripts/installation/../../installdata/apps/auditlog/ui/auditlog-ui.mtar' failed.
      10:22:33.637 - INFO:     Output line 367:         Output line 286:     at com.sap.xs2rt.installation.impl.hana.content.components.DeployInstallationStep.install(DeployInstallationStep.java:79)
      10:22:33.637 - INFO:     Output line 368:         Output line 287:     at com.sap.xs2rt.installation.impl.hana.content.components.AuditLogServiceUiStep.install(AuditLogServiceUiStep.java:126)
      10:22:33.637 - INFO:     Output line 369:         Output line 288:     at com.sap.xs2rt.installation.impl.steps.InstallationStepWrapper.install(InstallationStepWrapper.java:82)
      10:22:33.637 - INFO:     Output line 370:         Output line 289:     at com.sap.xs2rt.installation.procedures.InstallationProcedure.executeStep(InstallationProcedure.java:125)
      10:22:33.637 - INFO:     Output line 371:         Output line 290:     at com.sap.xs2rt.installation.impl.util.ParallellnstallationStep.lambda$install$2(ParallellnstallationStep.java:199)
      10:22:33.637 - INFO:     Output line 372:         Output line 291:     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      10:22:33.637 - INFO:     Output line 373:         Output line 292:     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      10:22:33.637 - INFO:     Output line 374:         Output line 293:     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      10:22:33.637 - INFO:     Output line 375:         Output line 294:     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      10:22:33.637 - INFO:     Output line 376:         Output line 295:     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      10:22:33.637 - INFO:     Output line 377:         Output line 296:     at java.lang.Thread.run(Thread.java:805)
      10:22:33.637 - INFO:     Output line 378:         Output line 297: Caused by: java.lang.RuntimeException: Execution of command 'deploy /hana/shared/H4C/xs/installation-scripts/installation/../../installdata/apps/auditlog/ui/auditlog-ui.mtar' failed.
      10:22:33.637 - INFO:     Output line 379:         Output line 298:     at com.sap.xs2rt.installation.impl.hana.content.components.DeployInstallationStep.install(DeployInstallationStep.java:76)
      10:22:33.638 - INFO:     Output line 380:         Output line 299:     ... 10 more
      10:22:33.638 - INFO:     Output line 381:         Output line 300: ---------------------------
      10:22:33.638 - INFO:     Output line 382:         Output line 301:
      10:22:33.638 - INFO:     Output line 383:         Output line 302:     ... 5 more
      10:22:33.638 - INFO:     Output line 384:         Output line 303: ##########
      10:22:33.638 - INFO:     Output line 385:         Program terminated with exit code 1
      10:22:33.638 - INFO:     Output line 386:       Switching back to root user.
      10:22:33.638 - INFO:     Output line 387:       /hana/shared/H4C/xs/installation-scripts/installation/load-initial-content call failed
      10:22:33.638 - INFO:     Output line 388:
      10:22:33.640 - INFO:     Output line 389: Log file written to '/var/tmp/hdb_H4C_hdblcm_install_2017-01-23_10.14.55/hdbmodify_addlocalroles.log' on host 'new-host-2'.
      10:22:33.733 - INFO:     Program terminated with exit code 1
      10:22:33.734 - INFO: -----------------------------------------------------------
      10:22:33.734 - INFO: END: Assign Additional Roles to the Local Host failed (start: 10:19:26.076 duration: 00:03:07.657)
      10:22:33.734 - INFO: -----------------------------------------------------------
      10:22:33.734 - INFO: Assigning Additional Roles to the Local Host failed
      10:22:33.793 - ERR : Installation of SAP HANA Cockpit System failed.
      10:22:33.818 - INFO: Summary of critical errors
      10:22:33.793 - ERR :   Installation of SAP HANA Cockpit System failed.
      10:22:33.733 - ERR :     Error occurred while executing SAP HANA Cockpit Components.

       

       

      Author's profile photo Former Member
      Former Member

      Hello Frank -

      Nice document. Thanks for sharing it.

      By the way, could you please let me know how to register H4C itself as a resource as I am unable to register in the cockpit manager because I don't know which user account need to use. I tried COCKPIT_ADMIN but giving error. Is there any separate account need to use?

      Regards,
      Gokul

      Author's profile photo Shridhar Gowda
      Shridhar Gowda

      Hello

      create new user and try registering system with this user.

      CREATE USER <username> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE; GRANT CATALOG READ to <username>; GRANT SELECT on SCHEMA _SYS_STATISTICS to <username>

      https://help.sap.com/viewer/1fc5d914096f4ef6929735be88f91f97/2.0.00/en-US/ae9c9daed31248e8b3960ffa70941f58.html

      Regards, Shridhar Gowda

       

      Author's profile photo Former Member
      Former Member

      Thanks for your response, Shridhar!

      The problem I am facing is not able to create user because the system neither add to studio nor from hdbsql.

      Regards,

      Gokul

      Author's profile photo Jonathan Ma
      Jonathan Ma

      Hello, how do you sign the SSL of Hana cockpit 2.0? THe installation puts in a self-signed certificate. I only found the OSS note 2243019 which is quite hard to understand. We are using a CA authority that requires us to create a certificate request and we import the response. Obviously there's no such option in Hana cockpit 2.0. It is telling us to import a custom certificate and private key. What is the procedure of generating such a custom certificate and private key?

      Author's profile photo Gianpietro Dal Zio
      Gianpietro Dal Zio

      The instructions in the blog https://blogs.sap.com/2017/05/25/providing-openssl-certificates-for-domains-defined-in-hana-xsa/ works for me