SAP Knowledge Base Article - Preview

3257289 - Failed to materialize DR node on command "sp_hadr_admin addserver_dr" - SRS

Symptom

1. Materialize failed and reported error below.

2022-10-07 08:35:19 [ERROR] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - Task Add ASE HADR member server - Failed performing command - sp_hadr_admin addserver_dr, '<Site1>', 'host1:4901'
2022-10-07 08:35:19 [ERROR] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - Task Add ASE HADR member server - Failed with error message - The command to add a member server to the ASE HADR system configuration for member '<Site1>' and network name 'host1:4901' failed with an exception.
2022-10-07 08:35:19 [ERROR] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - Task Add ASE HADR member server - Failed with Exception - Message: 'ASE encountered an error during 'PROPAGATE'. Check the ASE error log of server '<SID>' for details.' Cause: ''.
2022-10-07 08:35:19 [TRACE] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - Task Add ASE HADR member server - Failed with Stack Trace - ASE encountered an error during 'PROPAGATE'. Check the ASE error log of server '<SID>' for details.
com.sybase.jdbc4.jdbc.SybSQLException: ASE encountered an error during 'PROPAGATE'. Check the ASE error log of server '<SID>' for details.
 at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4200)
 at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3317)
 at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
 at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
 at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
 at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2762)
 at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2746)
 at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:596)
 at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
 at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
 at $java.lang.AutoCloseable$$EnhancerByProxool$$23c2dc41.executeUpdate(<generated>)
 at com.sybase.ua.plugins.dr.operations.SQLExecutor.execute(SQLExecutor.java:161)
 at com.sybase.ua.plugins.dr.tasks.ASEAddHADRServer.execute(ASEAddHADRServer.java:225)
 at com.sybase.ua.plugins.dr.tasks.TaskBase.runTask(TaskBase.java:262)
 at com.sybase.ua.plugins.dr.tasks.TaskBase.runSubTask(TaskBase.java:350)
 at com.sybase.ua.plugins.dr.tasks.ASESetupHADR.addHADRMember(ASESetupHADR.java:1088)
 at com.sybase.ua.plugins.dr.tasks.ASESetupHADR.multiNodeExecute(ASESetupHADR.java:238)
 at com.sybase.ua.plugins.dr.tasks.ASESetupHADR.execute(ASESetupHADR.java:145)
 at com.sybase.ua.plugins.dr.tasks.TaskBase.runTask(TaskBase.java:262)
 at com.sybase.ua.plugins.dr.tasks.TaskBase.runSubTask(TaskBase.java:350)
 at com.sybase.ua.plugins.dr.api.Materialize.setupHADR(Materialize.java:997)
 at com.sybase.ua.plugins.dr.api.Materialize.additionalProcessingAfterSIDMaterialization(Materialize.java:2155)
 at com.sybase.ua.plugins.dr.api.Materialize.executeMaterialization(Materialize.java:1995)
 at com.sybase.ua.plugins.dr.api.Materialize.execute(Materialize.java:796)
 at com.sybase.ua.plugins.dr.tasks.TaskBase.runTask(TaskBase.java:262)
 at com.sybase.ua.plugins.dr.api.APITaskBase.runTask(APITaskBase.java:444)
 at com.sybase.ua.plugins.dr.tasks.AsyncTaskThread.run(AsyncTaskThread.java:227)
 at java.lang.Thread.run(Thread.java:836)

2022-10-07 08:35:19 [ERROR] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - Task Add ASE HADR member server - Failing Command returned code - 17159
2022-10-07 08:35:19 [ERROR] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - ASE encountered an error during 'PROPAGATE'. Check the ASE error log of server '<SID>' for details.
2022-10-07 08:35:19 [INFO ] [Materialize:2513][RMA] - [ASEAddHADRServer         ] - Task Add ASE HADR member server - State - Error

2.The following error occurred in ASE error log on DR node during the materialization.

00:0011:00000:00162:2022/10/07 00:04:25.69 kernel  hadr administrator user account not found, this must be set via the sp_hadr_admin setlogin command
00:0011:00000:00162:2022/10/07 00:04:25.69 server  Error: 11221, Severity: 16, State: 1
00:0011:00000:00162:2022/10/07 00:04:25.69 server  No external login for suserid 0, server name '<Site2>'.
00:0011:00000:00162:2022/10/07 00:04:25.74 server  background task error 4002: Login failed.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
  • SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

Product

SAP Replication Server 16.0

Keywords

sp_hadr_admin addserver_dr failed, re-materialize DR node fails , 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.