SAP Knowledge Base Article - Preview

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

Symptom

  • 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. 


Read more...

Environment

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

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

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

About this page

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

Search for additional results

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