Uninstall SHINE XSA from SAP HANA, express edition (version: 2.00.057) before upgrade to (version: 2.00.061).

Reason of the Article

During the upgrade the following error message appeared.

hxeadm@hxehost:/usr/sap/HXE/HDB90> /usr/sap/HXE/home/bin/HXECheckUpdate_linux.bin -a
Installed SAP HANA, express edition version : 2.00.057.00.20211207.1
Connecting to download server...
Newer SAP HANA, express edition version 2.00.061.00.20220519.1 is available.
Found XS Advanced + apps (XSA)...
Enter XSA administrative user (XSA_ADMIN) password :
Login to XSA services...
Get apps in target space...
Found SAP HANA Interactive Education (SHINE)...
Found SAP HANA smart data integration...
Download following files to /usr/sap/HXE/home/Downloads :  hxe.tgz, hxexsa.tgz, shine.tgz, sdi.tgz
Invalid "shine.tgz" package file name.
hxeadm@hxehost:/usr/sap/HXE/HDB90>

The update process stopped with ‘Invalid “shine.tgz” package file name.’ message.

Prerequisites

• Hypervisor (VMware Workstation Player 16)
• SAP HANA, express edition (version: 2.00.057)
  Install SAP HANA 2.0, express edition on a Preconfigured Virtual Machine (with SAP HANA XS Advanced)
• SAP HANA Studio (version: 2.3.63)

Background

SHINE has been removed in SAP HANA, express edition 2.0 SPS06.

Remove SHINE

For uninstalling SHINE XSA we can follow the SHINE XSA SPS05 documentation https://help.sap.com/doc/13ff61e61a8f442090e27050dc61f019/2.0.05/en-US/SAP_HANA_Interactive_Education_SHINE_for_SAP_HANA_XS_Advanced_en_HANA2.0SPS05.pdf chapter 3.2.4.

Running the command unfortunately we receive error.

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs login -u XSA_ADMIN

API_URL: https://hxehost:39030
USERNAME: XSA_ADMIN
PASSWORD>
Authenticating...
ORG: HANAExpress
SPACE: SAP
API endpoint:   https://hxehost:39030 (API version: 1)
User:           XSA_ADMIN
Org:            HANAExpress
Space:          SAP

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs target -o HANAExpress -s SAP

API endpoint:   https://hxehost:39030 (API version: 1)
User:           XSA_ADMIN
Org:            HANAExpress
Space:          SAP

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs uninstall XSAC_SHINE --delete-services
Really uninstall 'XSAC_SHINE (–-delete-services)' ? (y/n)> y

Running uninstallation of "XSAC_SHINE (–-delete-services)" in org "HANAExpress" / space "SAP" as XSA_ADMIN...
ERR    com.sap.lm.sl.alm.prod.installer.client.ScvNotFoundException: The XSAC_SHINE (–-delete-services)  cannot be found
hxeadm@hxehost:/usr/sap/HXE/HDB90> xs uninstall 'XSAC_SHINE' --delete-services
Really uninstall 'XSAC_SHINE (–-delete-services)' ? (y/n)> y

Running uninstallation of "XSAC_SHINE (–-delete-services)" in org "HANAExpress" / space "SAP" as XSA_ADMIN...
ERR    com.sap.lm.sl.alm.prod.installer.client.ScvNotFoundException: The XSAC_SHINE (–-delete-services)  cannot be found
hxeadm@hxehost:/usr/sap/HXE/HDB90> xs list-components

Getting software components in org "HANAExpress" / space "SAP" as XSA_ADMIN...
Found software components:

software component           version
----------------------------------------
XSAC_COCKPIT (sap.com)       2.13.8
XSAC_HRTT (sap.com)          2.13.213701
XSAC_MESS_SRV (sap.com)      1.4.12
XSAC_PORTAL_SERV (sap.com)   1.5.6
XSAC_SAP_WEB_IDE (sap.com)   4.5.8
XSAC_SERVICES (sap.com)      1.7.13
XSAC_SHINE (sap.com)         1.8.9
XSAC_UI5_FESV5 (sap.com)     1.60.29
XSAC_UI5_FESV6 (sap.com)     1.71.38
XSAC_UI5_SB (sap.com)        1.0.3
XSAC_XSA_COCKPIT (sap.com)   1.1.17

hxeadm@hxehost:/usr/sap/HXE/HDB90>

Based on the following SAP Community answer we can do the removal.

https://answers.sap.com/questions/13026281/uninstall-fesv5-component-in-xsa.html 

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs uninstall XSAC_SHINE -scv --delete-services
Really uninstall 'XSAC_SHINE' component? (y/n)> y

Running uninstallation of "XSAC_SHINE" in org "HANAExpress" / space "SAP" as XSA_ADMIN...
Product Installer process ID: 17501
Product Installer runtime version [1.22.0] built at [2021-04-29 11:15]
Check for availability of required services starts...
All required services are reachable.
Check software component for uninstallation
Software component XSAC_SHINE (sap.com) can be uninstalled
Undeployment starts...
Invalidation of software component starts...
Software component XSAC_SHINE (sap.com) invalidated
Undeployment in progress. Undeploy service process ID: 40001
--------------- undeploy service START-----------------------------
Detected deployed MTA with ID "XSAC_SHINE" and version "1.8.9"
Unregistering service URL "shine-core-xsjs" for application "shine-core-xsjs"...
Unregistering service URL "shine-user-xsjs" for application "shine-user-xsjs"...
Unregistering service URL "shine-core-node" for application "shine-core-node"...
Unregistering service URL "web" for application "shine-web"...
Stopping application "shine-user-db"...
Deleting routes for application "shine-user-db"...
Deleting application "shine-user-db"...
Stopping application "shine-core-db"...
Deleting routes for application "shine-core-db"...
Deleting application "shine-core-db"...
Stopping application "shine-core-xsjs"...
Deleting routes for application "shine-core-xsjs"...
Deleting route https://hxehost:51044...
Deleting application "shine-core-xsjs"...
Stopping application "shine-user-xsjs"...
Deleting routes for application "shine-user-xsjs"...
Deleting route https://hxehost:51053...
Deleting application "shine-user-xsjs"...
Stopping application "shine-core-node"...
Deleting routes for application "shine-core-node"...
Deleting route https://hxehost:51054...
Deleting application "shine-core-node"...
Stopping application "shine-web"...
Deleting routes for application "shine-web"...
Deleting route https://hxehost:51055...
Deleting application "shine-web"...
Stopping application "shine-site-web"...
Deleting routes for application "shine-site-web"...
Deleting route https://hxehost:51056...
Deleting application "shine-site-web"...
Stopping application "shine-site-content"...
Deleting routes for application "shine-site-content"...
Deleting application "shine-site-content"...
Deleting service "sap-portal-services-client"...
Deleting service "shine-uaa"...
Deleting service "secureStore"...
Deleting service "shine-scheduler"...
Deleting service "sapui5-provider"...
Deleting service "shine-auditlog"...
Deleting service "sap-portal-services-host"...
Deleting service "shine-user-container"...
Deleting service "shine-container"...
--------------- undeploy service END -------------------------------
Undeployment finished successfully.
Unregistration of software component starts...
Unregistration of software component XSAC_SHINE (sap.com) finished
Process [uninstallSCV] finished successfully.
Performance Uninstallation: 2 m 55 s (175489 ms).
Uninstallation of 'XSAC_SHINE' finished successfully
To display uninstallation logs execute 'xs display-installation-logs 17501 --unins_scv'

hxeadm@hxehost:/usr/sap/HXE/HDB90>

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs list-components

Getting software components in org "HANAExpress" / space "SAP" as XSA_ADMIN...
Found software components:

software component           version
----------------------------------------
XSAC_COCKPIT (sap.com)       2.13.8
XSAC_HRTT (sap.com)          2.13.213701
XSAC_MESS_SRV (sap.com)      1.4.12
XSAC_PORTAL_SERV (sap.com)   1.5.6
XSAC_SAP_WEB_IDE (sap.com)   4.5.8
XSAC_SERVICES (sap.com)      1.7.13
XSAC_UI5_FESV5 (sap.com)     1.60.29
XSAC_UI5_FESV6 (sap.com)     1.71.38
XSAC_UI5_SB (sap.com)        1.0.3
XSAC_XSA_COCKPIT (sap.com)   1.1.17

hxeadm@hxehost:/usr/sap/HXE/HDB90>

Conclusion

To able to do the upgrade we need to uninstall SHINE first from the HXE, then try HXECheckUpdate_linux.bin again as a workaround.

Question

Q&A link for SAP HANA, express edition: https://answers.sap.com/tags/73555000100800000651