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.
SAP Knowledge Base Article - Preview