System copy using SWPM Refresh or Move Database In...

Shawn_1977 · a month ago

Hello All,

We are performing System copy using SWPM Refresh or Move Database Instance(Online Production DB backup). SWPM got struck due to Online DB backup not available in a backup location. so i have stopped the SWPM.

I have triggered SWPM again to continue with new run but error received in SWPM. Can you please advise how to fix the issue?

Log: instdir/HdbCmdOut.log

Sat Jun 14 11:11:45 CEST 2025 | com.sap.hdb.sl.lib.connection.sql.JdbcConnection | Start new connection with connect URL: jdbc:sap://xxxxhostname:30013/?databaseName=PQ2 connect user: SYSTEM
Sat Jun 14 11:11:47 CEST 2025 | com.sap.hdb.sl.lib.utils.cmd.clazz.IsConnectPossible | HDBSLLIB Exception: [CONNECTION_REFUSED] com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://xxxxhostname:30013/ [Cannot connect to host /10.10.10.108:30015 [java.io.IOException: The remote computer refused the network connection.
], -813.: (uninitialized) -> 10.10.10.108:30015 ConnectionID:0 SessionID:0].
Sat Jun 14 11:11:47 CEST 2025 | com.sap.hdb.core.main.cmd.HdbCmdMain | End of HdbCmdClazz section: class com.sap.hdb.sl.lib.utils.cmd.clazz.IsConnectPossible
Sat Jun 14 11:11:47 CEST 2025 | com.sap.hdb.core.main.cmd.HdbCmdMain | *************************************************************

R3trans -d result:

4 ETW000 R3trans version 6.26 (release 777 - 17.12.24 - 14:40:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 14.06.2025 - 13:04:58
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -dx
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Sat Jun 14 13:04:58 2025
4 ETW000 [ dev trc,00000] Loading DB library 'dbhdbslib.dll' ...
4 ETW000 [ dev trc,00000] Library 'dbhdbslib.dll' loaded
4 ETW000 [ dev trc,00000] Version of 'dbhdbslib.dll' is "777.05", patchlevel (0.722)
4 ETW000 [ dev trc,00000] DBHDBSLIB : version 777.05, patch 0.722 (Make PL 0.722)
4 ETW000 [ dev trc,00000] HDB shared library (dbhdbslib) patchlevels (last 10)
4 ETW000 [ dev trc,00000] (0.722) M_ES_TABLES does not exist in HANA cloud (note 3550050)
4 ETW000 [ dev trc,00000] (0.717) Use m_rs_tables instead of m_tables (note 3532792)
4 ETW000 [ dev trc,00000] (0.715) Use always 54 bytes for the datatype TIMESTAMP (note 3530949)
4 ETW000 [ dev trc,00000] (0.700) SAP Support Package Stack Kernel 7.77 Patch Level 700 (note 3514012)
4 ETW000 [ dev trc,00000] (0.655) Don't set connect option bindAddress automatically (note 3482954)
4 ETW000 [ dev trc,00000] (0.650) DBSL procedure HDB_DBSL_CHECK_SCALEOUT (note 3456925)
4 ETW000 [ dev trc,00000] (0.646) Reset cursor statistics of the default connection (note 3457438)
4 ETW000 [ dev trc,00000] (0.646) IXML: Parser error for well-formed documents (note 3454376)
4 ETW000 [ dev trc,00000] (0.645) Reprepare after SQL return code 716 (note 3447956)
4 ETW000 [ dev trc,00000] (0.642) Opening of connection took longer than 1000ms (note 3445738)
4 ETW000 [ dev trc,00000]
4 ETW000 [ dev trc,00000] Loading SQLDBC client runtime (pid=13608)...
4 ETW000 [ dev trc,00000] SQLDBC Module : F:\usr\sap\SID\hdbclient\libSQLDBCHDB.dll
4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 2.18.027.1699386313
4 ETW000 [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ...
4 ETW000 [ dev trc,00000] connect property [APPLICATION = ABAP:SID]
4 ETW000 [ dev trc,00000] connect property [APPLICATIONVERSION = 777 PL 722]
4 ETW000 [ dev trc,00000] connect property [KEY = DEFAULT]
4 ETW000 [ dev trc,00000] connect property [UNICODE = 1]
4 ETW000 [ dev trc,00000] connect property [SQLMODE = SAPR3]
4 ETW000 [ dev trc,00000] connect property [VARCHARMODE = ABAP]
4 ETW000 [ dev trc,00000] connect property [PACKETSIZE = 1048576]
4 ETW000 [ dev trc,00000] connect property [COMPLETEARRAYEXECUTION = 1]
4 ETW000 [ dev trc,00000] connect property [CACHEDVIEWTS = 1]
4 ETW000 [ dev trc,00000] connect property [EMPTYTIMESTAMPISNULL = false]
4 ETW000 [ dev trc,00000] connect property [SPATIALTYPES = 1]
4 ETW000 [ dev trc,00000] connect property [STATEMENTROUTINGWARNINGS = TRUE]
4 ETW000 [dbhdbsql.cpp,00000] *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
4 ETW000 [ dev trc,00000] SQLCODE : -10709
4 ETW000 [ dev trc,00000] SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made be\
4 ETW000 [ dev trc,00000] cause the target machine actively refused it {0.0.0.0:64265 -> 10.10.10.108:30015} (0.0.0.0:64265 ->\
4 ETW000 [ dev trc,00000] 10.10.10.108:30015))
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -10709 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it {0.0.0.0:64265 -> 10.10.10.108:30015} (0.0.0.0:64265 -> 10.10.10.108:30015))
2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"
4 ETW000 [ dev trc,00000] Resetting statement cache ...
4 ETW000 [ dev trc,00000] Statement cache reset

Shawn_1977

SI2adm@XXX-SI2DB-01:/> sapcontrol -nr 00 -function GetProcessList

18.06.2025 07:55:35
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GREEN, Running, 2025 06 18 07:53:41, 0:01:54, 139741
hdbcompileserver, HDB Compileserver, GREEN, Running, 2025 06 18 07:53:48, 0:01:47, 140022
hdbnameserver, HDB Nameserver, GREEN, Running, 2025 06 18 07:53:41, 0:01:54, 139766
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2025 06 18 07:53:48, 0:01:47, 140025
hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2025 06 18 07:53:48, 0:01:47, 140066

----

As the initial refresh is triggered it, stopped the index server and as a result index server is down. so we tried to connect to system db sql and started the index service manually which fixed the issue.

hdbsql -U SYSDBKEY

select * from m_databases

SI2adm@XXX-SI2DB-01:/usr/sap/SI2/HDB00/XXX-SI2db-01/trace> hdbsql -U SYSDBKEY

Welcome to the SAP HANA Database interactive terminal.

Type: \h for help with commands
\q to quit

hdbsql SYSTEMDB=> alter system start databse SI2
* 257: sql syntax error: incorrect syntax near "databse": line 1 col 20 (at pos 20) SQLSTATE: HY000
hdbsql SYSTEMDB=> alter system start database SI2
0 rows affected (overall time 38.106033 sec; server time 38.105632 sec)

Rainie

Hi Shawn,

The error looked like HANA Database server refused the connection.
"System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it "

Have you checked the network communication between the SWPM server and HANA Database server?
e.g. telnet hostname port

I could find this KBA maybe helpful, even though, this is not secondary connection but default connection, you may still refer to the resolution section for troubleshooting.
3543496 - Secondary connection to HANA DB failed with 10709 + 10061 error - SAP for Me

br, Rainie

S_Sriram

Hi Shawn,

1. Are you logged on with the SAP SIDADM user ID? From the SWPM unable to access the DB,

2. Are you executing the R3TRANS-d from a normal user or SAP SIDAM?

3. Before starting the SWPM, please review the System Copy Guide.

Regards

SS

System copy using SWPM Refresh or Move Database Instance(Online DB backup)

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (3)

Answers (3)