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.
SAP Knowledge Base Article - Preview