SAP Knowledge Base Article - Preview

2377994 - hide_maintuser_pwd setting for Always-On is changed - SAP ASE HADR

Symptom

  • When failing over using the Always-On (HADR) feature, the DR_maint user password is changing in RepServer, but that it is not changing in ASE.  
  • The connection to a replicate database goes down due to a bad password. 
  • The HADR RepServer password protection configuration parameters are set to the following:
     
         hide_maintuser_pwd set to ‘on’
         maintuser_pwd_expiration set to 7
     
  • The following errors are reported in the ASE log:

** HADR operation: sap_host_available Alpha2,
** Message: is starting
**********************************************************************************
update of syslogins failed
Login failed : User DR_maint, Client IP address: 'XX.XXX.XX.XXX', Appname: RepServer, Progname: CT-Library, Progversion: 16.0.2.4, TdsVersion:5.0.0.0.
update of syslogins failed
Login failed : User DR_maint, Client IP address: 'XX.XXX.XX.XXX', Appname: RepServer, Progname: CT-Library, Progversion: 16.0.2.4, TdsVersion:5.0.0.0.
**********************************************************************************
** HADR operation: sap_host_available Alpha2,
** Message: failed
**********************************************************************************

  • The following errors are reported in the RepServer log:

User 'DR_admin' writes: '*******************************************************************************'
User 'DR_admin' writes: '** HADR operation: sap_host_available Alpha2,'
User 'DR_admin' writes: '** Message: is starting'
User 'DR_admin' writes: '*******************************************************************************'
The DSI thread for database 'HA1_Alpha2_R1.master' is started.
ERROR #1028 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5221)
        Message from server: Message: 3959, State 1, Severity 16 -- 'New transaction cannot be started as Adaptive Server is in 'Inactive' HADR state. The command could not be completed.'.
ERROR #1028 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5221)
        Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.'.
ERROR #1027 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5221)
        Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
ERROR #13045 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5225)
        Failed to connect to server 'HA1_Alpha2_R1' as user 'DR_maint'. See CT-Lib and/or server error messages for more information.
The DSI thread for database 'HA1_Alpha2_R1.master' is shutdown.
The DSI thread for database 'HA1_Alpha2_R1.master' is started.
ERROR #1028 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5221)
        Message from server: Message: 3959, State 1, Severity 16 -- 'New transaction cannot be started as Adaptive Server is in 'Inactive' HADR state. The command could not be completed.'.
ERROR #1028 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5221)
        Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.'.
ERROR #1027 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5221)
        Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
ERROR #13045 DSI(106 HA1_Alpha2_R1.master) - /generic/useful/cm.c(5225)
        Failed to connect to server 'HA1_Alpha2_R1' as user 'DR_maint'. See CT-Lib and/or server error messages for more information.
The DSI thread for database 'HA1_Alpha2_R1.master' is shutdown.
User 'DR_admin' writes: '*******************************************************************************'
User 'DR_admin' writes: '** HADR operation: sap_host_available Alpha2,'
User 'DR_admin' writes: '** Message: failed'
User 'DR_admin' writes:'********************************************************************************'


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 and higher
  • High Availability Disaster Recovery (HADR)
  • SAP Replication Server (SRS) 15.7.1

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7

Keywords

resync, resynchronize , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.