SAP Knowledge Base Article - Preview

3746605 - RAT can't connect to SRS with RA user - SRS

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.