SAP Knowledge Base Article - Preview

2908929 - Support of Custom Password Checks method in HADR - SAP ASE 16.0

Symptom

  • 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


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • High Availability Disaster Recovery (HADR)

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

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.