SAP Knowledge Base Article - Preview

3147109 - HANA upgrade 1.0 to 2.0 not possible with single DB instance

Symptom

When attempting to upgrade HANA Database from 1.00.032 to 2.00.057 an error message appears in the hdbupd.log as below:

11:03:55.811 - INFO:   ---------------------------------------------------------
11:03:55.811 - INFO:   END: Starting service (sapstartsrv) (start: 11:03:53.128 duration: 00:00:02)
11:03:55.811 - INFO:   ---------------------------------------------------------
11:03:55.811 - INFO:   Checking current secure store setup
11:03:55.922 - INFO:     Switching to user id 1058 and group id 1000.
11:03:55.922 - INFO:     Starting external program /usr/sap/<SID>/HDBxx/exe/hdbnsutil
11:03:55.922 - INFO:       Command line is: /usr/sap/<SID>/HDBxx/exe/hdbnsutil -migrateSecureStore --target=LSS --dry-run
11:03:56.969 - INFO:       Output line 1: Migration of root keys not possible with single DB instance
11:03:56.969 - INFO:       Output line 2: failed.
11:03:57.030 - INFO:       Program terminated with exit code 1
11:03:57.030 - INFO:     Switching back to root user.
11:03:57.031 - ERR :     /usr/sap/<SID>/HDBxx/exe/hdbnsutil call failed [rc = 1]
11:03:57.032 - INFO:   Performing secondary system check
11:03:57.032 - INFO:   ---------------------------------------------------------
[...]

11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13476]{-1}[-1/-1] 2022-01-21 11:04:08.641166 e loadhistory      LoadHistoryCommon.cpp(00222) : header indicates file in unsupported SingleDB format
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[-1/-1] 2022-01-21 11:04:08.648532 e ServiceHandler   RequestHandlerRegistry.cpp(00033) : Could not register request handler with key: pers/ (already registered)
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.210568 e Metadata         catalog.cc(00650) : no index ptr found in IndexPtrMap. pos=117, #indexes=2, #indexes(trans)=2. index_map_info { (empty IndexMapInfoHandle) }
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.210587 e RS_Index         indexPtrMap_MapBased.cc(00816) : IndexPtrMap::getIndexMapInfo(): indexId=117 is not found in indexMap=0x00007fd6d2cf4cf0
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.294277 e Service_Startup  md_conv_util.cc(00705) : [metadata upgrade] error during: DROP SYNONYM PUBLIC.STATISTICS(ecode: 2) general error: indexId=117 is not found in indexMap
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.294336 e Service_Startup  md_ver_0000000274.cc(00043) : [metadata upgrade] Failed to drop P_STATISTICS_ due to error: general error
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.295245 e Service_Startup  md_conv_util.cc(00490) : [metadata upgrade #274] error: general error: indexId=117 is not found in indexMap
11:05:00.407 - INFO:       nameserver_hdbns3.35801.000.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.305597 e assign           TREXIndexServer.cpp(01948) : assign failed with ltt exception. stopping service... :
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13476]{-1}[-1/-1] 2022-01-21 11:04:08.641166 e loadhistory      LoadHistoryCommon.cpp(00222) : header indicates file in unsupported SingleDB format
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[-1/-1] 2022-01-21 11:04:08.648532 e ServiceHandler   RequestHandlerRegistry.cpp(00033) : Could not register request handler with key: pers/ (already registered)
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.210568 e Metadata         catalog.cc(00650) : no index ptr found in IndexPtrMap. pos=117, #indexes=2, #indexes(trans)=2. index_map_info { (empty IndexMapInfoHandle) }
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.210587 e RS_Index         indexPtrMap_MapBased.cc(00816) : IndexPtrMap::getIndexMapInfo(): indexId=117 is not found in indexMap=0x00007fd6d2cf4cf0
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.294277 e Service_Startup  md_conv_util.cc(00705) : [metadata upgrade] error during: DROP SYNONYM PUBLIC.STATISTICS(ecode: 2) general error: indexId=117 is not found in indexMap
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.294336 e Service_Startup  md_ver_0000000274.cc(00043) : [metadata upgrade] Failed to drop P_STATISTICS_ due to error: general error
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.295245 e Service_Startup  md_conv_util.cc(00490) : [metadata upgrade #274] error: general error: indexId=117 is not found in indexMap
11:05:00.409 - INFO:       nameserver_alert_hdbns3.trc: [13502]{-1}[1/406402] 2022-01-21 11:04:13.305597 e assign           TREXIndexServer.cpp(01948) : assign failed with ltt exception. stopping service... :
11:05:00.422 - INFO:       daemon_hdbns3.35800.000.trc: [13456]{-1}[-1/-1] 2022-01-21 11:04:18.618981 e Daemon           DaemonLoop.cpp(00296) : Unexpected child code: "WAITCHILD_EXIT"
11:05:00.425 - ERR :     Check the log file for SAP HANA Database error messages
11:05:00.426 - ERR :   Cannot start system


Read more...

Environment

SAP HANA, platform edition 1.0

Product

SAP HANA 1.0, platform edition

Keywords

KBA , HAN-LM-UPG-DB , Upgrade of HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.