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
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.