SAP Knowledge Base Article - Preview

3229129 - SPQ Agent cannot activate the provided stream on Active RS

Symptom

  • Configuring Replication Out From an HADR System
  • On Active RS for HADR system, admin who shows SPQ AGENT thread is Connecting status :
    <spid>  SPQ AGENT      Connecting         120(33554432) <SID>_PRIM_R2.db1
  • The following Error messages contains in Active RS log file.
    I. 2022/**/** 08:46:41. Serialization is disabled for Consumer Reader(db1:33554432).
    I. 2022/**/** 08:46:41. Open the SPQ Reader(33554432) at index 5 for the SPQ 'db1'.
    I. 2022/**/** 08:46:42. CI stream(1:33554432) for site '<SID>_PRIM_R2.db1' is started.
    I. 2022/**/** 08:46:42. Loaded CI library. Version: [SAP CI-Library/16.0/EBF 29926 SP04 PL01 rs160sp04pl01/CI 1.17.0/Linux AMD64/Linux 4.12.14-95.54-default x86_64/2349/OPT64/Wed Jul 14 21:45:33 2021].
    I. 2022/**/** 08:46:43. Open Client Client-Library Message: severity(5), msgnumber(84083972), 
    'ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed', Operating System error(113) -- 'Socket connect failed - errno 113 No route to host'.
    I. 2022/**/** 08:46:43. Open Client Client-Library Message: severity(1), msgnumber(16843159), 
    'ct_cancel(): user api layer: external error: A connection to the server must exist on the connection structure before this routine can be called.'.
    ... ...
    I. 2022/**/** 08:47:13. SPQ Agent(33554432) cannot activate the provided stream, and will retry after 60 seconds.
    I. 2022/**/** 08:48:14. SPQ Agent(33554432) cannot activate the provided stream, and will retry after 60 seconds.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 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

SPQ AGENT,  Connecting, Operating System error(113), errno 113 No route to host, "cannot activate the provided stream" , 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.