Symptom
- In a HADR setup, Rep Agent can't connect to Active SRS(companion) with RA user and reporting error primary ASE errorlog below:
kernel (CI-Info) Message: 1001, Severity: 0 Stream (<SID>) Received the following error message from the Replication Server: Msg 14021. Invalid login attempted by user '<SID>_RA_<Standby_Site_Name>'.
kernel (CI-Info) Message: 1001, Severity: 0 Stream (<SID>) Received the following communications error message: Msg 67175468. ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
kernel (CI-Info) Message: 76092, Severity: 0 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.'.
kernel (CI-Info) Message: 76054, Severity: 0 The Producer of Stream '<SID>' is shutting down.
server RepAgent(4): The Rep Agent Thread will retry the connection to the Replication Server every 60 second(s). (RepSvr = <Standby_Host>:4905). - In primary host, try the login with RA user using isql. It can connect to SRS without issue.
isql -U<SID>_RA_<Standby_Site_Name> -P<DR_admin password> -S<Standby_Host>:4905 -X -w2000 - In Active SRS, turn on SRS EXEC_CONNECTIONS, EXEC_LOCATER and audit trace. The trace collected is as below:
trace 'on', 'exec', EXEC_CONNECTIONS
go
trace 'on', 'exec', EXEC_LOCATER
go
configure replication server set audit_enable to 'on'
go
(124): ex_connect_handler: client conencting, name_full = '<SID>_RA_<Standby_Site_Name>'
(124): ex_connect_handler: Connect request from client_name(ciACKConn), name_full(<SID>_RA_<Standby_Site_Name>), enc(2), ulogin(398023680).
(124): ex_connect_handler: client_name(ciACKConn) name_full(<SID>_RA_<Standby_Site_Name>) get password successful
AUDIT: incoming command (issued by user '<SID>_RA_<Standby_Site_Name>', application 'ciACKConn', SPID '124', Event ID '0'): Failed login attempt for <SID>_RA_<Standby_Site_Name>
(124): ex_connect_handler: Refusing connection.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
Product
SAP Replication Server 16.0
Keywords
Msg 14021, 76092, 76054, CR 832020, 832020 , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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