Symptom
- sybdbfm status reports:
node 1: server Server1, site SiteA.
db host status: OK.
db status DB INDOUBT hadr status PRIMARY.
node 2: server Server2, site SiteB.
db host status: OK.
db status DB INDOUBT hadr status STANDBY.
replication status: UNKNOWN. - dev_sybdbfm.log shows:
DB_STATUS=DB_ERROR
DB_DIAGNOSTICS=SAPSA user 'sa' failed to interact with the database (delete/insert). -
dev_sapdbctrl shows:
[PID 25870] ERROR AT sybServer.cpp:getDatabaseStatus:31945 TIME: 2020 Apr 23 15:07:55 DESCRIPTION: SAPSA user 'sa' is missing 'replication_role' in at least one replicated database LAST OS-ERROR: (0): Success
[PID 25870] ERROR AT sybOpenClient.cpp:executeQuery:2171 TIME: 2020 Apr 23 15:07:55 DESCRIPTION: Server message: Number 10353, Severity 14, State 4, Line 13, Server SID --- Message string: You must have any of the following role(s) to execute this command/procedure: 'replication_role'. Please contact a user with the appropriate role for help. LAST OS-ERROR: (0): Success
Read more...
Environment
- SAP Replication Server (SRS) 16.0
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
Product
Keywords
RepServer, RS, FM, DB_CONNECT/SYB/SADB_USER, CHADR , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
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.
SAP Knowledge Base Article - Preview