Symptom
- When doing auto re-materialization for master database, it will bcp out system security table 'sysloginroles' from primary, and then go to standby server and delete all entries in this table.
- This is dangerous, if bcp in fails due to any reason (for example, sybsecurity db is full), then no user can not log in standby ASE, login will fail or it will be redirect to primary directly.
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 Replication Server all versions
Keywords
CR828998, CR#828998, 828998, sysloginroles corruption , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , 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.