cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

HANA Express SPS4 Upgrade - Troubles in Paradise

StevenDeSaeger
Contributor

on ‎2019 Aug 13 9:04 AM

0 Kudos
869

Hi,

Last week the long awaited SPS4 for HANA Express came out so I eagerly upgraded my VMWare SUSE image of the latest SPS3 build I was running and have been using constantly over the last months ... Luckily I took a backup copy of that running image before I descended into upgrade hell ....

So a quick recap - after several upgrade attemps with plenty of new failures I think I ended up with a partial upgraded system ...

The current XS system info gives:

1. hxehost:29847
   created at              Aug 13, 2019 9:13:07 AM
   port range              40301-40650:40651-41000
   docker support active   false
   os.arch                 amd64
   os.name                 Linux
   java.vendor             SAP AG
   java.version            1.8.0_202
   os.version              4.4.121-92.98-default
   sun.arch.data.model     64
   version                 v1.0.114


Controller server version information:
--------------------------------------------------------------------------------------------------
   name                     XS Controller
   support                  http://service.sap.com/message
   build                    v1.0.114
   api version              1
   software version         1.0.114.14140
   content version          1.0.114.14140
   state                    READY
   description              SAP HANA XS Advanced Runtime
   controller endpoint      https://hxehost:39030
   authorization endpoint   https://hxehost:39032/uaa-security
   accept encoding          gzip, x-gzip
   usage                    apps: 60, routes: 57, services: 50
                            instances: 0 starting, 54 running, 103 stopped, 0 crashed, 0 timed out
   database type            HANA_MULTI
   database info            HDB 2.00.040.00.1553674765
   runtime database         SYSTEMDB

While the last feedback of my 3th upgrade attempt gave me:

Updating components...
Starting instances...
Updating Component List...
Installing XS Advanced Components...
  Updating SAP HANA Cockpit...
  Installation of SAP HANA Cockpit failed
Update of SAP HANA Express Edition components failed.
  Installation of XS Advanced components failed
    Update of SAP HANA Cockpit failed

Right ...

I had a couple of weird observations during my upgrade attempts:

1. My initial upgrade kicked off quite nice and went quite well - I thought - but then somewhere in the logs I found out that most of the XSA upgrade was completely skipped due to 'missing archives' and 'https connection failures' on the '127.0.0.2' ip ... weird. The system told me it was upgraded but after a restart I was basically still on SPS3.

2. I downloaded the archives again - exact same size - and restarted the upgrade process. Now suddently I got the error that the library 'libatomic1' was missing and the upgrade stopped immediately. This didn't happen at my first attempt. I installed the missing library and did a new attempt.

3. Now the upgrade process seemed to kick off seriously and took on forever. I let it run through the night. This morning a saw to my surprise the error as mentioned above. I restarted the system and now it does seem I have a (partial ?) SPS4 system. The SAP WebIDE mentions 'SPS 04 Patch 0 ( Build 4.4.10 )'.

Here is a partial extract of the log:

Summary before execution:
=========================


SAP HANA Express Edition
   Update Parameters
      SAP HANA System ID: HXE
      Remote Execution: ssh
      Update Execution Mode: optimized
      System Database User Name: SYSTEM
      XS Advanced Admin User: XSA_ADMIN
      XS Advanced Components: all
      Do not start the selected XS Advanced components after installation: none
   Software Components
      SAP HANA AFL (incl.PAL,BFL,OFL)
         Update from version 2.00.040.0000.1553698248 to 2.00.040.0000.1553698248
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages
      SAP HANA EPM-MDS
         Update from version 2.00.040.0000.1553698248 to 2.00.040.0000.1553698248
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/SAP_HANA_EPM-MDS_10/packages
      SAP HANA Database
         Update from version 2.00.040.00.1553674765 to 2.00.040.00.1553674765
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server
      SAP HANA XS Advanced Runtime
         Update from version 1.0.114.14140 to 1.0.114.14140
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_RT_10_LINUX_X86_64/packages
   XS Advanced Components
      SAP HANA Cockpit
         Update from version 2.9.5 to 2.0010.2
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/HANA_COCKPIT_20/sap-xsac-cockpit-2.10.2.zip
      SAP HANA tools for accessing catalog content, data preview, SQL console, etc.
         Update from version 2.9.23 to 2.009.23
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSAC_HRTT_20/XSACHRTT09_23.zip
      XS Messaging Service 1
         Update from version 1.4.2 to 1.004.2
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACMESSSRV04_2.zip
      Develop and run portal services for customer apps on XSA
         Update from version 1.4.0 to 1.004.0
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV04_0.zip
      SAP Web IDE Web Client
         Update from version 4.4.0 to 4.004.0
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE04_0.zip
      XS Services 1
         Update from version 1.7.8 to 1.007.8
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES07_8.ZIP
      SAPUI5 FESV4 XSA 1 - SAPUI5 1.52
         Update from version 1.52.28 to 1.052.28
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV452.28.zip
      SAPUI5 FESV5 XSA 1 - SAPUI5 1.60
         Update from version 1.60.8 to 1.060.8
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV560_8.zip
      SAPUI5 SERVICE BROKER XSA 1 - SAPUI5 Service Broker 1.0
         Update from version 1.0.3 to 1.000.3
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACUI5SB00_3.zip
      XSA Cockpit 1
         Update from version 1.1.13 to 1.001.13
         Location: /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACXSACOCKPIT01_13.zip
   Log File Locations
      Log directory: /var/tmp/hdb_HXE_hdblcm_update_2019-08-12_23.11.40
      Trace location: /var/tmp/hdblcm_2019-08-12_23.11.40_96756.trc


Note: Resume SAP HANA System update at step 'Start instances'
Updating components...
Starting instances...
Updating Component List...
Installing XS Advanced Components...
  Updating SAP HANA Cockpit...
  Installation of SAP HANA Cockpit failed
Update of SAP HANA Express Edition components failed.
  Installation of XS Advanced components failed
    Update of SAP HANA Cockpit failed

Not sure where I am now ? How can I check if I actually upgraded successfully or not ?

Thanks,

Steven

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
StevenDeSaeger
Contributor
‎2019 Aug 13 9:15 AM
0 Kudos

Found some more info on the SAP HANA Cockpit failure:

23:12:10.089 - INFO:   ---------------------------------------------------------
23:12:10.089 - INFO:   Updating SAP HANA Cockpit...
23:12:10.089 - INFO:   ---------------------------------------------------------
23:12:10.090 - INFO:     Switching to user id 1001 and group id 79.
23:12:10.090 - INFO:     Starting external program /hana/shared/HXE/xs/bin/xs
23:12:10.090 - INFO:       Command line is: /hana/shared/HXE/xs/bin/xs install /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/HANA_COCKPIT_20/sap-xsac-cockpit-2.10.2.zip -o ALLOW_SC_SAME_VERSION -e /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/cockpit-web-xsa-assembly-1.1.13.mtaext,/usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/DATA_UNITS/XSAC_SAP_WEB_IDE_20/sap-xsac-devx-4.4.10-hxe.mtaext --ignore-lock
23:12:11.124 - INFO:       Output line 1: 
23:12:13.167 - INFO:       Output line 2: Running installation in org "HANAExpress" / space "SAP" as XSA_ADMIN...
23:12:13.730 - INFO:       Output line 3: File upload starts...
23:12:40.810 - INFO:       Output line 4: Upload into container starts...
23:13:21.993 - INFO:       Output line 5: 
23:13:21.993 - INFO:       Output line 6: Installation failed.
23:13:21.994 - INFO:       Output line 7: ERR    com.sap.cloud.lm.sl.slp.client.HttpClientException: "Internal server error [class com.sap.lm.sl.alm.prod.installer.process.evaluation.ArchiveProcessingException] occurred. More details in the server logs"
23:13:22.015 - INFO:       Program terminated with exit code 1
23:13:22.015 - INFO:     Switching back to root user.
23:13:22.016 - ERR :     Update of SAP HANA Cockpit failed
UweFetzer_se38
Active Contributor
‎2019 Aug 13 9:24 AM
0 Kudos

Are you sure that you've dowloaded and inflated both hxe.tgz and hxexsa.tgz? I would suggest to start all over again with your backup and installed libatomic1.

Maybe the aborted attempts made something inconsistent ("strubbelig" in German).

StevenDeSaeger
Contributor
‎2019 Aug 13 9:29 AM
0 Kudos

Hey Uwe,

Yeah I made sure that I downloaded both archives correctly ... and I started again with an empty destination folder for the extraction ... 🙂

Thanks for thinking along though ...

StevenDeSaeger
Contributor
‎2019 Aug 21 8:39 AM
0 Kudos

Just some further progress feedback:

  • I took a copy of my SPS3 VM and attempted several times already to upgrade - each time failing on a different step ... not sure what is happening. Checked disk space but that seems fine. Increased VM memory but still no luck.
  • I already upgraded our AWS hosted SPS3 system ( CAL image ) - which is on the same SPS & patch level as my VM - that worked fine without any issues. Even no complaints about missing libraries.

What can I say ... strange ...

Accepted Solutions (0)

Answers (0)

Ask a Question