Symptom
- sap_update_replication add_db failed due to the error below:
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 Message Log transfer for connection from 'AS1_UATPRIM_R2.newdb' failed to become active.
ResumeLogTransfer Corrective Action Check the ASE Replication Agent thread for the database 'AS1_UATPRIM_R2' and the Replication Server Replication Agent thread for the connection 'newdb.\{2\}'. Make sure that the connections is active then resubmit the failing command.
ResumeLogTransfer Hostname host1 - Primary SRS log contains the following errors:
E. 2022/05/09 08:44:09. ERROR #85 CI Logger( ) - /ci/spqplogfilemgr.c(1113)
SPQ directory '/repdevices/queue/spq132' has 1702MB free disk space, less than spq_min_size=2000MB.
E. 2022/05/09 08:44:09. ERROR #85 CI Logger( ) - /ci/spqplogfilemgr.c(967)
Failed to create SPQ directory '/repdevices/queue/spq132' because disk space is inadequate to host the SPQ device.
I. 2022/05/09 08:44:09. The Dispatch thread for SPQ 'crsdb' is terminated.
E. 2022/05/09 08:44:09. ERROR #85 CI Logger( ) - /generic/ci/spqext.c(935)
Failed to call function init_device_SPQP. Return code: 136.
E. 2022/05/09 08:44:09. ERROR #85 CI Logger( ) - generic/ci/msgcsum.c(2390)
Stream 'crsdb' failed to create SPQ '/repdevices/queue/spq132'.
- Secondary RMA errolog file contains the following messages:
2022-05-09 09:06:06 [ERROR] [Update Replication:46477][RMA] - [ResumeLogTransfer ] - Task Resume Log Transfer Connection - Failed with error message - Log transfer for connection from 'AS1_UATPRIM_R2.newdb' failed to become active.
2022-05-09 09:06:06 [INFO ] [Update Replication:46477][RMA] - [ResumeLogTransfer ] - Task Resume Log Transfer Connection - Provided corrective suggestion - Check the ASE Replication Agent thread for the database 'AS1_UATPRIM_R2' and the Replication Server Replication Agent thread for the connection 'newdb.\{2\}'. Make sure that the connections is active then resubmit the failing command.
2022-05-09 09:06:06 [INFO ] [Update Replication:46477][RMA] - [ResumeLogTransfer ] - Task Resume Log Transfer Connection - State - Error
2022-05-09 09:06:06 [TRACE] [Update Replication:46477][RMA] - [ConnectionManager ] - Terminate connection <1967118215(com.sybase.jdbc4.jdbc.SybConnection@c2ac3f0)>: jdbc_sybase_Tds_UZ2NDRDBS2C_5005_master_UZ2NDRDBS2C_5005_DR_admin_51c0de12dba4d232886a217092efd46a (s/r/a/w/t/o) (1127/2/0/0/0/0)
2022-05-09 09:06:06 [INFO ] [Update Replication:46477][RMA] - [AddASEDatabaseForDisaster] - Task Add Database to Replication - State - Error
2022-05-09 09:06:06 [INFO ] [Update Replication:46477][RMA] - [UpdateReplication ] - Task Update Replication - State - Error
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite with High Availability Disaster Recovery (HADR)
- SAP Replication Server (SRS) 16.0
Product
Keywords
KBA , 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.