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.