Symptom
1. After failover from site1 to site2, running "sap_host_available site1" failed with following error on RMA log,
xxxx-06-30 03:07:39 [ERROR] [Thread - 4:1159][RMA] - [ResumeDSI ] - Task Resume DSI Connection - Failed with error message - The Replication Server connection to '<SID>_site1_R2.master' failed to become active.
xxxx-06-30 03:07:39 [ERROR] [Thread - 4:1159][RMA] - [ResumeDSI ] - Task Resume DSI Connection - Failed performing command - admin who, no_trunc
xxxx-06-30 03:07:39 [INFO ] [Thread - 4:1159][RMA] - [ResumeDSI ] - Task Resume DSI Connection - Provided corrective suggestion - Use ISQL to connect to the Replication Server and issue the command 'resume connection to <SID>_site1_R2.master'. Make sure that the connection is active then resubmit the failing command.
2. <SID>_site1_R2.master is a remote connection between site1 ASE and site2 SRS. Check site2 SRS log, there is following error,
I. xxxx/06/30 03:07:28. The DSI thread for database '<SID>_site1_R2.master' is started.
I. xxxx/06/30 03:07:28. The DSI thread for database '<SID>_site1_R2.PL1' is started.
E. xxxx/06/30 03:07:28. ERROR #1028 DSI(106 <SID>_site1_R2.master) - /generic/useful/cm.c(5369)
Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.
'.
E. xxxx/06/30 03:07:28. ERROR #1027 DSI(106 <SID>_site1_R2.master) - /generic/useful/cm.c(5369)
Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
E. xxxx/06/30 03:07:28. ERROR #13045 DSI(106 <SID>_site1_R2.master) - /generic/useful/cm.c(5373)
Failed to connect to server '<SID>_site1_R2' as user 'DR_maint'. See CT-Lib and/or server error messages for more information.
E. xxxx/06/30 03:07:28. ERROR #1028 DSI(110 <SID>_site1_R2.<SID>) - /generic/useful/cm.c(5369)
Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.
'.
I. xxxx/06/30 03:07:28. The DSI thread for database '<SID>_site1_R2.master' is shutdown.
E. xxxx/06/30 03:07:28. ERROR #1027 DSI(110 <SID>_site1_R2.<SID>) - /generic/useful/cm.c(5369)
Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
E. xxxx/06/30 03:07:28. ERROR #13045 DSI(110 <SID>_site1_R2.PL1) - /generic/useful/cm.c(5373)
Failed to connect to server '<SID>_site1_R2' as user 'DR_maint'. See CT-Lib and/or server error messages for more information.
I. xxxx/06/30 03:07:28. The DSI thread for database '<SID>_site1_R2.<SID>' is shutdown.
3. This kind of error could also happens when running 'sap_enable_replication', as these operations will bring up remote connections up temporarily to perform some specific task, then bring it down afterwards.
Read more...
Environment
- Adaptive Server Enterprise Always-on (HADR) 16.0
Product
Keywords
ERROR #1028, Message: 4002, DR_maint, remote connection, sap_host_availabe, sap_enable_replication , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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