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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.