Symptom
- ASE Server is configured to use Custom Password Checks.
- HADR installation fails during the execution of setuphadr with the following error:
Setup ASE HADR maintenance user
(SQL command) use master
Create maintenance login "SEC_DB_maint"...
(SQL command) create login SEC_DB_maint with password '********'
Grant "sa_role" role to " SEC_DB_maint"...
(SQL command) sp_role 'grant', sa_role, SEC_DB_maint
Error: Msg 11105, Level 16, State 3
Server SECONDARY_ASE, Procedure sp_role, Line 48, Status 3, TranState 1
No such user/role ' SEC_DB_maint' exists.
No such user/role ' SEC_DB_maint' exists.
com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4229)
com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3346)
com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:303)
com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:285)
com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2843)
com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2830)
com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1460)
com.sap.setuphadr.Isql.exec(Unknown Source)
com.sap.setuphadr.TaskMaintenanceUser.checkAndCreateUser(Unknown Source)
com.sap.setuphadr.TaskMaintenanceUser.runTask(Unknown Source)
com.sap.setuphadr.SetupHADR.executeTasks(Unknown Source)
com.sap.setuphadr.SetupHADR.main(Unknown Source)
(SQL command) use master
Error: Setup ASE HADR maintenance user...Fail
- When Custom Password Checks is disabled, setuphadr finish without error.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- High Availability Disaster Recovery (HADR)
Product
Keywords
sp_extrapwdchecks, 821398, CR821398, CR#821398, sp_rename , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed
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.