SAP Knowledge Base Article - Preview

2377994 - hide_maintuser_pwd setting for Always-On is changed - SAP SRS

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 by default:
     
         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 and 16.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7

Keywords

resync, resynchronize, materializa, materialization, HADR, maint user , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.