SAP Knowledge Base Article - Preview

3517994 - Feature request to not delete all entries in sysloginroles when doing auto-rematerialization for master - ASE HADR

Symptom

  • When doing running sap_materialize for master database
  • It will bcp out on system table 'sysloginroles' from primary
  • Then apply the content on the standby server in a two stage process
    • delete all entries sysloginroles
    • repopulate via bcp in

  • While it is rare, there is a chance that if the bcp in fails (for example due to master log full or sybsecurity / audit issue)
  • No user can log in on the standby ASE or no login has any system / security roles left to fix the situation. 


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

SAP Adaptive Server Enterprise all versions ; SAP Replication Server all versions

Keywords

CR828998, CR#828998, 828998, sysloginroles corruption , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Product Enhancement

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.