SAP Knowledge Base Article - Preview

3204294 - sap_update_replication add_db failed -- SRS

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

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

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.