3312988 - HADR setup fails due to log transfer for connection not active - SAP SRS

Symptom

While doing HADR setup on companion node, below errors show up in setuphadr log:
2023-03-10 03:02:16 Setting up replication on 'standby' host for local database 'master'...................Fail
TASKNAME TYPE VALUE
--------------------------------- ----------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Status Start Time Fri Mar 10 02:48:50 EST 2023
Status Elapsed Time 00:14:33
SetupReplicationTask Task Name Setup replication
SetupReplicationTask Task State Error
SetupReplicationTask Short Description Setup replication between two SAP ASE servers.
SetupReplicationTask Long Description Setting up replication on 'standby' host for local database 'master'.
SetupReplicationTask Current Task Number 4
SetupReplicationTask Total Number of Tasks 7
SetupReplicationTask Task Start Fri Mar 10 02:48:50 EST 2023
SetupReplicationTask Task End Fri Mar 10 03:03:23 EST 2023
SetupReplicationTask Hostname host2
AddASEDatabaseForDisasterRecoveryTask Name Add Database to Replication
AddASEDatabaseForDisasterRecoveryTask State Error
AddASEDatabaseForDisasterRecoveryShort Description Add an ASE database to the Replication System for Disaster Recovery support.
AddASEDatabaseForDisasterRecoveryLong Description Configuring the connection for database 'dsi_cdb_max_size' at the Replication Server on host '32'.
AddASEDatabaseForDisasterRecoveryCurrent Task Number 7
AddASEDatabaseForDisasterRecoveryTotal Number of Tasks 20
AddASEDatabaseForDisasterRecoveryHostname host2
ResumeLogTransfer Task Name Resume Log Transfer Connection
ResumeLogTransfer Task State Error
ResumeLogTransfer Short Description Resume the log transfer from a database.
ResumeLogTransfer Long Description Waiting 1 seconds: Waiting 1 seconds before checking if the command executed successfully.
ResumeLogTransfer Failing Command Error MessageLog transfer for connection from 'SID_Site2_R1.master' failed to become active.
ResumeLogTransfer Corrective Action Check the ASE Replication Agent thread for the database 'SID_Site2_R1' and the Replication Server Replication Agent thread for the connection 'master.\{2\}'. Make sure that the connections is active then resubmit the failing command.
ResumeLogTransfer Hostname host2
2023-03-10 03:03:26 Error: Setup Replication...Fail
in RMA log of primary node, below errors show up:
2023-03-10 03:03:23 [ERROR] [Setup replication:318][RMA] - [ResumeLogTransfer ] - Task Resume Log Transfer Connection - Failed with error message - Log transfer for connection from 'SID_Site2_R1.master' failed to become active.
2023-03-10 03:03:23 [INFO ] [Setup replication:318][RMA] - [ResumeLogTransfer ] - Task Resume Log Transfer Connection - Provided corrective suggestion - Check the ASE Replication Agent thread for the database 'SID_Site2_R1' and the Replication Server Replication Agent thread for the connection 'master.\{2\}'. Make sure that the connections is active then resubmit the failing command.
2023-03-10 03:03:23 [INFO ] [Setup replication:318][RMA] - [ResumeLogTransfer ] - Task Resume Log Transfer Connection - State - Error
2023-03-10 03:03:23 [TRACE] [Setup replication:318][RMA] - [ConnectionManager ] - Terminate connection <1160363690(out of scope)>: jdbc_sybase_Tds_host1_4905_master_host1_4905_DR_admin_e61729b2b69dc16181e31baf86e97 (s/r/a/w/t/o) (24/0/0/2/2/0)
2023-03-10 03:03:23 [INFO ] [Setup replication:318][RMA] - [AddASEDatabaseForDisaster] - Task Add Database to Replication - State - Error
2023-03-10 03:03:23 [INFO ] [Setup replication:318][RMA] - [SetupReplicationTask ] - Task Setup replication - State - Error
2023-03-10 03:03:23 [INFO ] [Setup replication:318][RMA] - [SetupReplicationTask ] - Task Setup replication - Time task started - Fri Mar 10 02:48:50 EST 2023
2023-03-10 03:03:23 [INFO ] [Setup replication:318][RMA] - [SetupReplicationTask ] - Task Setup replication - Time task ended - Fri Mar 10 03:03:23 EST 2023
in replication server log of primary node, below errors show up:
I. 2023/03/10 03:02:51. SPQ 'master' is performing initial creation of the SPQ log device.
I. 2023/03/10 03:02:51. Starting the Dispatch thread for SPQ 'master'.
E. 2023/03/10 03:02:51. ERROR #85 CI Logger( ) - \ci\spqplogfilemgr.c(463)
Failed to create SPQ directory 'PATH\spq106' because it already contains files. Please clean up the files or alter SPQ device directory to an empty directory.
E. 2023/03/10 03:02:51. ERROR #74129 CAP(106 SID_Site2_R1.master) - ric\cmdxlat\xlatci.c(638)
Failed to open CI stream(1:106) for site 'SID_Site2_R1.master'.
E. 2023/03/10 03:02:51. ERROR #74129 Log Transfer( ) - ric\cmdxlat\xlatci.c(638)
Failed to open CI stream(1:-1) for site 'SID_Site2_R1.master'.
I. 2023/03/10 03:02:51. The Dispatch thread for SPQ 'master' is terminated.
E. 2023/03/10 03:02:51. ERROR #85 CI Logger( ) - \generic\ci\spqext.c(935)
Failed to call function init_device_SPQP. Return code: 118.
E. 2023/03/10 03:02:51. ERROR #74103 Log Transfer( ) - ric\cmdxlat\xlatci.c(2258)
Failed to start log transfer for site 'SID_Site2_R1.master'.
E. 2023/03/10 03:02:51. ERROR #85 CI Logger( ) - generic\ci\msgcsum.c(2340)
Stream 'master' failed to create SPQ 'PATH\spq106'.

Environment

SAP Adaptive Server Enterprise (SAP ASE) 16.0 with High Availability Disaster Recovery (HADR)
SAP Replication Server (SAP SRS) 16.0

Keywords

SPQ, log transfer, init_device_SPQP, dsi_cdb_max_size , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-SYB-REP , Sybase Replication Server (standalone) , 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.