3017007 - general error: Database could not be renamed; Cannot rename host specific paths

• A DB refresh is performed from a source system to target system with one or more tenant DBs and a SYSTEMDB.

• Post refresh, it is observed that the target DB system retains the same name as the source SID system id via query 'SELECT * FROM SYS.M_DATABASES'

Under the Column name "DATABASE_NAME", the original source system SIDs (PHD, <tenant_SID>) are appearing instead of the expected target SID names under SHD.

• Attempts to rename the SID for the target database via command 'RENAME DATABASE 'PHD' TO 'SHD' results in an error "SAP DBTech JDBC: [2]: general error: Database could not be renamed; Cannot rename host specific paths"

• In the "nameserver_alert_hostname.trc" traces, the following errors are observed after numerous failed attempts to rename the Database to the correct target SID:

2021-01-21 09:11:30.486032 e NameServer MDCRequestHandler.cpp(03156) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/SYS/global/hdb/backint/DB_PHD' to 'DB_SHD' : 17 (File exists)
2021-01-21 09:11:30.486058 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed
2021-01-21 09:12:58.968192 e NameServer MDCRequestHandler.cpp(04748) : database 'SHD' already exists
2021-01-21 09:12:58.968217 e NameServer MDCRequestHandler.cpp(03113) : RENAME DATABASE failed:Rename of database failed: SHD already exists.
2021-01-21 09:12:58.969337 e NameServer MDCRequestHandler.cpp(03156) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/SYS/global/hdb/custom/config/DB_PHD' to 'DB_SHD' : 17 (File exists)
2021-01-21 09:12:58.969355 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed
2021-01-21 09:15:16.150841 e NameServer MDCRequestHandler.cpp(04748) : database 'SHD' already exists
2021-01-21 09:15:16.150866 e NameServer MDCRequestHandler.cpp(03113) : RENAME DATABASE failed:Rename of database failed: SHD already exists.
2021-01-21 09:15:16.151407 e NameServer MDCRequestHandler.cpp(03156) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/SYS/global/hdb/backint/DB_PHD' to 'DB_SHD' : 17 (File exists)
2021-01-21 09:15:16.151423 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed
2021-01-21 09:16:01.699554 e NameServer MDCRequestHandler.cpp(04748) : database 'SHD' already exists
2021-01-21 09:16:01.699583 e NameServer MDCRequestHandler.cpp(03113) : RENAME DATABASE failed:Rename of database failed: SHD already exists.
2021-01-21 09:16:01.700650 e NameServer MDCRequestHandler.cpp(02350) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/HDB00/hostname/trace/DB_PHD' (17)
2021-01-21 09:16:01.700790 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed
2021-01-21 11:22:20.739004 e NameServer MDCRequestHandler.cpp(04748) : database 'SHD' already exists
2021-01-21 11:22:20.739032 e NameServer MDCRequestHandler.cpp(03113) : RENAME DATABASE failed:Rename of database failed: SHD already exists.
2021-01-21 11:22:20.739607 e NameServer MDCRequestHandler.cpp(03156) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/SYS/global/hdb/backint/DB_PHD' to 'DB_SHD' : 17 (File exists)
2021-01-21 11:22:20.739621 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed
2021-01-21 11:24:47.016635 e NameServer MDCRequestHandler.cpp(04748) : database 'SHD' already exists
2021-01-21 11:24:47.016660 e NameServer MDCRequestHandler.cpp(03113) : RENAME DATABASE failed:Rename of database failed: SHD already exists.
2021-01-21 11:24:47.017183 e NameServer MDCRequestHandler.cpp(03156) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/SYS/global/hdb/custom/config/DB_PHD' to 'DB_SHD' : 17 (File exists)
2021-01-21 11:24:47.017197 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed
2021-01-21 11:26:13.550553 e NameServer MDCRequestHandler.cpp(04748) : database 'SHD' already exists
2021-01-21 11:26:13.550577 e NameServer MDCRequestHandler.cpp(03113) : RENAME DATABASE failed:Rename of database failed: SHD already exists.
2021-01-21 11:26:13.551559 e NameServer MDCRequestHandler.cpp(02350) : RENAME DATABASE failed: Cannot rename path '/usr/sap/SHD/HDB00/hostname/trace/DB_PHD' (17)
2021-01-21 11:26:13.551693 e tns_ddl TNSClient.cpp(02310) : rename database '3' failed

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

• SAP HANA PLATFORM EDITION 1.0
• SAP HANA PLATFORM EDITION 2.0

KBA , HAN-DB-PER , SAP HANA Database Persistence , Problem